DataPump Export Slow With High Parse And Execute Time On SYS.KU$_REF_PAR_LEVEL_VIEW (Doc ID 1531331.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms

Export DataPump hangs at the estimate phase:

Export: Release 11.2.0.2.0 - Production on Sun Jan 20 16:43:33 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "RMS13DEV"."SYS_EXPORT_SCHEMA_01": parfile=parfile_exp_RMS13DEV_RP05 userid=rms13dev/********@rp05
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

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