Database Memory & 4030/4031 (MOSC)

MOSC Banner

ORA-04031: unable to allocate 56 bytes of shared memory ("streams pool","unknown object","streams po

edited Mar 7, 2019 4:06AM in Database Memory & 4030/4031 (MOSC) 5 commentsAnswered ✓

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center