Shared pool size advisory query for ORA-04031
Wednesday, April 4, 2012
set lines 140
set pages 999
col shared_pool_size_for_estimate format 999,999,999,999 head "Shared Pool Size (MB)"
col shared_pool_size_factor head "Size Factor"
col estd_lc_memory_object_hits format 999,999,999,999 head "Estimated Hits in Library Cache"
col estd_lc_size format 999,999,999,999 head "Estimate of LC Size"
col estd_lc_memory_objects format 999,999,999,999 head "Estimate of objects in LC"
select
shared_pool_size_for_estimate,
shared_pool_size_factor,
estd_lc_memory_object_hits,
estd_lc_size, estd_lc_memory_objects
from v$shared_pool_advice
order by shared_pool_size_factor
/
spool off
Shared Pool Size (MB) Size Factor Estimated Hits in Library Cache Estimate of LC Size Estimate of objects in LC
--------------------- ----------- ------------------------------- ------------------- -------------------------
76 .76 68,187,490 2 260
88 .88 68,648,484 2 264
100 1 69,010,663 2 271
112 1.12 69,315,838 13 875
124 1.24 69,595,314 24 1,615
136 1.36 69,845,167 36 2,367
148 1.48 70,073,492 47 3,295
160 1.6 70,286,803 58 3,916
172 1.72 70,466,918 69 4,580
184 1.84 70,615,968 80 5,202
Labels: Shared pool size advisory query for ORA-04031
0 comments:
Subscribe to:
Post Comments (Atom)
Powered by Blogger.