Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to enhance Oracle Datapump Performance (AIX, Oracle 11.1.0.7.0)

762942Apr 7 2010 — edited Apr 8 2010
For some testing pupose we have to do import a 230GB dump file. This is very time consuming while import.


1. How can I identify the MAX parallesim supported by Oracle 11.1.0.7.0 AIX.? Is it depend upon the no of processor on server.? How can i find that?
2. Will it helpful if the expdp dump from source(production) will taken as compress=y .?
3. Is it advisible to exclude the indexes while impdp import and will create it manually after import. Will it improve the performance and time can be saveed?
(INCLUDE=TABLE_DATA)


Regards,
Sangram Keshari Dash
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 6 2010
Added on Apr 7 2010
#general-database-discussions
5 comments
1,140 views