Home » RDBMS Server » Performance Tuning » 99% Hit-Ratio but poor performance
99% Hit-Ratio but poor performance [message #249549] Thu, 05 July 2007 00:28 Go to next message
naveenkumar001
Messages: 62
Registered: July 2007
Location: Bangalore
Member

Hi,

Can anyone please help me in this matter.
In v$buffer_pool_statistics i found 99% hit ratio but the performance is poor?

Regards,
Naveen
Re: 99% Hit-Ratio but poor performance [message #249551 is a reply to message #249549] Thu, 05 July 2007 00:33 Go to previous messageGo to next message
BlackSwan
Messages: 25040
Registered: January 2009
Location: SoCal
Senior Member
BCHR is a mythical indicator of performance as you can testify.
Re: 99% Hit-Ratio but poor performance [message #249559 is a reply to message #249549] Thu, 05 July 2007 01:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
99% of hit ratio is a clue a very poor tuned application.
So review the code and tune the application.

Regards
Michel

Re: 99% Hit-Ratio but poor performance [message #250045 is a reply to message #249549] Sat, 07 July 2007 05:04 Go to previous message
gintsp
Messages: 118
Registered: February 2007
Senior Member
Go to http://www.hotsos.com browse library and especially article why 99% hit ratio is not OK.

Gints Plivna
http://www.gplivna.eu
Previous Topic: New Server but performance still the same
Next Topic: Help : Understanding the Explain Plan
Goto Forum:
  


Current Time: Tue Dec 06 00:18:46 CST 2016

Total time taken to generate the page: 0.11404 seconds