Selecting Propagation Schedules in User Schema

Figure 10-11 Use Case Diagram: Select Propagation Schedules in User Schema

Text description of the illustration adq10qvw16.gif

Text description of the illustration adq81080.gif

Name of View

USER_QUEUE_SCHEDULES

Purpose

Table 10-11   USER_QUEUE_SCHEDULES

Column Name & Description	Null?	Type
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		VARCHAR2(82)
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)