Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: So how big is your buffer cache ?

RE: So how big is your buffer cache ?

From: Cary Millsap <cary.millsap_at_hotsos.com>
Date: Mon, 30 Aug 2004 09:44:45 -0500
Message-ID: <03ad01c48e9f$e79a4d50$6701a8c0@CVMLAP02>


:)

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Gogala, Mladen
Sent: Monday, August 30, 2004 9:38 AM
To: 'oracle-l_at_freelists.org'
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_at_hotsos.com]
> Sent: Monday, August 30, 2004 10:21 AM
> To: oracle-l_at_freelists.org
> 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_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://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_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------
Received on Mon Aug 30 2004 - 09:43:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US