一 说明：
SQL> select *from v$type_size where component='KTU';
COMPONEN TYPE DESCRIPTION TYPE_SIZE
-------- -------- -------------------------------- ----------
KTU KTUBH UNDO HEADER 16
KTU KTUXE UNDO TRANSACTION ENTRY 40
KTU KTUXC UNDO TRANSACTION CONTROL 104
ktuxe :kernerl transaction undo transaction entry
SQL> select ADDR,KTUXEUSN,KTUXESLT,KTUXESQN,KTUXESIZ from x$ktuxe where ktuxesta
!='INACTIVE';
ADDR KTUXEUSN KTUXESLT KTUXESQN KTUXESIZ
-------- ---------- ---------- ---------- ----------
07A7C590 9 30 339 1
SQL> select addr,xidusn,xidslot,xidsqn from v$transaction;
ADDR XIDUSN XIDSQN
-------- ---------- ----------
1E60D0AC 9 339
SQL> select sid,username,row_wait_obj# from v$session where taddr='1E60D0AC';
SID USERNAME ROW_WAIT_OBJ#
---------- ------------------------------ -------------
159 SCOTT 14
SQL> select * from v$rollname where usn=9;
USN NAME
---------- ------------------------------
9 _SYSSMU9$
取出dump块：
SQL>alter system dump undo header "_SYSSMU9$"
SQL> alter system dump undo block "_SYSSMU9$" xid 9 30 339;
SQL> select object_name from dba_objects where object_Id=51438;
OBJECT_NAME
--------------------------------------------------------------------------------
TMP_1
查看dump trc文件：
*-----------------------------
* Rec #0x3a slt: 0x1e objn: 51438(0x0000c8ee) objd: 51438 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x39
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
KDO undo record:
KTB Redo
op: 0x02 ver: 0x01
op: C uba: 0x008000aa.00b6.39
KDO Op code: LKR row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x0100003c hdba: 0x0100003b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 17 to: 0