Home » RDBMS Server » Performance Tuning » cache hit ratio
icon5.gif  cache hit ratio [message #247765] Wed, 27 June 2007 02:44 Go to next message
pratik25
Messages: 4
Registered: June 2007
Location: HYDERABAD
Junior Member
hi friend my database cache hit ratio show 70% and i think it should be greate than 95% i also increase the size of pga but i am facing same porblem
please help me
Re: cache hit ratio [message #247777 is a reply to message #247765] Wed, 27 June 2007 03:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
A database cache hit ratio of 95% is often a symptom of bad application.

Hit ratio can serve only one purpose: as an indicator to quickly check if YOUR workload changes (in the same database, the same server...).
You can't compare anything else.

Regards
Michel
Re: cache hit ratio [message #247824 is a reply to message #247765] Wed, 27 June 2007 05:39 Go to previous messageGo to next message
michael_bialik
Messages: 611
Registered: July 2006
Senior Member
Tune your SQL statements before doing anything else.

Michael
Re: cache hit ratio [message #247832 is a reply to message #247824] Wed, 27 June 2007 05:54 Go to previous messageGo to next message
pratik25
Messages: 4
Registered: June 2007
Location: HYDERABAD
Junior Member
hi sir please send me some query for tuning the sql i am new to oracle database (9i) thanx in add.
Re: cache hit ratio [message #247858 is a reply to message #247832] Wed, 27 June 2007 06:56 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no query to tune SQL.
Search which ones execute the more logical io using StatPack.

Regards
Michel
Previous Topic: Long Running SQL - NO entry in Session_LongOps view?
Next Topic: Help: Tuning Query
Goto Forum:
  


Current Time: Mon Dec 05 12:38:04 CST 2016

Total time taken to generate the page: 0.08586 seconds