|
SCHEMA--schema name for the source queue |
NOT NULL |
VARCHAR2(30) |
|
QNAME--source queue name |
NOT NULL |
VARCHAR2(30) |
|
DESTINATION--destination name, currently limited to be a DBLINK name |
NOT NULL |
VARCHAR2(128) |
|
START_DATE--date to start propagation in the default date format |
|
DATE |
|
START_TIME--time of day at which to start propagation in HH:MI:SS format |
|
VARCHAR2(8) |
|
PROPAGATION_WINDOW--duration in seconds for the propagation window |
|
NUMBER |
|
NEXT_TIME--function to compute the start of the next propagation window |
|
VARCHAR2(200) |
|
LATENCY--maximum wait time to propagate a message during the propagation window. |
|
NUMBER |
|
SCHEDULE_DISABLED--N if enabled Y if disabled and schedule will not be executed |
|
VARCHAR(1) |
|
PROCESS_NAME--The name of the SNP background process executing this schedule. NULL if not currently executing |
|
VARCHAR2(8) |
|
SESSION_ID--The session ID (SID, SERIAL#) of the job executing this schedule. NULL if not currently executing |
|
NUMBER |
|
INSTANCE--The Real Application Clusters instance number executing this schedule |
|
NUMBER |
|
LAST_RUN_DATE--The date on the last successful execution |
|
DATE |
|
LAST_RUN_TIME--The time of the last successful execution in HH:MI:SS format |
|
VARCHAR2(8) |
|
CURRENT_START_DATE--Date at which the current window of this schedule was started |
|
DATE |
|
CURRENT_START_TIME--Time of day at which the current window of this schedule was started in HH:MI:SS format |
|
VARCHAR2(8) |
|
NEXT_RUN_DATE--Date at which the next window of this schedule will be started |
|
DATE |
|
NEXT_RUN_TIME--Time of day at which the next window of this schedule will be started in HH:MI:SS format |
|
VARCHAR2(8) |
|
TOTAL_TIME--Total time in seconds spent in propagating messages from the schedule |
|
NUMBER |
|
TOTAL_NUMBER--Total number of messages propagated in this schedule |
|
NUMBER |
|
TOTAL_BYTES--Total number of bytes propagated in this schedule |
|
NUMBER |
|
MAX_NUMBER--The maximum number of messages propagated in a propagation window |
|
NUMBER |
|
MAX_BYTES--The maximum number of bytes propagated in a propagation window |
|
NUMBER |
|
AVG_NUMBER--The average number of messages propagated in a propagation window |
|
NUMBER |
|
AVG_SIZE--The average size of a propagated message in bytes |
|
NUMBER |
|
AVG_TIME--The average time, in seconds, to propagate a message |
|
NUMBER |
|
FAILURES--The number of times the execution failed. If 16, the schedule will be disabled |
|
NUMBER |
|
LAST_ERROR_DATE--The date of the last unsuccessful execution |
|
DATE |
|
LAST_ERROR_TIME--The time of the last unsuccessful execution |
|
VARCHAR2(8) |
|
LAST_ERROR_MSG--The error number and error message text of the last unsuccessful execution |
|
VARCHAR2(4000) |
