GV$TRANSACTION definition in Oracle 9i / www.oracledba.ru
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
from
x$ktcxb
where
bitand (ksspaflg, 1) !=0 and bitand (ktcxbflg, 2) !=0