Re: Oracle question from a Sys. admin, re: Solaris performance

>The trick with managing the instances is to balance memory use with
>physical reads. Not enough memory allocated to an instance will cause
>increased physical reads which impacts all other databases on the same
>mountpoints. But, too much memory allocated can cause excessive paging
>or swapping, so you need to balance this out.

I don't understand this statement; I can see not enough memory causing increased reads, but how could too much memory cause paging? Inst paging caused by *lack* of memory?

Unless Oracle is doing something different with real memory and swap that I am not aware of... Received on Fri Mar 04 2005 - 10:09:15 CST