DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: import

  1. #1
    Join Date
    Nov 2000
    Posts
    169
    Approximately how long does it take to import 10million rows

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    200MHz PC with 128MB RAM & 5400RPM disk, database poorly designed, import not tuned: 20 days.
    4x450 Sun E420 with FCAL Disks, datafiles striped over 10 0+1 filesystems, database properly defined, import tuned: 20 seconds.
    Jeff Hunter

  3. #3
    Join Date
    Mar 2001
    Posts
    63
    LOL, marist89 pretty much said it all.

    Or to state it another way... what are the specifics of your hardware and software (especially hardware)?

    Are you importing indexes? Was there an index, trigger, or constraint pre-existing on the table that you are importing into?

    Is the database going to be used by other people while you do the load? If so, are there many users? Are they running complex queries or simple insert/update/delete statements?

    All of these things will affect the load time.



  4. #4
    Join Date
    Nov 2000
    Posts
    169
    What do you mean by if import is tuned?

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Are you using DIRECT=Y?
    Are you using an optimal BUFFER= value
    Are you importing data only or data + indexes?
    Are tablespaces appropriately distributed?
    etc...
    Jeff Hunter

  6. #6
    Join Date
    Nov 2000
    Posts
    169
    Yes to all what mariset89 just said about the import tuning.
    Okay to answer your earlier question, I am running 8.1.6
    on AIX 4.3.3 32 bit.
    So what do you think about the latest info?

  7. #7
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by learn
    Yes to all what mariset89 just said about the import tuning.
    Never beleve anything on the first word ! From what Jeff suggested about import I wouldn't recommend you to use DIRECT=Y....
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  8. #8
    Join Date
    Nov 2000
    Posts
    169
    Hi Modic,
    Can you tell me why you would not recommend setting DIRECT=Y

  9. #9
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Well, if you'll try to use DIRECT=Y with import your import will be finished extremely quick - not because the data will be imported so quickly, but because importing will not begin at all . All you'll get will be the following err message:

    IMP-00022: failed to process parameters

    DIRECT is not a valid parameter for import. It is valid for exp and SQL*Loader, but not for imp.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  10. #10
    Join Date
    Nov 2000
    Posts
    169
    Thanks for that. What about this information that I provided. How much effect is it going to have on the import?

    "Yes to all what mariset89 just said about the import tuning.
    Okay to answer your earlier question, I am running 8.1.6
    on AIX 4.3.3 32 bit.


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