Expdp For Metadata Is Slow In 11.2.0.3 With Partitioned Objects
(Doc ID 1466040.1)
Last updated on MARCH 30, 2023
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 Express Cloud 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
Information in this document applies to any platform.
Symptoms
11.2 Database is used with partitioned objects as shown by:
From the AWR report, we see high logical reads and Full Table Scan for:
Owner Tablespace Name Object Name Subobject Name Obj. Type Logical Reads %Total ----- --------------- -------------------- -------------- --------- ------------- ------ SYS SYSTEM TABSUBPART$ TABLE 49,245,408 46.94 SYS SYSTEM TABCOMPART$ TABLE 43,975,200 41.92 SYS SYSTEM I_INDCOMPART_BOPART$ INDEX 2,899,584 2.76
Changes
Upgrade to 11.2.0.3
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 |
| Changes |
| Cause |
| Solution |
| References |