Oracle性能优化之'Streams AQ: enqueue blocked on low memory'等待事件

EXPDP And IMPDP Slow Performance In 11gR2 and 12cR1 And Waits On Streams AQ: Enqueue Blocked On Low Memory (文档 ID 1596645.1)
复制

SQL> show parameter streams
NAME TYPE VALUE
------------------------------------ --
streams_pool_size big integer 0
复制

select x.ksppinm name,y.ksppstvl value,x.ksppdesc describ
from sys.x$ksppi x,sys.x$ksppcv y3 where x.inst_id=userenv('Instance')
and y.inst_id=userenv('Instance')
and x.indx=y.indx
and x.ksppinm like '%streams_pool%'
/
复制

ALTER SYSTEM SET STREAMS_POOL_SIZE=150M SCOPE=BOTH;
复制