RE: So how big is your buffer cache ?
- From: April Wells <AWells@xxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 30 Aug 2004 09:05:28 -0500
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
You will recognize your own path when you come upon it, because you will
suddenly have all the energy and imagination you will ever need.
~ Jerry Gillies ~
-----Original Message-----
From: Gogala, Mladen [mailto:--
Sent: Monday, August 30, 2004 8:53 AM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: So how big is your buffer cache ?
> -----Original Message-----
> From: April Wells [mailto:AWells@xxxxxxxxxx]
> Sent: Monday, August 30, 2004 8:23 AM
> To: 'oracle-l@xxxxxxxxxxxxx'
> Subject: RE: So how big is your buffer cache ?
>
>
> But really people...
>
> What does it matter in the long run... size doesn't matter
> anyway, right?
That's the first time I see a lady say that. I thought it was a
consolation of us, middle-aged, chubby DBA males. Joking aside,
the buffer cache should be increased using the same principle
as for everything else: you increase the buffer size when you start
seeing free buffer waits in your V$SYSTEM_EVENT. The basic principle
of the event-based tuning methodology is to try fixing that what
sessions are actually waiting for, instead of computing BCHR,
horoscope or your personal lucky number.
--
Mladen Gogala
A & E TV Network
Ext. 1216
----------------------------------------------------------------
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
-----------------------------------------------------------------
The information contained in this communication,
including attachments, is strictly confidential
and for the intended use of the addressee only;
it may also contain proprietary, price sensitive,
or legally privileged information. Notice is hereby
given that any disclosure, distribution, dissemination,
use, or copying of the information by anyone other
than the intended recipient is strictly prohibited
and may be illegal. If you have received this communication
in error, please notify the sender immediately by
reply e-mail, delete this communication, and destroy
all copies.
Corporate Systems, Inc. has taken reasonable precautions
to ensure that any attachment to this e-mail has been
swept for viruses. We specifically disclaim all liability
and will accept no responsibility for damage sustained
as a result of software viruses and advise you to carry
out your own virus checks before opening any attachment.
----------------------------------------------------------------
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:
