Oracle-L: RE: Export generates ORA-04031 error

From: Nelson, Allan <anelson_at_midf.com>
Date: Mon, 24 Feb 2003 09:13:52 -0800
Message-ID: <F001.00556DBE.20030224091352@fatcity.com>

9M is not a large shared pool. What db version? What app? We really do need some details to provide intelligent responces. You might consider bumping it to 20M and see what happens. Without more information it is impossible to be more specific.

Allan

-----Original Message-----
Sent: Monday, February 24, 2003 9:59 AM
To: Multiple recipients of list ORACLE-L

I received following errors during export. I had increased shared_pool_size in configuration file several times, it just fixed the problem for couple weeks then now I received the same problem. Is there a better way to fix this issue permanently? And what is the maximum limit size can I increase shared_pool_size? Currenlty it is increased from 5000000 to 9000000.

EXP-00008: ORACLE error 4031 encountered ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","BEGIN :1 := "SYS"."DBMS_REFR...","PL/SQL MPCODE","BAMIMA: Bam Buffer")
EXP-00083: The previous problem occurred when calling SYS.DBMS_REFRESH_EXP_SITES.schema_info_expacle

Thanks,
David
--

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

Author: Nguyen, David M
INET: david.m.nguyen_at_xo.com

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).

This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216]

--

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

Author: Nelson, Allan
INET: anelson_at_midf.com

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