Database Tuning (MOSC)

MOSC Banner

"Latch Hit %" is over 100 on statspack report

edited Dec 11, 2014 10:00AM in Database Tuning (MOSC) 3 commentsAnswered

Hi all,

I have a question about "Latch Hit %" on "Instance Efficiency" section in the statspack report.

My report says that Latch Hit % is 100.92.  This should be under 100.  Is it possible that Latch Hit % is over 100?  Why is Latch Hit % over 100?

My report says:

----------------------------------

Instance Efficiency Indicators

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

        Buffer Nowait %:  100.00       Redo NoWait %:  100.00

        Buffer  Hit   %:  100.00  Optimal W/A Exec %:  100.00

        Library Hit   %:   97.27        Soft Parse %:   97.35

     Execute to Parse %:   42.83         Latch Hit %:  100.92 

Parse CPU to Parse Elapsd %:   99.75     % Non-Parse CPU:   90.69

----------------------------------

Thanks in advance,

Akiko

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