Database Administration (MOSC)

MOSC Banner

Efficiency Percentages

edited Apr 22, 2013 3:45AM in Database Administration (MOSC) 30 commentsAnswered ✓
Hi,on 11g R2 we ran an AWR report that gives the following :

Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
            Buffer Nowait %:  100.00       Redo NoWait %:  100.00
            Buffer  Hit   %:   98.40    In-memory Sort %:  100.00
            Library Hit   %:   90.19        Soft Parse %:   38.95
         Execute to Parse %:   96.04         Latch Hit %:   99.99
Parse CPU to Parse Elapsd %:   73.06     % Non-Parse CPU:   76.07

 Shared Pool Statistics        Begin    End
                              ------  ------
             Memory Usage %:   79.84   77.98
    % SQL with executions>1:   90.71   91.49
  % Memory for SQL w/exec>1:   98.14   98.49

Are they efficient values ?

Thanks and regards.

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