ORA-04031: unable to allocate 56 bytes of shared memory ("streams pool","unknown object","streams po
Hi all
I have one issue with setting of streams pool because sometime datapump failed with ORA-04031 and I can't find out why datapump uses stream pool.
Do You have any idea how to find out why datapump use streams pool , because I',m not able to repeat this issue again to monitor behavior of streams pool during expdp.
And can You recommend me how to monitor consumption of stream pool during expdp ?
I tried to use
select * from v$streams_pool_advice
select * from v$sga_dynamic_components where component like 'streams pool%';
select * FROM V$STREAMS_POOL_ADVICE;