日期:2014-05-17  浏览次数:20821 次

oracle exp时ora-04031问题
各位大虾:
oracle   10g   在   REDHAT   AS3   U4   exp时出现ora-04031错误,导出终止,请问如何解决?

谢谢

------解决方案--------------------
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 ".
------解决方案--------------------
内存问题