VIEW: X$KTUXE – Transaction Entry (table)

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 <View:V$TRANSACTION>
  <Event:10013> 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 number

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

Distributed tx: collecting dba and undo bk to start retrieving collecting info rec
 KTUXEDDBF       NUMBER             relative file
 KTUXEDDBB       NUMBER             relative dba

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

Notes:

To see any DEAD transactions for deferred transaction recovery
  after startup:

      select * from x$ktuxe where ktuxecfl='DEAD';

Trackbacks

  1. […] X$KTUXE视图的介绍(转自Mcalean博客) 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 <View:V$TRANSACTION> <Event:10013> 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 NUMBER   TRANSACTION 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 list   Distributed tx: collecting dba AND undo bk TO START retrieving collecting info rec KTUXEDDBF NUMBER relative file KTUXEDDBB NUMBER relative dba   Parent 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 TRANSACTION   Notes:   TO see any DEAD transactions FOR deferred TRANSACTION recovery after startup:   SELECT * FROM x$ktuxe WHERE ktuxecfl='DEAD'; […]

Comment

*

沪ICP备14014813号-2

沪公网安备 31010802001379号