Skip to Main Content

Java and JavaScript in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DBMS_JAVA.START_DEBUGGING has OutOfMemoryError

23060Feb 22 2002
Whenever I try to start the debug agent in my JServer, I get and OutOfMemory error detailed below. It was working okay only two days ago, but was broken when I returned from lunch. It is possible that a debug session timed out during lunch.

Any help is greatly appreciated. The problem extends to other Java Stored Procedure code that starts up worker threads in the Connection class while doing LDAP calls using JNDI.

Here's the error. Note the sga memory stats below also show that there is more than enough free Java pool memory.


=================================
The following error has occurred:
=================================
ORA-29532: Java call terminated by uncaught Java exception: java.lang.OutOfMemoryError
ORA-06512: at "SYS.DBMS_JAVA", line 0
ORA-06512: at line 2

=======================================
And here's a view of my sga memory with
select * from v$sgastat;
=======================================
fixed_sga 73888
db_block_buffers 16777216
log_buffer 163840
shared pool free memory 3599632
shared pool miscellaneous 2062240
shared pool errors 156508
shared pool KGK heap 4376
shared pool PL/SQL DIANA 2239336
shared pool trigger defini 3176
shared pool PL/SQL MPCODE 12338908
shared pool type object de 10468
shared pool table definiti 3520
shared pool sessions 603680
shared pool joxlod: in ehe 155208
shared pool State objects 308024
shared pool table columns 21604
shared pool KGFF heap 14844
shared pool transactions 274736
shared pool pl/sql source 34976
shared pool VIRTUAL CIRCUITS 453512
shared pool fixed allocation callback 640
shared pool trigger source 600
shared pool KQLS heap 1590568
shared pool dictionary cache 1183396
shared pool PLS non-lib hp 2096
shared pool trigger inform 988
shared pool PL/SQL PPCODE 14444
shared pool library cache 11103604
shared pool db_block_buffers 278528
shared pool sql area 27219680
shared pool PL/SQL SOURCE 7048
shared pool processes 199000
shared pool joxlod: in phe 337420
shared pool joxs heap init 4248
shared pool event statistics per sess 972160
large pool free memory 61343280
large pool session heap 96720
java pool free memory 202989568
java pool memory in use 6725632

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 22 2002
Added on Feb 22 2002
0 comments
221 views