RE: ora-04031
- From: "Bill Coulam" <bill.coulam@xxxxxxxx>
- To: <Sarah_Chen@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 14 Dec 2004 17:02:38 -0600
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Chen, Sarah
Sent: Tuesday, December 14, 2004 4:33 PM
To: 'oracle-l@xxxxxxxxxxxxx'
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
