Export Error - Shared pool urgentttttttttt

[sjadhavdba]

While taking my export for one schema giving an error

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

After that i've nearly increased the shared_pool_size and share_pool_reserved_size parameter thrice.
initially 220232704
and now 524288000 and
reserved size is 10% of that

i've even tried to keep the object dbms_java and dbms_java_test in shared pool using dbms_shared_pool.keep package.

still the problem.

can any one suggest me any thing.

[rohitsn]

Hi,
Increase java_pool_Size to 20MB and keep the shared_pool_size and shared_pool_reserved_size the same as you have kept and now try to export.
In case of any help please be free to ask me at rohitsn@altavista.com

Regards.
Rohit Nirkhe,Oracle DBA,OCP 8i
rohitsn@altavista.com

[sjadhavdba]

Thanx Rohit

it worked. i've kept java_pool_size to 2M. thanx