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: Cursor_Sharing settings not working (merged)
Next Topic: regarding update on million of records
Goto Forum:

Current Time: Thu Oct 27 20:22:00 CDT 2016

Total time taken to generate the page: 0.09480 seconds