Home » RDBMS Server » Performance Tuning » Database buffer cache monitoring (Oracle 10g,solaris)
Database buffer cache monitoring [message #347829] Sun, 14 September 2008 07:16 Go to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

can anybody tell me how to monitor database buffer cache?

Regards,
Balaji

[Updated on: Sun, 14 September 2008 07:16]

Report message to a moderator

Re: Database buffer cache monitoring [message #347832 is a reply to message #347829] Sun, 14 September 2008 08:48 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guidelines as stated in URL above

[Updated on: Sun, 14 September 2008 08:48] by Moderator

Report message to a moderator

Re: Database buffer cache monitoring [message #347834 is a reply to message #347829] Sun, 14 September 2008 08:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Explain what you mean.

And you still don't understand what "4 decimals" means.

Regards
Michel

[Updated on: Sun, 14 September 2008 08:54]

Report message to a moderator

Re: Database buffer cache monitoring [message #347850 is a reply to message #347834] Sun, 14 September 2008 10:38 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

i really dont understand what exactly is 4 decimal means? Please tell me what it is??



Re: Database buffer cache monitoring [message #347854 is a reply to message #347850] Sun, 14 September 2008 10:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
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
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.
Previous Topic: Problem with SQL Plan
Next Topic: Low oracle performance
Goto Forum:
  


Current Time: Thu Dec 08 20:11:01 CST 2016

Total time taken to generate the page: 0.14822 seconds