VIEW: SYS._DEFSCHEDULE

Source

View Text - Preformatted

SELECT s.dblink, s.job, j.interval# interval, next_date,
         j.last_date, s.disabled, s.last_txn_count, s.last_error_number,
         s.last_error_message, s.catchup,
         s.total_txn_count,
         to_number(decode(s.total_prop_time_throughput, 0, NULL,
         s.total_txn_count/s.total_prop_time_throughput)) avg_throughput,
         to_number(decode(s.total_txn_count, 0, NULL,
         s.total_prop_time_latency/s.total_txn_count)) avg_latency,
         s.to_communication_size total_bytes_sent,
         s.from_communication_size total_bytes_received,
         s.spare1 total_round_trips,
         s.spare2 total_admin_count,
         s.spare3 total_error_count,
         s.spare4 total_sleep_time,
         DECODE(utl_raw.bit_and(utl_raw.substr(s.flag, 1, 1), '02'),
               '00', 'N', 'Y') disabled_internally_set,
         DECODE(utl_raw.bit_and(utl_raw.substr(s.flag, 1, 1), '01'),
               '00', 'N', 'Y') propagation_was_enabled
    FROM system.def$_destination s, sys.job$ j where s.job = j.job(+)

View Text - HTML Formatted

SELECT S.DBLINK
, S.JOB
, J.INTERVAL# INTERVAL
, NEXT_DATE
, J.LAST_DATE
, S.DISABLED
, S.LAST_TXN_COUNT
, S.LAST_ERROR_NUMBER
, S.LAST_ERROR_MESSAGE
, S.CATCHUP
, S.TOTAL_TXN_COUNT
, TO_NUMBER(DECODE(S.TOTAL_PROP_TIME_THROUGHPUT
, 0
, NULL
, S.TOTAL_TXN_COUNT/S.TOTAL_PROP_TIME_THROUGHPUT)) AVG_THROUGHPUT
, TO_NUMBER(DECODE(S.TOTAL_TXN_COUNT
, 0
, NULL
, S.TOTAL_PROP_TIME_LATENCY/S.TOTAL_TXN_COUNT)) AVG_LATENCY
, S.TO_COMMUNICATION_SIZE TOTAL_BYTES_SENT
, S.FROM_COMMUNICATION_SIZE TOTAL_BYTES_RECEIVED
, S.SPARE1 TOTAL_ROUND_TRIPS
, S.SPARE2 TOTAL_ADMIN_COUNT
, S.SPARE3 TOTAL_ERROR_COUNT
, S.SPARE4 TOTAL_SLEEP_TIME
, DECODE(UTL_RAW.BIT_AND(UTL_RAW.SUBSTR(S.FLAG
, 1
, 1)
, '02')
, '00'
, 'N'
, 'Y') DISABLED_INTERNALLY_SET
, DECODE(UTL_RAW.BIT_AND(UTL_RAW.SUBSTR(S.FLAG
, 1
, 1)
, '01')
, '00'
, 'N'
, 'Y') PROPAGATION_WAS_ENABLED
FROM SYSTEM.DEF$_DESTINATION S
, SYS.JOB$ J
WHERE S.JOB = J.JOB(+)