Result Cache Not Used In Even Force Mode For SQLs Involved in PL/SQL Function Called From Top-Level SQL

(Doc ID 2129403.1)

Last updated on APRIL 22, 2016

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


R e s u l t C a c h e M e m o r y R e p o r t
Block Size = 1K bytes
Maximum Cache Size = 300M bytes (300K blocks)
Maximum Result Size = 15M bytes (15K blocks)
Total Memory = 11896 bytes [0.000% of the Shared Pool]
... Fixed Memory = 11896 bytes [0.000% of the Shared Pool]
....... Memory Mgr = 200 bytes
....... Cache Mgr = 208 bytes
....... = 1136 bytes
....... Bloom Fltr = 2K bytes
....... RAC Cbk = 5408 bytes
....... State Objs = 2896 bytes
... Dynamic Memory = 0 bytes [0.000% of the Shared Pool]

PL/SQL procedure successfully completed.



Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms