ALL_QUEUE_SCHEDULES
describes the propagation schedules whose source queues are accessible to the current user.
Related Views
DBA_QUEUE_SCHEDULES
describes all propagation schedules in the database.
USER_QUEUE_SCHEDULES
describes the propagation schedules whose source queues are owned by the current user. This view does not display the SCHEMA
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
Source queue owner |
|
|
|
Source queue name |
|
|
|
Destination name, currently limited to be a |
|
|
|
Date at which to start propagation |
|
|
|
Time of day at which to start propagation (in |
|
|
|
Duration for the propagation window (in seconds) |
|
|
|
Function to compute the start of the next propagation window |
|
|
|
Maximum wait time to propagate a message during the propagation window |
|
|
|
Indicates whether the schedule is disabled ( |
|
|
|
Name of the process executing the schedule; |
|
|
|
Session ID and session serial number of the job executing this schedule (SID, SERIAL#); |
|
|
|
Cluster database instance number executing the schedule |
|
|
|
Date of the last successful execution |
|
|
|
Time of day of the last successful execution (in |
|
|
|
Date at which the current window of this schedule was started |
|
|
|
Time of day at which the current window of this schedule was started (in |
|
|
|
Date at which the next window of this schedule will be started |
|
|
|
Time of day at which the next window of this schedule will be started (in |
|
|
|
Total time spent by the system in executing this schedule (in seconds) |
|
|
|
Total number of messages propagated in this schedule |
|
|
|
Total number of bytes propagated in this schedule |
|
|
|
Maximum number of messages propagated in a propagation window |
|
|
|
Maximum number of bytes propagated in a propagation window |
|
|
|
Average number of messages propagated in a propagation window |
|
|
|
Average size of a propagated message (in bytes) |
|
|
|
Average time to propagate a message (in seconds) |
|
|
|
Number of consecutive times schedule execution has failed, if any. After 16 consecutive failures, a propagation job becomes disabled automatically. |
|
|
|
Date of the last unsuccessful execution |
|
|
|
Time of day of the last unsuccessful execution (in |
|
|
|
Error number and error message text of the last unsuccessful execution |
|
|
|
Message delivery mode:
|
|
|
|
Elapsed dequeue time (in hundredths of a second) |
|
|
|
Elapsed pickle time (time taken to linearize a logical change record (LCR) into a stream of bytes that can be sent over the network) (in hundredths of a second) |
|
|
|
Name of the Scheduler job |
See Also: