Datapump export - estimate phase very slow (both BLOCKS and STATISTICS)
We are seeing an issue in a 4-node RAC (v11.1.0.7) where the estimation portion of an export is much longer than the actual export itself. For example, I just did a couple of exports of a schema (the size of the resulting dump file is 2.2G).
With no "ESTIMATE=" clause on the command line, (therefore BLOCKS), the estimation portion of the job took 48 minutes. The actual export of the data took just over 10 minutes. With ESTIMATE=STATISTICS, the estimation portion of the job took 38 minutes. The actual export of the data took just under 10 minutes.
I've searched through this forum and Oracle Support, but have not found anything that addresses this issue. Does anyone know if there anything else I can do to get Datapump to speed up (or eliminate) it's estimation process before I log this with support?
With no "ESTIMATE=" clause on the command line, (therefore BLOCKS), the estimation portion of the job took 48 minutes. The actual export of the data took just over 10 minutes. With ESTIMATE=STATISTICS, the estimation portion of the job took 38 minutes. The actual export of the data took just under 10 minutes.
I've searched through this forum and Oracle Support, but have not found anything that addresses this issue. Does anyone know if there anything else I can do to get Datapump to speed up (or eliminate) it's estimation process before I log this with support?
0