---------------------------------- -- 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