loadjava failure with out of memory condition
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?