prompt =========================
prompt LIBRARY CACHE MISS RATIO
prompt =========================
prompt (If > .1, i.e., more than 1% of the pins resulted in reloads, then increase the shared_pool_size in init.ora)
prompt
column "LIBRARY CACHE MISS RATIO" format 99.9999
column "executions" format 999,999,999,999
column "Cache misses while executing" format 999,999,999,999
select sum(pins) "executions", sum(reloads) "Cache misses while executing",
(((sum(reloads)/sum(pins)))) "LIBRARY CACHE MISS RATIO"
from v$librarycache;
Sample Output:
Code: Select all
executions Cache misses while executing LIBRARY CACHE MISS RATIO
---------------- ---------------------------- ------------------------
53,509,388 90,948 .0017