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: 64109
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: Performance tuning of DDL?
Next Topic: query plan and negative value (-1) in where clause
Goto Forum:
  


Current Time: Mon Dec 05 06:31:35 CST 2016

Total time taken to generate the page: 0.15824 seconds