Re: filesystemio_options setting

I dont think this is the cause. The degradation in performance was immediate, not gradual as I would have expected if it was a caching problem.

On Sun, May 18, 2008 at 12:58 AM, Yechiel Adar <adar666_at_inter.net.il> wrote:

> That assumption is not mentioned in the original msg.
> He just said that he change the setall parameter and I assumed that he left
> everything else as is.
> Maybe he will tell us if he increased the buffer pool or not.
>
> Adar Yechiel
> Rechovot, Israel
>
>
>
> Finn Jorgensen wrote:
>
>> The assumption we've all been making here is that by going to direct
>> IO you move the part of memory that had been used as a filesystem
>> cache to the SGA/db cache.
>> Thanks,
>> Finn
>>
>>
>>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l