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

Report message to a moderator

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.

Report message to a moderator

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: 68665
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

Report message to a moderator

Previous Topic: Performance tuning of DDL?
Next Topic: query plan and negative value (-1) in where clause
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jun 28 05:59:44 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.