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
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
