Datapump Export Takes a Long Time and Shows High Controlfile I/O
Last updated on OCTOBER 27, 2009
Applies to:Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 18.104.22.168
This problem can occur on any platform.
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'.
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