Friday, January 22, 2010

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: ,

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home