RE: ora-04031

Flush the shared pool and then perhaps increase your shared pool and large pool?

Heading out the door, so not much more help than what you've probably already found:
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab ase_id=NOT&p_id=146599.1

Always remember to share pertinent environmental facts as well as anything that recently changed, e.g. database version, whether PGA (auto mem mgmt) is used or not, shared or dedicated server, etc. This'll help the real gurus here.

• bill c.

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

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Chen, Sarah Sent: Tuesday, December 14, 2004 4:33 PM 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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Dec 14 2004 - 17:03:18 CST