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) |
