RE: ora-04031

From: Hitchman, Peter <Peter.Hitchman_at_thomson.com>
Date: Tue, 14 Dec 2004 22:52:16 -0000
Message-ID: <8D697B8FCEBB3744B3A1E4AE15E8331E4B88AB@der-lon-msg-03.derwent.co.uk>

Hi,
Try "alter system flush shared_pool", this will clear the pool of any entries Oracle no longer needs.

Regards

Pete

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Chen, Sarah
Sent: 14 December 2004 22:33
To: 'oracle-l_at_freelists.org'
Subject: ora-04031

Good afternoon

I got

ORA-04031: unable to allocate 27160 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","session param values")

on the produciton database and no new session can connect to database. Any immediate action can take to solve the problem? Any help. Thanks

Sarah Chen
--

http://www.freelists.org/webpage/oracle-l

---

This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email

---

--

http://www.freelists.org/webpage/oracle-l Received on Tue Dec 14 2004 - 16:53:39 CST