Home » RDBMS Server » Performance Tuning » increasing cache hit ratio (oracle,10g,win xp)
increasing cache hit ratio [message #292192] Tue, 08 January 2008 03:23 Go to next message
sd_md_rizwan@yahoo.com
Messages: 37
Registered: September 2007
Location: Saudi Arabia
Member

how can i increase my database cache hit ratio to 100
Re: increasing cache hit ratio [message #292206 is a reply to message #292192] Tue, 08 January 2008 03:50 Go to previous messageGo to next message
orafan23
Messages: 13
Registered: December 2005
Junior Member
http://www.oracledba.co.uk/tips/choose.htm

Choose any ratio you want from - Connor McDonald’s site.
Re: increasing cache hit ratio [message #292207 is a reply to message #292192] Tue, 08 January 2008 03:51 Go to previous message
Michel Cadot
Messages: 65148
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

how can i increase my database cache hit ratio to 100

Read again and again the same blocks.

Regards
Michel
Previous Topic: Merge join verse Filter. Same code, different database, different explain plan
Next Topic: How get full data from table
Goto Forum:
  


Current Time: Mon Aug 21 12:54:50 CDT 2017

Total time taken to generate the page: 0.01492 seconds