求救：exp全库导出时时报错

bengsui

导出到开始导出同义词时就报错
报错信息如下：
. . exporting table                  MYTEST       184 rows exported
. exporting synonyms
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

请问是什么原因？

bengsui

我的shared_pool有500M，应该够大了吧，而且提示是只要分配4032bytes啊

jlandzpa

java_pool_size=30m

bengsui

我做exp备份要用到很多的shared pool吗？

xie3000

按jlandzpa斑竹说的试一下：

ORA-04031: unable to allocate 4032 bytes of shared memory ("shared
pool","oracle/aurora/rdbms/DbmsJavaSYS","joxlod: in ehe","ioc_allocate_pal"

bengsui

我就是担心简单的增加大小可能不能根本解决问题。我想知道到底是什么原因引起这样的。这么大的共享池居然不能分配空间了。

alphah

04031, 00000, "unable to allocate %s bytes of shared memory (\"%s\",\"%s\",\"%s\",\"%s\"
)"
// *Cause:  More shared memory is needed than was allocated in the shared
//          pool.
// *Action: If the shared pool is out of memory, either use the
//          dbms_shared_pool package to pin large packages,
//          reduce your use of shared memory, or increase the amount of
//          available shared memory by increasing the value of the
//          INIT.ORA parameters "shared_pool_reserved_size" and
//          "shared_pool_size".
//          If the large pool is out of memory, increase the INIT.ORA
//          parameter "large_pool_size".

bengsui

对了，我的错误是说shared_pool不够，而不是java_pool啊，为什么调整java_pool呢？

coolyl

The default value for the java_pool_size in 8.1.5 should be  10Meg and in 8.1.6 the default should be 20Meg.  If your settings are too low, this will cause the export to run out of memory.  Therefore, you will need to  check and increase your settings for these two parameters in your init.ora  and retry the export.

And your database version?
how to write your exp statement?

bengsui

数据库version是8.1.7.0.0，exp语句是exp test/test file='/oradata/test.dmp'   log='/oradata/test.log'
看我的错误中oracle/aurora/rdbms/DbmsJavaSYS，我想也许是的吧，我的java_pool只有61440，估计是太小了