DataPump Import (IMPDP) is Very Slow at Object/System/Role Grants, Default Roles

(Doc ID 1267951.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.2 [Release 10.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 03-Oct-2014***

Symptoms

You started a database import using DataPump (impdp) with parameter METRICS=Y and observed that a huge amount of time is needed to import the object grants:

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Completed 475505 OBJECT_GRANT objects in 91490 seconds
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/WITH_GRANT_OPTION/OBJECT_GRANT
Completed 512310 OBJECT_GRANT objects in 124801 seconds
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/CROSS_SCHEMA/OBJECT_GRANT
Completed 1796 OBJECT_GRANT objects in 623 seconds

or system/role grants, default roles:

Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
Completed 372 SYSTEM_GRANT objects in 706 seconds
Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT
Completed 6455 ROLE_GRANT objects in 12267 seconds
Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE
Completed 583 DEFAULT_ROLE objects in 1112 seconds


You extracted the SQL file with INCLUDE=OBJECT_GRANT (or SYSTEM_GRANT, ROLE_GRANT, DEFAULT_ROLE) SQLFILE=<filename> and ran this with SQL*Plus. This completed fast.

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