Wednesday, January 28, 2015

Slow Export job in 11gR2 / Oracle Streams AQ: enqueue blocked on low memory


Today one of our frequent export job started failing due to following error in our stage database (Oracle Database version 11.2.0.4 on OEL 6)

Oracle Streams AQ: enqueue blocked on low memory

On checking further i found that  the export job was slow due to low stream_pool_size in the database. The wait event of the job was showing as below: 

Oracle Streams AQ: enqueue blocked on low memory"

 

 I also checked the oracle support metalinkfor reference which you can refer as well.

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

 The issue got resolved by increasing stream_pool_size to 256MB. Export started running as expected.



2 comments: