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!

loadjava failure with out of memory condition

408918Nov 12 2003
I am trying to set up a db to be able to develop pl/sql using java stored procedures.

When attempting to use the loadjava utility, i get:

ora-29554 unhandled java out of memory condition

here is what i have:

ora 9.2.0.1.0 running on winXP Pro.
756 MB ram, with 1GB virtual memory set up.

shared pool: 80MB
buffer cache: 48MB
large pool: 48MB
java pool: 104MB

total sga: 280MB
sga max size: 1GB

java_max_sessionspace_size: 2048
java_soft_sessionspace_limit: 250

System tablespace: 700MB, used 487MB
undotbs1: 1.1GB, used: 19MB
undo mode: auto

from metalink, i am looking at notes 204935.1 and 120994.1, which has details on setting this up. i seem to have everything set per those docs, but i still get the error message when i try to use the loadjava tool, and/or when i try to create a java class directly in the db by using 'create or replace and compile java source named ...'

i know that java is enabled. when i do:

select * from v$option;

the results show java = true.

when i do:

select count(1) from dba_objects where object_type like '%JAVA%';

i get 10452 objects found.

so i'm not sure what to try next or why i am getting the out of memory error. can anyone help?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 10 2003
Added on Nov 12 2003
0 comments
195 views