Oracle-L: ORA 604 followed by ORA 4031 error

From: oraora oraora <oraoraora_at_rediffmail.com>
Date: Wed, 09 Oct 2002 00:08:27 -0800
Message-ID: <F001.004E3FBA.20021009000827@fatcity.com>

hello guys,

i found this error in my trace file.
environment is 8.1.6/win2k.
system RAM = 4G
shared_pool_size = 238M
shared_pool_reserved_size = 119M
java_pool_size = 64K
large_pool_size = 95M

ERROR IN EXECUTING TIGGERS IN DB. ON STARTUP ksedmp INTERNAL FATAL ERROR
ORA 604 : ERROR OCCURED AT RECURSIVE SQL LEVEL STRING ORA 4031 : UNABLE TO ALLOCATE 4032 BYTES OF SHRED MEMORY (shared pool,java/io/inputstreamsys,joxled:in ehe,ioc_allocate_pool) ORA 6512 : sys.dbms_java , ? 0
ORA 6512 : ? 2

then i changed,
java_pool_size = 20M
large_pool_size = 150M

but even then i get the same error in my trace files. what is the reason for this error ?
will increasing shared_pool_size get rid of it ? is it a fatal error ?

kindly let me know your views.
thanx in advance.

--

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

Author: oraora oraora
INET: oraoraora_at_rediffmail.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). Received on Wed Oct 09 2002 - 03:08:27 CDT