Home » RDBMS Server » Performance Tuning » Database Buffer Cache
Database Buffer Cache [message #65559] Thu, 28 October 2004 05:16 Go to next message
Kathy Kerler
Messages: 1
Registered: October 2004
Junior Member
We have a cache hit ratio of approximately 84% for our database buffer cache.  We are considering increasing the db_block_buffers parameter in our init.ora to improve this ratio.  I do want to find out if any one can clarify something for me first:  Do queries that do sorts use the database buffer cache, or does the "order by" command cause the database buffer cache to be bypassed.  We are currently using Oracle 8.1.6 on a box running Solaris 8.

Any information on this would be greatly appreciated.
Re: Database Buffer Cache [message #65560 is a reply to message #65559] Thu, 28 October 2004 05:46 Go to previous message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
considering database buffer cache hit ratio as measure for tuning is COMPLETELY flawed.

You can get whatever hitratio YOU WANT.

SO, increasing db_blocks_buffer ( based on hitratio) may have a negative impact.

Please read this.
http://www.orafaq.com/forum/t/23453/0/

[Updated on: Fri, 18 February 2005 23:32]

Report message to a moderator

Previous Topic: Leading hint
Next Topic: Cycling alert log
Goto Forum:
  


Current Time: Wed Sep 23 13:46:46 CDT 2020