Overview

During routine operation, we noticed that the export took 44 minutes instead of 7 minutes. After I tried to start the expdp manually, I found out that indeed it is slow and it took several minutes to even connect to the DB and start processing data. After further investigation of the sessions, I found the following waiting event:

Waiting event

After internet investigation I have found the following solution and workaround.

Solution

The solution is to apply the following patches:

Patch 27634991 may be applied to prevent this problem from occurring.

Bug:17365043 Session hangs on “Streams AQ: enqueue blocked on low memory”

Bug:24560906 High CPU usage for Background q0 processes with fix for

bug 21286665

I didn't do any of these :D

Workaround

The workaround applies if you have the following flag on:

Flag check

If that is on, force oracle to finish the job by using the following command:

Force

That solved the slow expdp for me.