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