Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> I need help understanding how Oracle uses the OS buffer cache...
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