Optimal buffer cache size
- From: "Tracy Rahmlow" <tracy.rahmlow@xxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 8 Jun 2004 10:25:37 -0500
I am looking for some information (white papers?) regarding the process for
setting an optimal buffer cache. This is not in an effort to achieve
a 99% bchr but rather to determine whether or not the current cache is
over or under allocated. If idle ram is available should it be allocated
to the buffer cache? Is the buffer cache as important in a DW environment
vs an OLTP environment? Thanks
American Express made the following
annotations on 06/08/2004 08:25:20 AM
------------------------------------------------------------------------------
******************************************************************************
"This message and any attachments are solely for the intended recipient
and may contain confidential or privileged information. If you are not the
intended recipient, any disclosure, copying, use, or distribution of the
information included in this message and any attachments is prohibited. If you
have received this communication in error, please notify us by reply e-mail and
immediately and permanently delete this message and any attachments. Thank
you."
******************************************************************************
==============================================================================
Other related posts:
- » Optimal buffer cache size
