RE: So how big is your buffer cache ?
- From: "Cary Millsap" <cary.millsap@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 30 Aug 2004 09:44:45 -0500
:)
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
* Nullius in verba *
Upcoming events:
- Performance Diagnosis 101: 9/14 San Francisco, 10/5 Charlotte, 10/26
Toronto
- SQL Optimization 101: 8/16 Minneapolis, 9/20 Hartford, 10/18 New Orleans
- Hotsos Symposium 2005: March 6-10 Dallas
- Visit www.hotsos.com for schedule details...
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Gogala, Mladen
Sent: Monday, August 30, 2004 9:38 AM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: So how big is your buffer cache ?
Well, free buffer waits mean that the waiting session is waiting on
free buffer. It can be waiting because there isn't a sufficient number of
buffers, or it can wait for DBWR write buffers to the data file. Of course,
it needs to be investigated, but if the buffer cache is too small, then
waits will not be grouped around a small set of tables used by many users,
but will be more randomly distributed. Specifically, to answer your
question, increasing buffer cache will help in cases when the session is
waiting for any free buffer, and it can't get it, because there simply
aren't enough to go around. I don't recommend increasing DB_BUFFER_CACHE
whenever you see a single free buffer wait, but seeing that event on a
regular basis will warrant an investigation. One of the results of such
investigation might be a recommendation for a larger buffer cache.
--
Mladen Gogala
A & E TV Network
Ext. 1216
> -----Original Message-----
> From: Cary Millsap [mailto:cary.millsap@xxxxxxxxxx]
> Sent: Monday, August 30, 2004 10:21 AM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: RE: So how big is your buffer cache ?
>
>
> But, whoa, wait! Seeing 'free buffer waits' waits in your
> session is an indication that your session is waiting for
> DBWR to do its job. How does increasing the database buffer
> cache size help the DBWR do its job more efficiently?! It doesn't.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
