Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

DBA_QUEUE_SCHEDULES

DBA_QUEUE_SCHEDULES describes the current schedules for propagating messages.

Related View

USER_QUEUE_SCHEDULES describes current schedules related to the current user. This view does not display the SCHEMA column.

Column Datatype NULL Description
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)