Re: Problem with cache usage -> very bad performance?

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Mon, 24 Feb 2003 23:45:09 +0100
Message-ID: <ht7l5vcq1uja03ocn2guenb23inia4t9mv@4ax.com>

On 24 Feb 2003 22:20:22 +0100, plm_at_gmx.li wrote:

>How does Oracle 9i deal with physical files? Does it somehow disable
>the Solaris filesystem cache (could make sense to guarantee
>consistency on disk after commits and because Oracle already does its
>own buffering)? That is, should we set db_block_buffers with this in
>mind?

Oracle 9i doesn't disable the Solaris filesystem cache and one could only wish it *did*, because having a cache in Oracle and in Solaris doesn't make sense, especially while the Solaris file cache is paged as is the Oracle cache.
If you are running on vfs filesystems *disable* the file cache by mounting your filesystems with forcedirectio. I have seen examples of Solaris eating up all available RAM for file cache purposes.

Other than that I agree with Daniel your post comes down to 'It doesn't work' and you don't provide any appropiate clues.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Feb 24 2003 - 16:45:09 CST