DataPump Import (IMPDP) Into ASM Based Database Slower Than Into Veritas VXFS Datafiles
Last updated on MARCH 12, 2018
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 to 188.8.131.52 [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
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms