DEFSCHEDULE
Information about propagation to different destinationsColumns
___________________________
DBLINK
Destination
JOB
Number of job that pushes queue
INTERVAL
Function used to calculate the next time to push the queue to destination
NEXT_DATE
Next date that job is scheduled to be executed
LAST_DATE
Last time queue was (attempted to be) pushed to destination
DISABLED
Is propagation to destination disabled
LAST_TXN_COUNT
Number of transactions pushed during last attempt
LAST_ERROR_NUMBER
Oracle error number from last push
LAST_ERROR_MESSAGE
Error message from last push
CATCHUP
Used to break transaction into pieces
TOTAL_TXN_COUNT
Total number of transactions propagated (including error transactions)
AVG_THROUGHPUT
Average number of transactions (including errors) propagated per second
AVG_LATENCY
Average time in seconds since start of transaction to remote commit
TOTAL_BYTES_SENT
Total number of bytes sent over SQL*Net during propagation
TOTAL_BYTES_RECEIVED
Total number of bytes received over SQL*Net during propagation
TOTAL_ROUND_TRIPS
Total number of SQL*Net round trips during propagation
TOTAL_ADMIN_COUNT
Total number of administrative requests
TOTAL_ERROR_COUNT
Total number of error transactions propagated
TOTAL_SLEEP_TIME
Total time in seconds spent sleeping during propagation
DISABLED_INTERNALLY_SET
disabled was set internally for propagation synchronization
Related: