ORA-04031

[raztaboule]

hi !

I'm working with oracle 8.1.7.4 under AIX 433.

the first message was :
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 4112 bytes of shared memory ("shared pool","unknown object","sga heap","multiblock rea")
Mon Mar 22 10:51:06 2004

i noticed it while users were experiencing problems with update.
so I double shared_pool_size and java_pool_size = 1000000.

I proceed with shutdown/restart and have the following message :
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 4032 bytes of shared memory ("shared pool","sun/misc/LauncherSYS","joxlod: in ehe","ioc_allocate_pal")
ORA-06512: at "SYS.DBMS_JAVA", line 0
ORA-06512: at line 2

But users work without problems.

And tonight while exporting the exports ends with :

EXP-00008: ORACLE error 4031 encountered
ORA-04031: unable to allocate 4032 bytes of shared memory ("shared pool","java/security/SecuritySYS","joxlod: in ehe","ioc_allocate_pal")
EXP-00000: Export terminated unsuccessfully

I've prepared my init.ora with JAVA_POOL_SIZE=4194304 and planned to reboot tonight.
But is it the solution ?

 

[sem]

Less than 1M is too small for java. Try 16M at least.

Regards, Dima

http://seminihin.narod.ru

 

[raztaboule]

thanks for the advice.
do you know, anyway to change this size without a restart ?