Import Taking long time
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: Import Taking long time

  1. #1
    Join Date
    Oct 2001
    Location
    Hyderabad
    Posts
    44
    Hi DB Guru's,
    I got a problen in import. The dump file size is 1.2GB and number of records in each table is more than 500000. its taking 8 hours to complete the import.Can any one suggest a shortcut to reduce the time of import.

    Thank you,
    esreddy

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Shouldn't take more than a couple of hours with a 1G dump. Show us the import statement you used.

    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  3. #3
    Join Date
    Oct 2001
    Location
    Hyderabad
    Posts
    44
    Originally posted by julian
    Shouldn't take more than a couple of hours with a 1G dump. Show us the import statement you used.

    this is my import statement.

    imp userid=system/manager@servicename fromuser=abc touser=xyz file=/u02/abc.dmp log=import.log buffer=100000 commit=Y

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    It looks OK to me, how many RBSs do you have and how big are they? Is there any activity in the DB during the import? If you try with a bit smaller buffer?

    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  5. #5
    Join Date
    Oct 2001
    Location
    Hyderabad
    Posts
    44
    Originally posted by julian

    It looks OK to me, how many RBSs do you have and how big are they? Is there any activity in the DB during the import? If you try with a bit smaller buffer?

    i have four RBSs idont know the size, sorry i am new to DBA.
    no other activity on DB while importing.

  6. #6
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    What's the output of select * from v$rollstat;?
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  7. #7
    Join Date
    Oct 2001
    Location
    Hyderabad
    Posts
    44
    this is my roleback segment size


    USN RSSIZE
    ---------- ----------
    0 612352
    2 12761088
    3 3325952
    4 6715392
    5 3858432

  8. #8
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Not very well size RBSs but this should not be the cause. Eight hours you said for a one G dump? Odd. Try with 3 times smaller buffer. Are all tables 'empty' before the import? Is the system well tuned?
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  9. #9
    Join Date
    Oct 2001
    Location
    Hyderabad
    Posts
    44
    I tried with buffer=20000 ; even then it is taking 4 hrs.
    in general how much time will take for 2GB Dump file, any other better import option to reduce the time?

    thanks

  10. #10
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    BTW, what's the box you're doing the import?

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