Re: relation shared pool elements phys mem

On 08/06/2004 05:30:26 AM, Jeroen van Sluisdam wrote:
> Hi,

> 1 memory segment. Is this correct and does this imply also this should be in
> phys memory also?
> I have a swapfile that is not used extensively.
>
> If I downsize my sga, should i decrease the size of the memory segments as
> well to profit from the
> decrease ?

If you cut down memory, cut down buffers first. You can also switch to MTS, which would save you a little bit of memory, especially if you configure large pool. As for swapfile, you don't want it to be used extensively, trust me.

-- 
Mladen Gogala
Oracle DBA
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------