GV$TRANSACTION

select
inst_id,                 -- INST_ID NUMBER
ktcxbxba,                -- ADDR RAW(4)
kxidusn,                 -- XIDUSN NUMBER
kxidslt,                 -- XIDSLOT NUMBER
kxidsqn,                 -- XIDSQN NUMBER
ktcxbkfn,                -- UBAFIL NUMBER
kubablk,                 -- UBABLK NUMBER
kubaseq,                 -- UBASQN NUMBER
kubarec,                 -- UBAREC NUMBER
decode                   -- STATUS VARCHAR2(16)
  (ktcxbsta, 0, 'IDLE', 1, 'COLLECTING', 2, 'PREPARED', 3, 'COMMITTED', 4, 'HEURISTIC ABORT', 5, 'HEURISTIC COMMIT', 6, 'HEURISTIC DAMAGE', 7, 'TIMEOUT', 9, 'INACTIVE', 10, 'ACTIVE', 11, 'PTX PREPARED', 12, 'PTX COMMITTED', 'UNKNOWN'),
ktcxbstm,                -- START_TIME VARCHAR2(20)
ktcxbssb,                -- START_SCNB NUMBER
ktcxbssw,                -- START_SCNW NUMBER
ktcxbsen,                -- START_UEXT NUMBER
ktcxbsfl,                -- START_UBAFIL NUMBER
ktcxbsbk,                -- START_UBABLK NUMBER
ktcxbssq,                -- START_UBASQN NUMBER
ktcxbsrc,                -- START_UBAREC NUMBER
ktcxbses,                -- SES_ADDR RAW(4)
ktcxbflg,                -- FLAG NUMBER
decode                   -- SPACE VARCHAR2(3)
  (bitand (ktcxbflg, 16), 0, 'NO', 'YES'),
decode                   -- RECURSIVE VARCHAR2(3)
  (bitand (ktcxbflg, 32), 0, 'NO', 'YES'),
decode                   -- NOUNDO VARCHAR2(3)
  (bitand (ktcxbflg, 64), 0, 'NO', 'YES'),
decode                   -- PTX VARCHAR2(3)
  (bitand (ktcxbflg, 8388608), 0, 'NO', 'YES'),
ktcxbnam,                -- NAME VARCHAR2(256)
ktcxbpus,                -- PRV_XIDUSN NUMBER
ktcxbpsl,                -- PRV_XIDSLT NUMBER
ktcxbpsq,                -- PRV_XIDSQN NUMBER
ktcxbpxu,                -- PTX_XIDUSN NUMBER
ktcxbpxs,                -- PTX_XIDSLT NUMBER
ktcxbpxq,                -- PTX_XIDSQN NUMBER
ktcxbdsb,                -- DSCN-B NUMBER
ktcxbdsw,                -- DSCN-W NUMBER
ktcxbubk,                -- USED_UBLK NUMBER
ktcxburc,                -- USED_UREC NUMBER
ktcxblio,                -- LOG_IO NUMBER
ktcxbpio,                -- PHY_IO NUMBER
ktcxbcrg,                -- CR_GET NUMBER
ktcxbcrc,                -- CR_CHANGE NUMBER
to_date                  -- START_DATE DATE
  (ktcxbstm, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
ktcxbdsb,                -- DSCN_BASE NUMBER
ktcxbdsw,                -- DSCN_WRAP NUMBER
ktcxbssc,                -- START_SCN NUMBER
ktcxbdsc,                -- DEPENDENT_SCN NUMBER
ktcxbxid,                -- XID RAW(8)
ktcxbpid,                -- PRV_XID RAW(8)
ktcxbpxi                 -- PTX_XID RAW(8)
from
x$ktcxb 
where
bitand (ksspaflg, 1) !=0 and bitand (ktcxbflg, 2) !=0
home |  up  |  mailbox