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 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

SQL> execute DBMS_RESULT_CACHE.MEMORY_REPORT(TRUE);
R e s u l t C a c h e M e m o r y R e p o r t
[Parameters]
Block Size = 1K bytes
Maximum Cache Size = 300M bytes (300K blocks)
Maximum Result Size = 15M bytes (15K blocks)
[Memory]
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.

  

Cause

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