Home » RDBMS Server » Performance Tuning » database buffer cache (10g)
database buffer cache [message #313022] Thu, 10 April 2008 07:04 Go to next message
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

as we all know Database buffers store the most recently used blocks of data. The set of database buffers in an instance is the database buffer cache. The buffer cache contains modified as well as unmodified blocks. Because the most recently (and often, the most frequently) used data is kept in memory, less disk I/O is necessary, and performance is improved.

"my question is how do we come to an conclusion to increase the size of database buffer cache"
Re: database buffer cache [message #313062 is a reply to message #313022] Thu, 10 April 2008 09:30 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
The simplest way is to set the system parameter DB_CACHE_ADVICE, and have a look at the view v$db_cache_advice aftehr the system has been running for a while.

This will give a good indication of the degree of improvement to the physical IO that you'll get from increasing the cache size.
Previous Topic: query tuning using explain plan
Next Topic: Find a correct value for PGA_AGGREGATE_TARGET
Goto Forum:

Current Time: Tue Aug 22 02:30:27 CDT 2017

Total time taken to generate the page: 0.04604 seconds