Re: ORA 604 followed by ORA 4031 error

Increase your "java_pool_size".

Igor Neyman, OCP DBA
ineyman_at_perceptron.com   

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, October 09, 2002 4:08 AM

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Igor Neyman
  INET: ineyman_at_perceptron.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).