pending.sql

rem pending.sql - Reports on any pending distributed transations.
set pagesize 999;
set feedback off;
set wrap on;
column local_tran_id  format a22 heading 'Local Txn Id'
column global_tran_id format a50 heading 'Global Txn Id'
column state          format a16 heading 'State'
column mixed          format a5  heading 'Mixed'
column advice         format a5  heading 'Advice'         

select local_tran_id,global_tran_id,state,mixed,advice
from   dba_2pc_pending
order  by local_tran_id;