expdp hangs for large tables
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: expdp hangs for large tables

  1. #1
    Join Date
    Dec 2002
    Posts
    89

    expdp hangs for large tables

    I was successfully able to export schema using exp command, for some reason expdp hangs, I have 3000 objects in that schema, expdp hangs after exporting 2960 objects and it hangs at table which has 250 million records.
    The oracle version is 10.2.0.3.

    I have tried several times, using different parameters of expdp. Also it doesn't show starter jobs more than one, for parallel=4.

    Please help!!!!

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Logs? check the wait events.
    Last edited by abhaysk; 10-05-2007 at 09:13 AM.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    how do you know its hanging and not just getting the data?

  4. #4
    Join Date
    Dec 2002
    Posts
    89
    because exp is done in 3.5 hr and expdp is still running after 12 hr.

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    yeah but have you actually worked out what it is doing, it might not be hanging

  6. #6
    Join Date
    Dec 2002
    Posts
    89
    wait event is "wait for unread message on broadcast channel"

  7. #7
    Join Date
    Dec 2002
    Posts
    89
    Please help, the status doesn't move from estimate in progess using Blocks method...

    also the its waiting on "wait for unread message on broadcast channel"

  8. #8
    Join Date
    Jun 2006
    Location
    Chennai, INDIA
    Posts
    72

    Red face

    Hi,
    Are the size of the dmp file in the same size during the above said time? U shall try generating stats on the table using DBMS_STATS and retry exporting only that table to check the performance.

  9. #9
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    that is of idle wait class..
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  10. #10
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    please check if session is in inactive status?
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

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