View:   X$KTUXE         [K]ernel [T]ransaction [U]ndo           Transa[x]tion [E]ntry (table)  This view is very useful as it gives an indication of the state  of the transaction tables in the rollback segment headers.  The information here can be used to see the state of transactions  requiring transaction recovery do not show in 
      
     
       may be useful to trace transaction recovery. Column          Type               Description --------        ----               -------- ADDR            RAW(4|8)           address of this row/entry in the array or SGA INDX            NUMBER             index number of this row in the fixed table array INST_ID         NUMBER       8.x   oracle instance numberTransaction ID KTUXEUSN        NUMBER             undo seg number       KUSNOLTP UB2MAXVAL           is no-undo xac KTUXESLT        NUMBER             slot number       KSLTINV  UB2MAXVAL           not a valid slot num KTUXESQN        NUMBER             wrap number, is savept # at start if no-undo xac                                     position within transaction KTUXERDBF       NUMBER             relative File KTUXERDBB       NUMBER             relative Block KTUXESCNB       NUMBER             SCN base for prepare/commit KTUXESCNW       NUMBER             SCN wrap for prepare/commit KTUXESTA        VARCHAR2(16)       Transaction Status KTUXECFL        VARCHAR2(24)       Transaction flags KTUXEUEL        NUMBER             Used for extent of tx and link to commit listDistributed tx: collecting dba and undo bk to start retrieving collecting info rec KTUXEDDBF       NUMBER             relative file KTUXEDDBB       NUMBER             relative dbaParent transaction id KTUXEPUSN       NUMBER       8.x   undo seg number       KUSNOLTP UB2MAXVAL           is no-undo xac KTUXEPSLT       NUMBER       8.x   slot number       KSLTINV  UB2MAXVAL           not a valid slot num KTUXEPSQN       NUMBER       8.x   wrap number, is savept # at start if no-undo xac                                      position within transaction KTUXESIZ        NUMBER       8.1  number of undo blocks used by the transactionNotes:To see any DEAD transactions for deferred transaction recovery  after startup:      select * from x$ktuxe where ktuxecfl='DEAD';