ORACLE SYS.PENDING_TRANS$中local_tran_id的构成

declare

l_return integer;

l_xid dbms_xa_xid := dbms_xa_xid(1966);

begin

l_return := dbms_xa.xa_start(l_xid, dbms_xa.TMNOFLAGS);

insert into test values(1,1);

l_return := dbms_xa.xa_end(l_xid, dbms_xa.TMSUCCESS);

l_return := dbms_xa.xa_prepare(l_xid);

end;

/

select XIDUSN,XIDSLOT,XIDSQN from v$transaction;

过一段时间再查询 sys.pending_trans$;

select LOCAL_TRAN_ID from sys.pending_trans$;

可以看到LOCAL_TRAN_ID的组成与XIDUSN,XIDSLOT,XIDSQN相同