Re: Concurrent i/o

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Tue, 8 Nov 2005 21:02:02 +0100
Message-ID: <4371043b$0$10955$ba620e4c@news.skynet.be>

>
> If "concurrent" is equivalent to "direct" IO, then you'll want to ensure
> that your buffer cache is sized appropriately. Many people have
> converted to raw (or equivalent) and been disappointed because they have
> not taken the loss of file system cache into account (and increased
> their buffer cache accordingly)
>
> hth
>
> --
> Connor McDonald
> Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
> Co-author: "Oracle Insight - Tales of the OakTable"
>
> web: http://www.oracledba.co.uk
> web: http://www.oaktable.net
> email: connor_mcdonald_at_yahoo.com
>
>

What do you mean exactly ? I don't see why disabling the UNIX cache would require increasing the Oracle buffer cache ? After all, Oracle doesn't really read from the UNIX cache, right ? It always uses its own memory structures (SGA, PGA), no ?

Matthias Received on Tue Nov 08 2005 - 14:02:02 CST