DataPump Import (IMPDP) Into ASM Based Database Slower Than Into Veritas VXFS Datafiles
Last updated on JANUARY 19, 2017
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199 [Release 11.2 to 12.1]
Information in this document applies to any platform.
We see a difference in elapsed times between same DataPump dumpfile being imported into an ASM based database (means all datafiles are on ASM) and the other setup which is using Veritas VXFS (non-ODM) datafiles:
|IMPDP Test||IMPDP Start Time||IMPDP End Time||Total|
AWR reports show the following information:
ASM environment is more powerful compared with the Veritas configuration:
- ASM environment is on Red Hat 5.8 release, it has 24 Cores CPUs(Xeon(R)CPUX5660@2.80GHz), it has 48288 MB in RAM, the associated SAN is an EMC array 4132
- Veritas environment is on RedHat 5.4, it has 16 Cores CPUs (R905:Quad-CoreAMDOpteron(tm)Processor838), it has 64520 MB in RAM, the SAN associated model is older , EMC array 3896.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms