Hi, I have an undersized development box where my main problem is the memory I regularly get ERROR: ORA-04031: unable to allocate 48 bytes of shared memory ("large pool","unknown object","session heap","UGA heap pool") I have a shortage of phys memory. I remember that the complete SGA should fit into 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 ? Regards, Jeroen ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------