| Buffer pool Hit% more than 100% [message #431182] |
Mon, 16 November 2009 01:19  |
DBA_SangramKeshari
Messages: 44
Registered: October 2009
Location: Mumbai
|
Member |
|
|
In one of my AWR Report under tab Instance Efficiency Percentages (Target 100%) , My Buffer Hit % is showing as 102.01 .
I am not able to understand how can this possible to more than 100%.
Please revert.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Buffer pool Hit% more than 100% [message #434152 is a reply to message #434112] |
Mon, 07 December 2009 08:21  |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
Why do you have such difficulty believing that something that Oracle ships could have a bug in it.
They're far from the worst offender in the IT industry, but some of the software they've shipped (Oracle DB v 10.1 for example) contained a noticable number of bugs.
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Buffer pool Hit% more than 100% [message #434246 is a reply to message #434222] |
Tue, 08 December 2009 02:20 |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
Quote:But we are using 10.2.0.4. Are you saying this also contains some bugs.? Yes
Think about this - your AWR report says that of all the blocks read, 102.01% of them came from the buffer cache.
This number cannot be correct. The script must be ignoring some set of blocks, or counting some blocks twice, or some similar error - what the exact error is doesn't affect the fact that in order to get that value there has to be an error in the calculation.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
