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(+)
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(+)
|
|
|