Re: Oracle won't relax when not being used.

Since the IO is so small, I would believe that it's the DBWR checkpoint causing it. I would expect larger IO amounts if the server were thrashing.

It's not impossible that the server's working set can be below 256M. Improbable maybe, but not impossible. If the server's scope is very narrow or does not change frequently, paging would be minimal. And this is exactly the case when a server is mostly idle.

I would agree, though, that you may be running too close to the edge. Are you allowing for spikes in your processing load, database usage growth and non-database usage growth? All will put demands on memory outside of the SGA. Also, don't oversize the SGA. You may be wasting memory that can be better utilized somewhere else.

<johnt_at_tman.dnsalias.com> wrote in message news:bwRH7.3097$lY5.2310591_at_newssvr28.news.prodigy.com...
>
> > Also the OP is devoting 500 out of 756 M to the SGA, so he must have
> > excessive paging.
>
> > Regards
>
> I (OP) hope not, I have sized the SGA to be as big as I can w/o running
> into very much paging... I can tell via the si/so (swap in/swap out) cols
> in vmstat that there is not a whole lot of paging going on.
>
> Thanks,
> JT.
>
>
Received on Mon Nov 12 2001 - 10:01:22 CST