Data Pump Export process waiting with the message “wait for unread message on broadcast channel”

dbtut December 9, 2018 ORACLE

During the DataPump export process, if the relevant session is waiting for the following message, you can resolve this issue by doing the following operations.

“wait for unread message on broadcast channel”

The following commands update related statistics.

SQL> EXEC DBMS_STATS.GATHER_FIXED_OBJECTS_STATS (NULL);
SQL> EXEC DBMS_STATS.GATHER_DICTIONARY_STATS;
SQL> EXEC DBMS_STATS.GATHER_SYSTEM_STATS;

SQL> EXEC DBMS_STATS.GATHER_FIXED_OBJECTS_STATS (NULL);

SQL> EXEC DBMS_STATS.GATHER_DICTIONARY_STATS;

SQL> EXEC DBMS_STATS.GATHER_SYSTEM_STATS;

Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

Data Pump Export process waiting with the message “wait for unread message on broadcast channel”

About dbtut

Leave a Reply Cancel reply