Import very slow
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Import very slow

  1. #1
    Join Date
    Nov 2002
    Location
    Canada
    Posts
    10

    Import very slow

    Hi all,

    Our import takes more (2x) time since after upgrade from 7.3.4 to 8.1.7. Would any one know why. Any suggestion would be appreciated.

    Thanks in advance.
    Katie.
    Slow and Steady....!

  2. #2
    Join Date
    Dec 2002
    Location
    USA
    Posts
    53
    try set
    buffer=... in import parameters

  3. #3
    Join Date
    Jan 2001
    Posts
    3,131
    Did you switch optimizer modes?
    When was the last time the tables were analyzed?
    Indexes fragmented?
    Is Pluto aligned with Jupiter?

    MH
    I remember when this place was cool.

  4. #4
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Hi

    To make import faster you can do

    1. imp with indexs=n, this will not create indexes and make the import faster. Then u can do imp whith indexfile=index.sql, this will generate your index creation script which you can run later.

    2. Create few monster rollback segments in different tablespace for the import and keep other rollback segments offline.

    3. give buffer=large value. (be carefule or it will eat up your memory)

    HTH
    Regards
    Amar
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  5. #5
    Join Date
    Nov 2002
    Location
    Canada
    Posts
    10
    Thanks all for your imput. I did increased the buffer size. I also changed the parameter file as in oracle note id:#93763.1 unfortunately none of above helped with my problem. I am guessing its resource and contention issue since our upgrade.

    Amar, setting index=n is time consumming. I did create large rbs before the import and kept others offline.

    MH, can you expanciate more on the followin:
    Did you switch optimizer modes?
    When was the last time the tables were analyzed?
    Indexes fragmented?
    Is Pluto aligned with Jupiter?

    Thanks all,
    katie.
    Slow and Steady....!

  6. #6
    Join Date
    Jul 2000
    Posts
    119
    what's your new db_block_size ?
    OCP 8.0, 8i, 9i

  7. #7
    Join Date
    Jan 2001
    Posts
    3,131
    [i]
    MH, can you expanciate more on the followin:

    Did you switch optimizer modes?
    When was the last time the tables were analyzed?
    Indexes fragmented?


    Thanks all,
    katie. [/B]
    Well, I was just informed that optimizer mode has nothing to do with this problem so please disregrd.

    If you are truncating the tables prior to the import then the analyze and index issues are no longer valid.
    Stick to the metalink #93763. Aside from that I think there is little you can do.

    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