Datapump Export becomes very slow when exporting Domain Index(es)
Last updated on MAY 22, 2017
Applies to:Oracle Database - Standard Edition - Version 126.96.36.199 to 188.8.131.52 [Release 11.2 to 12.1]
Information in this document applies to any platform.
Data Pump is very slow when exporting Domain Indexes.
With every Domain Index rebuild this is getting slower.
Data Pump Logfile
. . exported "U1"."TEST1" 57.34 MB 1920 rows
TKPROF based on SQL tracing using "event 10046 level 12" confirms that that most of the elapsed time is spent on SYS.KU$_2NDTAB_INFO_VIEW
The AWR Report confirms that there's a huge number of "executions" of the identical sql_id as confirmed by the TKPROF report.
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