RE: os cache vs. db cache

If you are on 10g you should consider using ASM for storage. If you do this
issue goes away altogether since there are no filesystems involved.
 
 
 
Randy Johnson
Sr. Technical Consultant
Enkitec, LLP

Office ..... 817-255-3580
Mobile .... 817-564-6583
Email ..... HYPERLINK
"mailto:randy.johnson@xxxxxxxxxxx"randy.johnson@xxxxxxxxxxx 

 

   _____  

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Robyn
Sent: Monday, July 09, 2007 1: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



No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.476 / Virus Database: 269.10.2/891 - Release Date: 7/8/2007
6:32 PM



No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.476 / Virus Database: 269.10.2/891 - Release Date: 7/8/2007
6:32 PM

Other related posts: