How to reduce cached memory? Oracle

Gregory Maxwell gmaxwell at gmail.com
Mon Feb 9 08:06:43 UTC 2009


On Mon, Feb 9, 2009 at 12:43 AM, Jerry Williams <jwilliam at xmission.com> wrote:
> What about when you are running an Oracle database and don't want to cache
> the database files twice, once by the database it's self and once because
> the OS has ram.
> Then you get a double hit when you are looking for something.
> Once against the file system cache and then you hit the database.
> Is there a way to tune for this?

RTFOM (read the fine oracle manual), I'm sure it has many nice bits of
tuning advice. :)

I'm reasonably confident that Oracle uses o_direct, thus bypassing the
cache in any case. If it isn't and it is doing its own caching, then
it should be.




More information about the devel mailing list