----------------------------------
-- SCRIPT v$trans.sql
-- INICO DO SCRIPT
-- ALEXANDRE PIRES 14/05/2012
----------------------------------
select inst_id
, ktcxbxba ADDR
, kxidusn XIDUSN
, kxidslt XIDSLOT
, kxidsqn XIDSQN
, ktcxbkfn UBAFIL
, kubablk UBABLK
, kubaseq UBASQN
, kubarec UBAREC
, decode( 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') STATUS
, ktcxbstm START_TIME
, ktcxbssb START_SCNB
, ktcxbssw START_SCNW
, ktcxbsen START_UEXT
, ktcxbsfl START_UBAFIL
, ktcxbsbk START_UBABLK
, ktcxbssq START_UBASQN
, ktcxbsrc START_UBAREC
, ktcxbses SES_ADDR
, ktcxbflg FLAG
, decode(bitand(ktcxbflg,16),0,'NO','YES') SPACE
, decode(bitand(ktcxbflg,32),0,'NO','YES') RECURSIVE
, decode(bitand(ktcxbflg,64),0,'NO','YES') NOUNDO
, decode(bitand(ktcxbflg,8388608),0,'NO','YES') PTX
, ktcxbpus PRV_XIDUSN
, ktcxbpsl PRV_XIDSLT
, ktcxbpsq PRV_XIDSQN
, ktcxbpxu PTX_XIDUSN
, ktcxbpxs PTX_XIDSLT
, ktcxbpxq PTX_XIDSQN
, ktcxbdsb "DSCN-B"
, ktcxbdsw "DSCN-W"
, ktcxbubk USED_UBLK
, ktcxburc USED_UREC
, ktcxblio LOG_IO
, ktcxbpio PHY_IO
, ktcxbcrg CR_GET
, ktcxbcrc CR_CHANGE
from x$ktcxb
where bitand(ksspaflg,1)!=0
and bitand(ktcxbflg,2)!=0
/
----------------------------------
-- FIM DO SCRIPT --
Anúncios
