Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)

B28320-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
PDF · Mobi · ePub

DBA_QUEUE_SCHEDULES

DBA_QUEUE_SCHEDULES describes all propagation schedules in the database.

Related View

USER_QUEUE_SCHEDULES describes the propagation schedules whose source queues are owned by the current user. This view does not display the SCHEMA column.

Column Datatype NULL Description
SCHEMA VARCHAR2(30)   Source queue owner
QNAME VARCHAR2(30)   Source queue name
DESTINATION VARCHAR2(128)   Destination name, currently limited to be a DBLINK name
START_DATE TIMESTAMP(6) WITH TIME ZONE   Date at which to start propagation
START_TIME VARCHAR2(8)   Time of day at which to start propagation (in HH:MI:SS format)
PROPAGATION_WINDOW NUMBER   Duration for the propagation window (in seconds)
NEXT_TIME VARCHAR2(4000)   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)   Indicates whether the schedule is disabled (Y) or enabled (N). If disabled, then the schedule will not be executed.
PROCESS_NAME VARCHAR2(4)   Name of the process executing the schedule; NULL if not currently executing
SESSION_ID VARCHAR2(82)   Session ID and session serial number of the job executing this schedule (SID, SERIAL#); NULL if not currently executing
INSTANCE NUMBER   Cluster database instance number executing the schedule
LAST_RUN_DATE TIMESTAMP(6) WITH TIME ZONE   Date of the last successful execution
LAST_RUN_TIME VARCHAR2(8)   Time of day of the last successful execution (in HH:MI:SS format)
CURRENT_START_DATE TIMESTAMP(6) WITH TIME ZONE   Date at which the current window of this schedule was started
CURRENT_START_TIME VARCHAR2(8)   Time of day at which the current window of this schedule was started (in HH:MI:SS format)
NEXT_RUN_DATE TIMESTAMP(6) WITH TIME ZONE   Date at which the next window of this schedule will be started
NEXT_RUN_TIME VARCHAR2(8)   Time of day at which the next window of this schedule will be started (in HH:MI:SS format)
TOTAL_TIME NUMBER   Total time spent by the system in executing this schedule (in seconds)
TOTAL_NUMBER NUMBER   Total number of messages propagated in this schedule
TOTAL_BYTES NUMBER   Total number of bytes propagated in this schedule
MAX_NUMBER NUMBER   Maximum number of messages propagated in a propagation window
MAX_BYTES NUMBER   Maximum number of bytes propagated in a propagation window
AVG_NUMBER NUMBER   Average number of messages propagated in a propagation window
AVG_SIZE NUMBER   Average size of a propagated message (in bytes)
AVG_TIME NUMBER   Average time to propagate a message (in seconds)
FAILURES NUMBER   Number of consecutive times schedule execution has failed, if any. After 16 consecutive failures, a propagation job becomes disabled automatically.
LAST_ERROR_DATE DATE   Date of the last unsuccessful execution
LAST_ERROR_TIME VARCHAR2(8)   Time of day of the last unsuccessful execution (in HH:MI:SS format)
LAST_ERROR_MSG VARCHAR2(4000)   Error number and error message text of the last unsuccessful execution
MESSAGE_DELIVERY_MODE VARCHAR2(10)   Message delivery mode:
  • PERSISTENT

  • BUFFERED

ELAPSED_DEQUEUE_TIME NUMBER   Elapsed dequeue time (in hundredths of a second)
ELAPSED_PICKLE_TIME NUMBER   Elapsed pickle time (time taken to linearize a logical change record (LCR) into a stream of bytes that can be sent over the network) (in hundredths of a second)
JOB_NAME VARCHAR2(30)   Name of the Scheduler job