-
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!!!!
-
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"
-
how do you know its hanging and not just getting the data?
-
because exp is done in 3.5 hr and expdp is still running after 12 hr.
-
yeah but have you actually worked out what it is doing, it might not be hanging
-
wait event is "wait for unread message on broadcast channel"
-
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"
-
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.
-
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"
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|