VIEW: SYS.DEFTRAN

Source

View Text - Preformatted

SELECT
  enq_tid deferred_tran_id,
  cscn delivery_order,
  decode(recipient_key, 0, 'D', 'R') destination_list,
  enq_time start_time
  FROM system.def$_aqcall t
  WHERE cscn is NOT NULL
UNION ALL
SELECT enq_tid deferred_tran_id,
  cscn delivery_order,
  'D' destination_list,
  enq_time start_time
  FROM system.def$_aqerror t
  WHERE cscn is NOT NULL

View Text - HTML Formatted

SELECT ENQ_TID DEFERRED_TRAN_ID
, CSCN DELIVERY_ORDER
, DECODE(RECIPIENT_KEY
, 0
, 'D'
, 'R') DESTINATION_LIST
, ENQ_TIME START_TIME
FROM SYSTEM.DEF$_AQCALL T
WHERE CSCN IS NOT NULL UNION ALL SELECT ENQ_TID DEFERRED_TRAN_ID
, CSCN DELIVERY_ORDER
, 'D' DESTINATION_LIST
, ENQ_TIME START_TIME
FROM SYSTEM.DEF$_AQERROR T
WHERE CSCN IS NOT NULL