Import Problem(Urgent help needed)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Import Problem(Urgent help needed)

  1. #1
    Join Date
    Oct 2001
    Location
    Hyderabad
    Posts
    44
    HI ,
    I need to do an Import, the dump is in 5 seperate files each of 1 GB size.
    Can any one suggest me how to do it in very less time?

    Thanks
    esreddy

  2. #2
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Hello;

    Set the BUFFER-Val very high ( Increasing the INSERT-rowset-size );
    and it would be best if the dumps has been created with DIRECT=Y

    Is your DB in ARchive-log-Mode?
    Probably switching the DB to NONARCHIVELOG-MODE
    Then importing
    Then ARCHIVELOG-MODE
    Then Full-backup of DB

    would be faster too

    Your IO between Online-Redo and Datafiles should be seperated
    Your Redo-files should be large due to less checkpointes >= 64M

    The Dumpfiles may not be in the Storage of the Database at all; Best : own disk and controller;



    COMMIT=N could overflow the ROLLBACK-Segments

    Orca




    [Edited by Orca777 on 06-12-2002 at 02:31 AM]

  3. #3
    Join Date
    Oct 2001
    Location
    Hyderabad
    Posts
    44
    i have given BUFFER=100000 COMMIT=N
    still it is taking so much time

  4. #4
    Join Date
    Jan 2001
    Posts
    3,131
    Originally posted by esreddy
    i have given BUFFER=100000 COMMIT=N
    still it is taking so much time
    I would set the buffer at around 4,000,000 and commit =Y

    This way after 4 million bytes (3MB's roughly) you will commit your insert. With commit=N Oracle will only commit after the entire table is imported, this can be a problem with large tables.

    MH
    I remember when this place was cool.

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