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

Yazının devamını oku »