[Home] [Help] [Dependency Information]
Object Name: | DEFSCHEDULE |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Information about propagation to different destinations
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DBLINK | VARCHAR2 | (128) | Yes | Destination |
JOB | NUMBER | Number of job that pushes queue | ||
INTERVAL | VARCHAR2 | (200) | Function used to calculate the next time to push the queue to destination | |
NEXT_DATE | DATE | Next date that job is scheduled to be executed | ||
LAST_DATE | DATE | Last time queue was (attempted to be) pushed to destination | ||
DISABLED | CHAR | (1) | Is propagation to destination disabled | |
LAST_TXN_COUNT | NUMBER | Number of transactions pushed during last attempt | ||
LAST_ERROR_NUMBER | NUMBER | Oracle error number from last push | ||
LAST_ERROR_MESSAGE | VARCHAR2 | (2000) | Error message from last push | |
CATCHUP | RAW | (16) | Yes | Used to break transaction into pieces |
TOTAL_TXN_COUNT | NUMBER | Total number of transactions propagated (including error transactions) | ||
AVG_THROUGHPUT | NUMBER | Average number of transactions (including errors) propagated per second | ||
AVG_LATENCY | NUMBER | Average time in seconds since start of transaction to remote commit | ||
TOTAL_BYTES_SENT | NUMBER | Total number of bytes sent over SQL*Net during propagation | ||
TOTAL_BYTES_RECEIVED | NUMBER | Total number of bytes received over SQL*Net during propagation | ||
TOTAL_ROUND_TRIPS | NUMBER | Total number of SQL*Net round trips during propagation | ||
TOTAL_ADMIN_COUNT | NUMBER | Total number of administrative requests | ||
TOTAL_ERROR_COUNT | NUMBER | Total number of error transactions propagated | ||
TOTAL_SLEEP_TIME | NUMBER | Total time in seconds spent sleeping during propagation | ||
DISABLED_INTERNALLY_SET | VARCHAR2 | (1) | disabled was set internally for propagation synchronization |
Cut, paste (and edit) the following text to query this object:
SELECT DBLINK
, JOB
, INTERVAL
, NEXT_DATE
, LAST_DATE
, DISABLED
, LAST_TXN_COUNT
, LAST_ERROR_NUMBER
, LAST_ERROR_MESSAGE
, CATCHUP
, TOTAL_TXN_COUNT
, AVG_THROUGHPUT
, AVG_LATENCY
, TOTAL_BYTES_SENT
, TOTAL_BYTES_RECEIVED
, TOTAL_ROUND_TRIPS
, TOTAL_ADMIN_COUNT
, TOTAL_ERROR_COUNT
, TOTAL_SLEEP_TIME
, DISABLED_INTERNALLY_SET
FROM SYS.DEFSCHEDULE;
|
|
|