relation shared pool elements phys mem

From: Jeroen van Sluisdam <jeroen.van.sluisdam_at_vrijuit.nl>
Date: Fri, 6 Aug 2004 11:30:26 +0200
Message-ID: <727A513477946E4380C23DD63C36FCC0F04513@pedro.vrijuit.nl>

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_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

---

Received on Fri Aug 06 2004 - 04:22:42 CDT