expdp full=y 导出整个数据库时非常慢

测试环境中用指定schemas的方式导出数据库很快能完成。
expdp SYSTEM/PASSWORD SCHEMAS ='SCOTT' ，'BJDB01','TJDB02','CDDB03' ,'SHDB04' DIRECTORY=DPUMPDIR DUMPFILE=EXPDP_%U.DMP JOB_NAME=MYJOB2 LOGFILE=SCOTTEXP.LOG FILESIZE=2G parallel=3

想偷个懒，用full=y 来个全库导出。
expdp SYSTEM/PASSWORD full=y DIRECTORY=DPUMPDIR DUMPFILE=FULLEXP_%U.DMP JOB_NAME=MYJOB2 LOGFILE=FULLEXP.LOG FILESIZE=2G parallel=3

导出进程基本停止不动：
Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY
Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/CONTEXT
Processing object type DATABASE_EXPORT/SCHEMA/LIBRARY/LIBRARY
Processing object type DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/SYNONYM
Processing object type DATABASE_EXPORT/SCHEMA/SYNONYM

其实全库导出的时候估算出来的库大小和用schemas方式估算出来的表大小没差几个G.
但schemas方式导出的时候很快能执行完，但full=y的方式却用很长时间都没有反应。
此时数据库并没有压力。

查了MOS,原来是bug。

[MOS:]Expdp Full Database 5 Times Slower After Upgrade To 11G [ID 972904.1]

Cause：
The cause of this problem has been identified in Bug 8627478 closed as duplicate of unpublished bug 8904037.
It is caused by an internal issue in the code related to the component Workspace Manager. Expdp takes more time to export when many users exists.

Solution：
Unpublished bug 8904037 is fixed in release 12.0.
Check if an one-off Patch 8904037 is available for your current release and platform