| database buffer cache [message #313022] |
Thu, 10 April 2008 07:04  |
balaji1482
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  |
JRowbottom
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
