Datapump Export Takes a Long Time and Shows High Controlfile I/O (Doc ID 959474.1)

Last updated on OCTOBER 27, 2009

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.1.0.7
This problem can occur on any platform.

Symptoms

Full or schema level datapump exports appear to hang on estimating the dump size.  Running tkprof against a 10046 trace of the datapump processes shows that the bulk of the time is being spent on 'control file sequential read'.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms