Finding the Library Cache hit ratio
SELECT SUM(PINS) "EXECUTIONS",SUM(RELOADS) "CACHE MISSES WHILE EXECUTING"
FROM V$LIBRARYCACHE;
If the ratio of misses to executions is more than 1%, then try to reduce the library cache misses.
Labels: Performance Tuning, v$librarycache
0 Comments:
Post a Comment
Subscribe to Post Comments [Atom]
<< Home