dba_propagation

COLUMN latency                  FORMAT 99999
COLUMN schedule_disabled HEADING 'Disabl' FORMAT A6
COLUMN process_name HEADING PROC FORMAT A8
COLUMN failures                 FORMAT 999
COLUMN total_num                FORMAT 99999999

SELECT p.propagation_name propagation_name,
TO_CHAR(s.start_date, 'HH24:MI:SS MM/DD/YY') START_DATE,
s.propagation_window DURATION, s.latency, s.schedule_disabled,
TO_CHAR(s.next_run_date, 'HH24:MI:SS MM/DD/YY') NEXT_TIME,
process_name, total_number, failures
FROM dba_queue_schedules S , dba_propagation P
SEE CODE DEPOT FOR FULL SCRIPT
/

This information shows just how busy the Propagation process is.

dba_queues

This view describes all queues in the database system.

To display all of the SYS.AnyData queues in a database, the following SQL query can be used: