DataPump Export Slow Performance In 11.2.0.3 For Operations On KU$_INDEX_COL_VIEW Or KU$_INDEX_VIEW
(Doc ID 1506911.1)
Last updated on FEBRUARY 23, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.3 [Release 11.2]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
Slow performance or hang on views:
KU$_INDEX_COL_VIEW
KU$_INDEX_VIEW
KU$_IND_SUBPART_VIEW,
KU$_IND_COMPART_VIEW,
KU$_IND_SUBNAME_VIEW and
KU$_IND_PART_VIEW
is seen in 11.2.0.3 when using any of the following functionality:
- SLOW PERFORMANCE ON EXPDP FUNCTIONAL AND BITMAP INDEXES
- Datapump INDEX EXPORT PERFOMANCE IS SLOW, COMPARED TO EXP
- QUERY AGAINST KU$_INDEX_VIEW SLOW IN 11.2.0.3
- SLOW INDEX EXPORT DUE TO PERFORMANCE ISSUE WITH METADATA KU$_INDEX_COL_VIEW
- DATA PUMP PERFORMANCE FOR ESTIMATE=STATISTICS IN EXPORT IS BAD
- IMPDP FAILS WITH ORA-31693,ORA-06502,ORA-01403
- EXPDP HANGS WHEN USING EXCLUDE CLAUSE WITH DICTIONARY QUERY
- EXPDP SLOW FOR TABLES, INDEXES, CONSTRAINTS AND ALTER_PROCEDURE
- general performance problems that might require the usage or review of KU$ Index views
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |