Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-03 |
|
|
View PDF |
DBA_QUEUE_SCHEDULES
describes the current schedules for propagating messages.
Related View
USER_QUEUE_SCHEDULES
describes current schedules related to the current user. This view does not display the SCHEMA
column.
Column | Datatype | NULL | Description |
---|---|---|---|
SCHEMA |
VARCHAR2(30) |
NOT NULL |
The schema |
QNAME |
VARCHAR2(30) |
NOT NULL |
Source queue name |
DESTINATION |
VARCHAR2(128) |
NOT NULL |
Destination name, currently limited to be a DBLINK name |
START_DATE |
DATE |
Date to start propagation in the default date format | |
START_TIME |
VARCHAR2(8) |
Time of day at which to start propagation in HH:MI:SS format |
|
PROPAGATION_WINDOW |
NUMBER |
Duration in seconds for the propagation window | |
NEXT_TIME |
VARCHAR2(200) |
Function to compute the start of the next propagation window | |
LATENCY |
NUMBER |
Maximum wait time to propagate a message during the propagation window | |
SCHEDULE_DISABLED |
VARCHAR2(1) |
N if enabled; Y if disabled and schedule will not be executed |
|
PROCESS_NAME |
VARCHAR2(8) |
The name of the process executing the schedule; NULL if not currently executing |
|
SESSION_ID |
NUMBER |
The session ID (SID, SERIAL#) of the job executing this schedule; NULL if not currently executing |
|
INSTANCE |
NUMBER |
The cluster database instance number executing the schedule | |
LAST_RUN_DATE |
DATE |
The date on the last successful execution | |
LAST_RUN_TIME |
VARCHAR2(8) |
The time of the last successful execution in HH:MI:SS format |
|
CURRENT_START_DATE |
DATE |
The date at which the current window of this schedule was started | |
CURRENT_START_TIME |
VARCHAR2(8) |
The time of day at which the current window of this schedule was started in HH:MI:SS format |
|
NEXT_RUN_DATE |
DATE |
The date at which the next window of this schedule will be started | |
NEXT_RUN_TIME |
VARCHAR2(8) |
The time of day at which the next window of this schedule will be started in HH:MI:SS format |
|
TOTAL_TIME |
NUMBER |
The total time, in seconds, spent by the system in executing this schedule | |
TOTAL_NUMBER |
NUMBER |
The total number of messages propagated in this schedule | |
TOTAL_BYTES |
NUMBER |
The total number of bytes propagated in this schedule | |
MAX_NUMBER |
NUMBER |
The maximum number of messages propagated in a propagation window | |
MAX_BYTES |
NUMBER |
The maximum number of bytes propagated in a propagation window | |
AVG_NUMBER |
NUMBER |
The average number of messages propagated in a propagation window | |
AVG_SIZE |
NUMBER |
The average size of a propagated message in bytes | |
AVG_TIME |
NUMBER |
The average time, in seconds, to propagate a message | |
FAILURES |
NUMBER |
The number of times the execution failed; if 16, the schedule will be disabled | |
LAST_ERROR_DATE |
DATE |
The date of the last unsuccessful execution | |
LAST_ERROR_TIME |
VARCHAR2(8) |
The time of the last unsuccessful execution | |
LAST_ERROR_MSG |
VARCHAR2(4000) |
The error number and error message text of the last unsuccessful execution | |
MESSAGE_DELIVERY_MODE |
VARCHAR2(10) |
Message delivery mode | |
ELAPSED_DEQUEUE_TIME |
NUMBER |
Elapsed dequeue time | |
ELAPSED_PICKLE_TIME |
NUMBER |
Elapsed pickle time (time taken to linearize an LCR into a stream of bytes that can be sent over the network) |