Separate Queue in Case of Bi-directional
Replication
This helps to achieve better performance
for the Streams client processes.
Propagation Schedule Stuck in Pending State
When there are issues with configuration,
the DBA may want to stop the Streams process, including the
propagation schedule.
A queueing propagation schedule can be
unscheduled by executing the
dbma_awadm.unschedule_propagation procedure. Here is an
example. The system appeared to hang or take a long time when an
abort is initiated by a <CTRL-C>. When unschedule is
reattempted, the following statement is returned:
ORA-24080:UNSCHEDULED PROPOGATION PENDING <QUEUE NAME>. The
SCHEDULE_DISABLED column of the view has a value of P for this
schedule. P shows it is in pending state.
For example:
DNYTST10 SQL>EXEC
DBMS_STREAMS_ADM.REMOVE_STREAMS_CONFIGURATION();
BEGIN
DBMS_STREAMS_ADM.REMOVE_STREAMS_CONFIGURATION(); END;
*
ERROR at line 1:
ORA-24080: unschedule_propagation pending
for QUEUE STRMADM.NY3_QUEUE and
DESTINATION DNYOIP20.WORLD
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line
1644
ORA-06512: at line 1
