expdp hangs for large tables

[kpate]

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!!!!

[abhaysk]

Logs? check the wait events.

[davey23uk]

how do you know its hanging and not just getting the data?

[kpate]

because exp is done in 3.5 hr and expdp is still running after 12 hr.

[davey23uk]

yeah but have you actually worked out what it is doing, it might not be hanging

[kpate]

wait event is "wait for unread message on broadcast channel"

[kpate]

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"

[Kamkan]

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.

[abhaysk]

that is of idle wait class..

[abhaysk]

please check if session is in inactive status?