"Latch Hit %" is over 100 on statspack report
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