Oracle-L: RE: ORA-04031

From: Reardon, Bruce (CALBBAY) <Bruce.Reardon_at_comalco.riotinto.com.au>
Date: Wed, 30 Oct 2002 14:29:10 -0800
Message-ID: <F001.004F7FDC.20021030142910@fatcity.com>

Robin,

I will copy this reply to the Oracle list as there are many more experienced people there.

Have you followed the steps in Metalink note 146599.1? If so, what results did you get from the various queries? Try posting them to the Oracle-L list.

After looking at those query results and if the answer isn't obvious, you may want to consider adding an event (eg "4031 trace name errorstack level 3") to dump a level 3 errorstack when an ora-4031 occurs.. This errorstack could be interpreted by Oracle support or others (not by me) to help determine the reason for your error.

Hope this helps,
Bruce Reardon

-----Original Message-----
Sent: Thursday, 31 October 2002 3:10 AM
To: Reardon, Bruce (CALBBAY)

http://orafaq.net/archive/oracle-l/2002/04/22/062319.htm hi,
I look at this article and I have the same problem. I am stand alone on this database with a big SGA and sometime I receive the ORA-04031. The version is 8.1.7.4 on Unix AIX. How do you correct this problem ?
Please reply
Robin
robin.tremblay_at_cognicase.ca
CANADA
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Reardon, Bruce (CALBBAY)
INET: Bruce.Reardon_at_comalco.riotinto.com.au

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Oct 30 2002 - 16:29:10 CST