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