Database Tuning (MOSC)

MOSC Banner

Library Cache Get Hit Ratio Is Always Low

edited Mar 24, 2015 10:05AM in Database Tuning (MOSC) 7 commentsAnswered
Hello,

1 Buffer Cache Hit Ratio         99.92
         1 Chained Row Ratio              .01
         1 Database CPU Time Ratio        98.932
                                          123135
                                          3539

         1 Database Wait Time Ratio       1.0678
                                          768646
                                          4606

         1 Dictionary Cache Hit Ratio     99.54
         1 Execute Parse Ratio            85.35
         1 Get Hit Ratio                  6.09
         1 Latch Hit Ratio                100
         1 Library Cache Hit Ratio        99.97
         1 Parse CPU to Elapsed Ratio     99.33
         1 Pin Hit Ratio                  97.49
         1 Soft-Parse Ratio               94.14

Above is from my DB instance(Oracle 10.2.0.4 EE) on Windows Server 2008. I run a sql script to get this.  Get hit ratio is always below 10% no matter when I test it. What part should I tune? Recently I have done Keep Pool sizing,and monitoring,database buffer sizing and monitoring, set session_chached_cursor=100,rowed chained removed,defragmented indexes rebuild , shared pool sizing and monitoring etc.  I don't use AMM(automatica SGA Memeory Management).

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center