Propagation Aborts Alert

This alert indicates a critical error. The propagation stops, and the messages that are normally sent from one queue to another by the propagation remain in the source queue. Replication that depends on the propagation also stops. Eventually, the source queue can grow too large, and messages can spill to disk. When messages spill to disk, it degrades Oracle Streams performance.

Response

Obtain the exact error message in one of the following ways:

• In Enterprise Manager, see "Viewing Information About a Propagation" for instructions.

• In SQL*Plus, query the DBA_QUEUE_SCHEDULES view.

Take the appropriate action for the error.

After taking the appropriate action, restart the propagation in one of the following ways:

• In Enterprise Manager, see "Enabling and Disabling a Propagation" for instructions.

• In SQL*Plus, run the DBMS_PROPAGATION_ADM.START_PROPAGATION procedure.