I need help understanding how Oracle uses the OS buffer cache...

From: Shukle, Pranav <pshukle_at_epcor.ca>
Date: Fri, 21 Sep 2001 11:50:43 -0700
Message-ID: <F001.003950CC.20010921113027@fatcity.com>

Hi Everyone,
We have been experiencing some I/O issues; and the systems support team (HP) thinks that we should bump up our OS buffer cache. Currently we are sitting at 150MB; after researching on Metalink the recommendation from Oracle for HPUX is to have a max of 128MB of buffer cache. I have been trying to find a document to help me understand how Oracle uses this buffer cache, and even have opened up a TAR with Oracle; but does anyone know of a document or a book which would help me understand this? Metalink docs say that the buffer cache should be set to <=128MB to avoid "losing writes"; I cannot make sense of this statement. Could someone help me with this?
We have HPUX 11.0 with 3 550MHZ CPU's and 4GB of memory running SIEBEL's CRM plus a couple of other databases; does anyone else have similar configuration? If so, what is your buffer cache, and why have you set it so?
Any help would greatly be appreciated.
Thanks,
Pranav Shukle
Database Administrator
EPCOR Information Services
780-412-3052

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Shukle, Pranav
  INET: pshukle_at_epcor.ca

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Sep 21 2001 - 13:50:43 CDT