Oracle Database 11g -- Expdp stuck on Streams AQ: Enqueue Blocked On Low Memory wait event

Problem

While exporting data from an Oracle Database 11g (also possible on an Oracle database 12.1 version), you notice degraded performance of the Data Pump worker sessions, which keep waiting for the Streams AQ: Enqueue Blocked On Low Memory wait event:

Solution

Add more memory to SGA and set the streams_pool_size parameter to a higher value, like 150mb minimum, and 500mb is recommend, for at least for the duration of the export job.

Reference:

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