Oracle-L: RE: ANY IDEA?

From: Reardon, Bruce (CALBBAY) <Bruce.Reardon_at_comalco.riotinto.com.au>
Date: Mon, 20 May 2002 17:58:22 -0800
Message-ID: <F001.004657A2.20020520175822@fatcity.com>

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: Bruce.Reardon_at_comalco.riotinto.com.au

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: 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 Mon May 20 2002 - 20:58:22 CDT