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: [EMAIL PROTECTED]
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: [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).
______________________________________________________________________________
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: [EMAIL PROTECTED]
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: [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).
