DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: fasten the import and export process

  1. #1
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    Let's have a nice conclusion :-)

    How to fasten the import and export process (provided that CPU and Memory is enough ):

    following are my idea ,

    For Export :
    A. Change archivelog mode to nonarchivelog mode
    B. Set Buffer parameter to big enough (Buffer=10M)

    For Import :
    A. Change archivelog mode to nonarchivelog mode
    B. Set Buffer parameter to big enough (Buffer=10M)
    C. Set Commit parameter to 'Y'

    How do you think ?

    1. www.dbasupport.com
    2. www.dbforums.com
    3. www.itpub.net
    4. www.csdn.net
    5. www.umlchina.com
    6. www.tek-tips.com
    7. www.cnforyou.com
    8. fm365.federal.com.cn
    9. www.programmersheaven.com
    10.http://msdn.microsoft.com/library/default.asp
    ligang1000@hotmail.com

  2. #2
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    Well, I really wouldn't be changing my DB to NOARCHIVELOG, casse your databae STILL logs in NOARCHIVELOG... it just doesn't ARCHIVE the logs. So there is no gain there.

    Fore pure speed

    Export

    DIRECT=Y
    COMPRESS=N

    IMPORT

    BUFFER = > 20MB
    COMMIT=Y of course
    INDEXES=N
    OCP 8i, 9i DBA
    Brisbane Australia

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    commit in fact can slow down your import process but if you dont have big RBS....

  4. #4
    Join Date
    Jul 2002
    Location
    Lincolnshire, IL
    Posts
    203
    Export:
    DIRECT=Y
    COMPRESS=N
    Import:
    INDEXES=N
    COMMIT=N(Y generally not advisable)
    "Greatest Rewards come only with Greatest Commitments!"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width