Database Reference
In-Depth Information
Workshop
Let's discuss this feature in an Oracle RAC environment step by step through a workshop.
Step 1
Let's check how much buffer has been allocated to the result cache section and how much is currently available.
The current utilization of the result cache section of the shared pool can be determined using the following:
SQL>SET SERVEROUTPUT ON;
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 = 251680K bytes (251680 blocks)
Maximum Result Size = 12584K bytes (12584 blocks)
[Memory]
Total Memory = 12784 bytes [0.000% of the Shared Pool]
... Fixed Memory = 12784 bytes [0.000% of the Shared Pool]
....... Memory Mgr = 200 bytes
....... Bloom Fltr = 2K bytes
....... = 2088 bytes
....... Cache Mgr = 5552 bytes
....... State Objs = 2896 bytes
... Dynamic Memory = 0 bytes [0.000% of the Shared Pool]
The result cache section of the shared pool can also be verified by querying against the v$sgastat view.
SELECT *
FROM gv$sgastat
WHERE pool = 'shared pool'
AND NAME LIKE 'Result%'
AND inst_id = 1;
INST_ID POOL NAME BYTES
------- ------------ ---------------------------------- ----------
1 shared pool Result Cache: State Objs 2896
1 shared pool Result Cache: Memory Mgr 200
1 shared pool Result Cache: 2088
1 shared pool Result Cache: Cache Mgr 5552
1 shared pool Result Cache: Bloom Fltr 2048
The output above and the output generated by the memory report earlier indicate identical statistics.
From the output above, notice that no memory of the shared pool has been allocated to the result cache section
(0.000% of the shared pool ) . The result cache is allocated from the dynamic memory section of the shared pool.
 
Search WWH ::




Custom Search