| Negative Values of Library Cache Hit Ratio in AWR Report [message #562131] |
Sun, 29 July 2012 03:34  |
 |
mail.madhankumar
Messages: 11
Registered: July 2012
Location: coimbatore
|
Junior Member |
|
|
Hi Friends,
We are getting Negative values of Library cache hit ratio in AWR Report of 11g(11.2.0.3) with Solaris[tm] OE (64-bit).
Please suggest us why it shows negative value.
Instance Efficiency Percentages (Target 100%)
Buffer Nowait %: 99.87 Redo NoWait %: 99.99
Buffer Hit %: 92.17 In-memory Sort %: 100.00
Library Hit %: -3,321.23 Soft Parse %: 81.95
Execute to Parse %: 92.88 Latch Hit %: 95.11
Parse CPU to Parse Elapsd %: 87.25 % Non-Parse CPU: 81.39
|
|
|
|
|
|
|
|
| Re: Negative Values of Library Cache Hit Ratio in AWR Report [message #562135 is a reply to message #562134] |
Sun, 29 July 2012 06:42  |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Quote:Is it bug in AWR Report?.
Maybe yes, maybe no, I gave you the way to verify this.
Quote:when i check v$rowcache view it's gets value is in negative for dc_users and dc_tablespaces parameter...
So seems the counters wrap.
Many Oracle internal counters are still in 32-bit even on 64-bit hardware, OS and Oracle version.
it is not a bug, it is a limit and the workaround is to restart the instance.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
