I agree with Mark on this. I had this problem on a 8.1.7.0 and it was solved after the upgrade. (8.1.7.3)
If you're already above 8.1.7.3, the problem could be fragmentation. Are you having any contention in the shared pool latch? greetings DC ----- Original Message ----- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, September 12, 2002 2:08 AM Um, version? (To at least 4 places, please!) On the off change you are on 8.1.7.x, where x < 3, please upgrade to 8.1.7.4. There were several bugs related to ORA-4031 from 8.1.7.0 through at least 8.1.7.2. -Mark On Wed, 2002-09-11 at 18:14, Seema Singh wrote: > Hi > One of instance are showing ORA-04031 error more frequntly(2 times in a > week).I increased SGA ,pinned some of DBMS packages,flush SGA etc but all > these are not helping at all.Let me know what could be look next. > Thx > -Seema > > > > _________________________________________________________________ > Join the world's largest e-mail service with MSN Hotmail. > http://www.hotmail.com > -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] "It is not enough to have a good mind. The main thing is to use it well." -- Rene Descartes -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark J. Bobak INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Diego Cutrone INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
