prompt =========================
prompt Library Cache Section
prompt =========================
prompt hit ratio should be > 85, and pin ratio > 90 ...
prompt
set pages 200
set lines 200
column "reloads" format 999,999,999
select namespace, trunc(gethitratio * 100) "Hit ratio",
trunc(pinhitratio * 100) "pin hit ratio", reloads "reloads"
from v$librarycache;
Sample Output:
Code: Select all
NAMESPACE Hit ratio pin hit ratio reloads
--------------- ---------- ------------- ------------
SQL AREA 50 90 43
TABLE/PROCEDURE 46 75 4
BODY 92 97 0
TRIGGER 77 97 0
INDEX 0 0 0
CLUSTER 91 96 0
OBJECT 100 100 0
PIPE 100 100 0
JAVA SOURCE 100 100 0
JAVA RESOURCE 100 100 0
JAVA DATA 100 100 0