| ORA-04031 error with EXPDP [message #676629] |
Tue, 25 June 2019 13:26  |
 |
rcct
Messages: 36
Registered: May 2013
Location: Ottawa, ON
|
Member |
|
|
Hi all, I am getting an error ORA-04031 when doing an EXPDP:
ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","SELECT job_id FROM v$datapum...","SQLA","tmp")
It is just a straight-forward export of the full Db, no fancy SQL, etc. Here are some relevant parameters:
[oracle@proddb trace]$ free
total used free shared buff/cache available
Mem: 65712740 2862632 37481512 8279164 25368596 54251229
Swap: 37748728 0 377487280
memory_max_target big integer 20G
memory_target big integer 0
streams_pool_size big integer 10G
shared_pool_reserved_size big integer 10066329
shared_pool_size big integer 192M
large_pool_size big integer 0
use_large_pages string TRUE
When I asked Oracle support about increasing shared_pool_size, he told me "192M is the minimum allocation, it will still be managed by automatic memory management (AMM) above that value. But if you set it to zero, AMM has more flexibility controlling it."
Is that correct? They also asked me to flush the shared pool and ideally restart the instance, but that is just a band-aid, not a solution. I recently converted this Db to use AMM by setting memory_max_target and resetting the SGA parameters, but I did not touch any shared_* or large_* parameters. Any help would be greatly appreciated, thanks.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
