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.
Thanks.
ReplyDeletedba4oracleapps.blogspot.com
Glad to know that this helped.
Delete