Datapump Import is Very Slow in 12c With Large Number of Object Grants
(Doc ID 2069397.1)
Last updated on SEPTEMBER 18, 2020
Applies to:Oracle Database Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168 [Release 12.1]
Information in this document applies to any platform.
For certain expdp dump file, Datapump import (impdp) into 11g took 3 hours compared to 7 hours in 12c.
There are many Grants to be imported and much time is used for OBJECT_GRANT and INDEX objects, e.g.
"Completed 6962 INDEX objects in 16470 seconds"
In the AWR report, next code is being run repeatedly many times:
Upgraded to 12c.
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