5-12
Copyright Ó Oracle Corporation, 1999. All rights reserved.
Executes PROC1—>First pin, 1 load
Executes
PROC1—>Second
pin, no reload
Executes PROC1—>Third pin, no reload
Executes PROC1—>Fourth pin, no reload
Guidelines: Library Cache Reloads
Reloads
should:
•Ideally be 0
•Never be more than 1% of the
pins
4 pins and 0
reload
SQL> select sum(pins) "Executions", sum(reloads)
2
"Cache Misses", sum(reloads)/sum(pins)
3 from v$librarycache;
Executions Cache Misses sum(reloads)/sum(pins)
---------- ------------ ----------------------
2641 10 .00378644