Lately we are seeing lot of slowness in our schema imports while using datapump imports. Eveything looks fine until Import process reaches its last statges (processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS) it waits long time (5-7 minutes) before moving to next step and finishing the import. see attached file.
The import process is getting slower and slower as database is aging. DB is about 1 year old now. We do lot of expdp and impdp on daily basis on this db and impdp is done into the new schema (new user).
Please suggest any improvement steps and reasoning.
Thanks
Reply With Quote