RE: os cache vs. db cache
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <robyn.sands@xxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 9 Jul 2007 15:03:21 -0400
Hi Robyn,
This is pretty dated, but still accurate, I think:
http://www.ixora.com.au/tips/avoid_buffered_io.htm
-Mark
--
Mark J. Bobak
Senior Database Administrator, System & Product Technologies
ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346
Ann Arbor MI 48106-1346
734.997.4059 or 800.521.0600 x 4059
mark.bobak@xxxxxxxxxxxxxxx <mailto:mark.bobak@xxxxxxxxxxxxxxx>
www.proquest.com <http://www.proquest.com>
www.csa.com <http://www.csa.com>
ProQuest...Start here.
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Robyn
Sent: Monday, July 09, 2007 2:04 PM
To: oracle-l
Subject: os cache vs. db cache
Hello everyone,
Over the years, I've read differing opinions on balancing the os cache
and the database cache. Seems like I remember there were some advocates
for minimizing the os cache and maximizing the database cache to allow
Oracle to better determine which blocks should truly be cached and avoid
necessary blocks being cached because they were in proximity to hot
data. I also have heard opposite opinions.
I'm specifically focused on performance for a data warehouse. Has
anyone tested performance with a minimized OS cache and a maximized
database cache? If so, what were the results? Does anyone have a
really good paper or book on the topic? I'm trying to collect some
information before I start discussions with the platforms guys.
tia ... Robyn
Other related posts:
