VIEW: SYS.DBA_2PC_PENDING

Source

View Text - Preformatted

select  local_tran_id,
        nvl(global_oracle_id, global_tran_fmt||'.'||global_foreign_id),
        state, decode(status,'D','yes','no'), heuristic_dflt, tran_comment,
        fail_time, heuristic_time, reco_time,
        top_os_user, top_os_terminal, top_os_host, top_db_user, global_commit#
from    sys.pending_trans$

View Text - HTML Formatted

SELECT LOCAL_TRAN_ID
, NVL(GLOBAL_ORACLE_ID
, GLOBAL_TRAN_FMT||'.'||GLOBAL_FOREIGN_ID)
, STATE
, DECODE(STATUS
, 'D'
, 'YES'
, 'NO')
, HEURISTIC_DFLT
, TRAN_COMMENT
, FAIL_TIME
, HEURISTIC_TIME
, RECO_TIME
, TOP_OS_USER
, TOP_OS_TERMINAL
, TOP_OS_HOST
, TOP_DB_USER
, GLOBAL_COMMIT# FROM SYS.PENDING_TRANS$