OraFAQ Forum: Performance Tuning » 99% Hit-Ratio but poor performance

Home » RDBMS Server » Performance Tuning » 99% Hit-Ratio but poor performance

Thu, 05 July 2007 00:28

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

Thu, 05 July 2007 00:33

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

BCHR is a mythical indicator of performance as you can testify.

Thu, 05 July 2007 01:03

Michel Cadot
Messages: 68658
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

Sat, 07 July 2007 05:04

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: Sat Jun 01 06:25:34 CDT 2024