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