Use of Datapump Import Leads to Streams Memory Issue
About forty-five minutes later, and again fifteen minutes after that, the background process MMON experienced waits in the category "Streams AQ: enqueue blocked on low memory". The waits lasted about seven minutes each time. About twenty-four hours later MMON experienced an identical period of wait.
We do not use streams in this database, but I have been told that datapump does use streams.