|
|
|
|
Re: Database buffer cache monitoring [message #347854 is a reply to message #347850] |
Sun, 14 September 2008 10:55 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68678 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
10.2.0.4
4 numbers, if Oracle gives several numbers to define a version there is a reason, and if there is a reason then it is usful to know these several figures. Do you think there is no difference between 10.1 and 10.2?
By the way, this is requested in introduction of forum guide.
Regards
Michel
[Updated on: Sun, 14 September 2008 11:05] Report message to a moderator
|
|
|
Re: Database buffer cache monitoring [message #348266 is a reply to message #347829] |
Tue, 16 September 2008 04:18 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
JRowbottom
Messages: 5933 Registered: June 2006 Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
If you mean 'How do I check my Buffer Cache Hit ratio', then the best answer I can give is 'Don't Bother'
Monitoring it over a period of time can be useful, as it can indicate a trend towards increasing IO, but as a single figure, it's not a great deal of use.
The best yu can say for it is that if you are have pure OLTP application, and the BCHR is low, then you've proably got a problem -. Conversely, i is stil possibly to have very poorly performance on an OLTP database with a high BCHR, and of youve got a significant amount of Batch processing going on then it's no use whatsoever.
This Article shows you how to work it out, and also how to set it to whatever value you like.
|
|
|