Export Database Takes Time in 12cR1 (12.1.0.2) - Oracle E-Business Suite Objects

Export Database (expdp) of Oracle E-Business Suite R12.2 takes time while doing Full Table Scan

Solution:

Collect Dictionary Statistics: 

SQL> connect / as sysdba
SQL> exec dbms_stats.gather_dictionary_stats;
SQL> exec dbms_stats.lock_table_stats (null,'X$KCCLH');
SQL> exec dbms_stats.gather_fixed_objects_stats;


Configure stream_pool_size, e.g. set streams_pool_size to a minimum of 256M.
Note that depending on the size of the database and the number of partitions, this value could be greater

For 12.1.0.2 apply the following patch: 

Patch 21554480
This is an merge generic patch available on top of the 12.1.0.2 for 18793246, 20236523, 20548904, 21128593

To obtain a patch from MOS:
1) Click on Patches.
2) Click on Simple Search
3) Enter patch number: 21554480
4) Select yourO/S
5) Click Go.

Try exporting the same database after executing the above steps. The performance will be better than earlier.

Bugs Resolved by This Patch

18793246 BASE OBJECT LOOKUP DURING DATAPUMP EXPORT CAUSES FULL TABLE SCAN PER OBJECT
20236523 DATAPUMP EXPORT SLOW USING CONTENT=METADATA_ONLY
20548904 EXPDP HANG IN METADA_ONLY ON A PARTITION TABLE WITH AROUND 40000 SUBPARTITIONS
21128593 UPDATING THE MASTER TABLE AT THE END OF DP JOB IS SLOW STARTING WITH 12.1.0.2