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';
posted on 2013-03-19 00:32 Oracle和MySQL 阅读(426) 评论(0) 编辑 收藏 举报