RE: ora-04031
- From: "Hollis, Les" <Les.Hollis@xxxxxx>
- To: <Sarah_Chen@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 14 Dec 2004 16:48:43 -0600
Log in / as sysdba
Alter system flush shared_pool;
And maybe it will free some room for you....
-----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=20
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:
