You might like to take a look at the following 2 links and work through the information contained within them.
diagnosing ora-4031_errors on Metalink at http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=146599.1 Also see http://www.zoftware.org/tuning/tune_shared_pool.html#fixed_table (Tim Gorman pointed this out on 16-May when he found it using the very good search facilities at www.ixora.com.au) You may also want to search the list archives - there are numerous ways: http://www.fatcity.com/ListGuru/my.php http://faqchest.dynhost.com/prgm/oracle-l/ http://www.mail-archive.com/oracle-l%40fatcity.com/ <-- this has them threaded and is a nice web interface to viewing the messages as well Regards, Bruce Reardon -----Original Message----- Sent: Tuesday, 21 May 2002 10:38 There is not a single segment of memory large enough for you to grab. The way I see it, you have two options, increase your shared pool or flush your shared pool. Regards, Melanie Burns -----Original Message----- Sent: Monday, May 20, 2002 5:38 PM Hello List, I got the following error today(Oracle 8.1.7.0 Sun Solaris) ORA-04031: unable to allocate 4200 bytes of shared memory ("shared pool","unknown object","sga heap","state objects") At the moment my shared_pool size is 30M Thanks for your help Hamid Alavi Office 818 737-0526 Cell 818 402-1987 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) 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).
