You are currently browsing the tag archive for the ‘Data Pump Export workers are waiting on ‘wait for unread message on broadcast channel’’ tag.

I faced with that issue on 11.2.0.4 version on Linux 6. There were no messages or warnings in the alert log file.

Export status showed as executing and there weren’t any errors.

I used below sql to identify wait:

select v.status, v.sid,v.serial#,io.block_changes,event
from v$sess_io io, v$session v
where io.sid = v.sid
and v.saddr in (
    select saddr
    from dba_datapump_sessions
) order by sid;

Read the rest of this entry »

Advertisements
Advertisements
Advertisements