undo的一点内部机理！

最新推荐文章于 2021-04-07 04:30:53 发布

clt3617

最新推荐文章于 2021-04-07 04:30:53 发布

阅读量158

点赞数

文章标签：数据结构与算法数据库 php

--其实主要介绍了undo中的2条单向链表，明白了这2条链，有助于我们更深入的研究undo...[@more@]

--创建一个测试表tt，注意按照object_id事先排序了
SQL> create table tt tablespace users as select * from dba_objects order by obje
ct_id;

表已创建。
--查询一下object_id的最大值和最小值后面分析会用到
SQL> select min(object_id),max(object_id) from tt;

MIN(OBJECT_ID) MAX(OBJECT_ID)
-------------- --------------
2 10327

SQL> update tt set object_id=1;

已更新9882行。
--查看事务使用undo的情况
SQL> select xidusn,xidslot,ubablk,ubarec,start_ubablk,start_ubarec,used_ublk,use
d_urec from v$transaction;

XIDUSN XIDSLOT UBABLK UBAREC START_UBABLK START_UBAREC USED_UBLK USED_UREC
------ ------- ------ ------ ------------ ------------ ---------- ----------
4 26 747 49 37 7 190 19671

SQL>
update操作开启的这个事务共使用了190个block（上面查询USED_UBLK字段），那么这190个block其实
是一个由ubablk=747指向start_ubablk=37的单向链表，详细了解可以参考我之前写过的一篇文章：
http://www.itpub.net/viewthread.php?tid=1028714&extra=page%3D1&frombbs=1
在v$transaction中字段UBABLK排在START_UBABLK的前面是有一定道理的，因为UBABLK相对而言其实比
START_UBABLK更加有用，或者说UBABLK比START_UBABLK在事务恢复时要更早的用到，因为在事务恢复时是
倒着恢复的或者叫逆向恢复的，什么是逆向恢复呢？简单的说就是最后被修改的记录在恢复时先被恢复，
oracle之所以这样做我想无非是为了保证事务能够被完全或者被彻底恢复，因为最后一条记录的before image
在undo中都产生了，那么被修改的第一条记录的before image肯定产生了，也就是说这个事务被完成了，
这样表述不知道是否准确。
接下来我们还是先看看这190个block的分布情况，目的是使一会的dump更加清楚：
首先看看我们的事务使用了哪个undo segment：
SQL> select usn,xacts from v$rollstat where xacts<>0;

USN XACTS
---------- ----------
4 1
SQL> select segment_name,segment_id from dba_rollback_segs where segment_id=4;

SEGMENT_NAME SEGMENT_ID
-------------------- ----------
_SYSSMU4$ 4

SQL> select extent_id,file_id,block_id,blocks from dba_extents where segment_nam
e='_SYSSMU4$';

EXTENT_ID FILE_ID BLOCK_ID BLOCKS
---------- ---------- ---------- ----------
0 2 57 8
1 2 129 8
2 2 225 8
3 2 33 8
4 2 169 8
5 2 217 8
6 2 241 8
7 2 273 8
8 2 345 8
9 2 369 8
10 2 377 8

EXTENT_ID FILE_ID BLOCK_ID BLOCKS
---------- ---------- ---------- ----------
11 2 393 8
12 2 417 8
13 2 433 8
14 2 449 8
15 2 457 8
16 2 649 128

已选择17行。

dump一下事务使用的undo block组成的这个单向链表的第一个block：747
SQL> alter system dump datafile 2 block 747;

系统已更改。
--dump信息在下面
在分析事务恢复的过程之前先来简单介绍一下undo block中的几个要点：
1、undo中其实也是按照记录来存储的，表中的每一条记录被修改之后的
befroe image在undo中其实对应的也是一条记录，每一条记录的表示或者说标号是Rec，
就我们dump的这个block747中一共有 cnt: 0x31=49(10进制数）条记录；
2、最后一条记录是irb: 0x31=49,每一个被事务使用的undo block上为什么要记录irb，
因为irb是事务恢复的起点，irb表示的是什么意思呢？
irb :- Index of first record we need to consider in case of a rollback(active transaction record id)
通过上面的解释我想irb解释成每一个undo block中事务rollback时的起点，i我想应该是undo block中
第一条记录的index，rb是rollback吧，在没有看到e文解释之前，尽管网上有很多解释，但大都解释为：
"irb: 0x5f 指回滚段中记录的最近的未提交变更的开始之处，及最后一次更改之处"我看了这个解释之后
不能理解irb的意思，不知道大家以前是如何理解irb的？
3、知道一个事务使用的undo block组成了一个单向链表，也知道了事务恢复的起点是这个单向链表中最后一个
被使用的block（我们这个事务是block 747）中记录的最后一个rec：我们这个例子是747中的irb: 0x31，为了能够顺利
恢复我们还需要知道每一个undo block中记录（rec）的恢复顺序，其实上面提到逆向恢复了，这里起点是irb: 0x31，下一个
要恢复的当然是irb: 0x30了，这就需要在记录irb: 0x31中确切的知道irb: 0x30的位置，事实上记录irb: 0x31中也确实记录了
irb: 0x30，只不过是通过rci 0x30来表示的，rci是什么意思呢？
rci indicates the next undo record to apply within the undo chain.
这里的rc我想应该是record的意思，i同样是index的意思吧，rci合起来表述的意思应该是record index，不知道猜测的是否准确，
之前网上我看到的很多信息是
："rci，该参数代表的是undo chain（同一事务的多次修改，根据chain连接关联）的下一个偏移量"，看了之后不能很好的理解。
4、现在我们知道了2条链表，一条是事务使用的block组成的链表，另一条是undo block内部通过rci由下向上指向的一条链，通过这2条链我想
oracle可以保证事务顺利的rollback掉。
5、再来简单的分析一下这2条链，block747中的第一条要恢复的记录是Rec #0x31，
而Rec #0x31中记录的被修改的数据的before image是:
col 3: [ 4] c3 02 04 1c
接下来我们看看tt表中最后一条记录（max(object_id)=10327,最开始时我显示出来过）的dump信息：
SQL> select dump(2,16) dump2,dump(10327,16) dump10327 from dual;

DUMP2 DUMP10327
----------------- ----------------------
Typ=2 Len=2: c1,3 Typ=2 Len=4: c3,2,4,1c

SQL>
很显然一致，747中最后一条记录的是tt表中最后一条记录被修改(object_id)时的before
image:10327;Rec #0x31被恢复之后，通过Rec #0x31中记录的rci 0x30找到Rec #0x30恢复，Rec #0x30又找到
Rec #0x2f...如此下去直到找到block 747中的Rec #0x1，那么这个block 747就被使用完了，使用完之后
如何能找到block 746呢，这就用到了另外一条链，也就是需要知道747所指向的下一个undo block，而这个block是通过
记录在Rec #0x1中的rdba: 0x008002ea来实现的：
SQL> select dbms_utility.data_block_address_block(to_number('008002ea','xxxxxxxx
')) next_undo_block from dual;

NEXT_UNDO_BLOCK
---------------
746

SQL>
很显然顺利的找到了，如此下去...直到找到这个事务使用的第一个undo block=37(START_UBABLK)中的第7（START_UBAREC）条记录
Rec #0x7，而Rec #0x7里面记录的rci的值是0x00表示到了这条链的结尾了。
If rci is 0x00 that indicates end of the undo chain within the undo block.
那么block 37的第7条记录是我们tt表中被修改的第一条记录的值2吗？
对比一下看看吧：
Rec #0x7中记录的值是col 3: [ 2] c1 03
SQL> select dump(2,16) from dual;

DUMP(2,16)
-----------------
Typ=2 Len=2: c1,3

SQL>
很想然一致。
SQL> alter system dump datafile 2 block 37;

系统已更改。

SQL>
--block 37的dump信息在最下面
--==============================================
--block 747的dump信息如下：
Start dump data blocks tsn: 1 file#: 2 minblk 747 maxblk 747
buffer tsn: 1 rdba: 0x008002eb (2/747)
scn: 0x0000.00075eb0 seq: 0x32 flg: 0x04 tail: 0x5eb00232
frmt: 0x02 chkval: 0x896d type: 0x02=KTU UNDO BLOCK
Hex dump of block: st=0, typ_found=1
Dump of memory from 0x07172200 to 0x07174200
..................省去无关信息
********************************************************************************
UNDO BLK:
xid: 0x0004.01a.0000007c seq: 0x58 cnt: 0x31 irb: 0x31 icl: 0x0 flg: 0x0000

Rec Offset Rec Offset Rec Offset Rec Offset Rec Offset
---------------------------------------------------------------------------
0x01 0x1f90 0x02 0x1f38 0x03 0x1ee0 0x04 0x1e88 0x05 0x1e30
0x06 0x1dd8 0x07 0x1d80 0x08 0x1d28 0x09 0x1cd0 0x0a 0x1c78
0x0b 0x1c20 0x0c 0x1bc8 0x0d 0x1b70 0x0e 0x1b18 0x0f 0x1ac0
0x10 0x1a68 0x11 0x1a10 0x12 0x19b8 0x13 0x1960 0x14 0x1908
0x15 0x18b0 0x16 0x1858 0x17 0x1800 0x18 0x17a8 0x19 0x1750
0x1a 0x16f8 0x1b 0x16a0 0x1c 0x1648 0x1d 0x15f0 0x1e 0x1598
0x1f 0x1540 0x20 0x14e8 0x21 0x1490 0x22 0x1438 0x23 0x13e0
0x24 0x1388 0x25 0x1330 0x26 0x12d8 0x27 0x1280 0x28 0x1228
0x29 0x11d0 0x2a 0x1178 0x2b 0x1120 0x2c 0x10c8 0x2d 0x1070
0x2e 0x1018 0x2f 0x0fc0 0x30 0x0f68 0x31 0x0f10

*-----------------------------
* Rec #0x1 slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x008002ea
*-----------------------------
KDO undo record:
KTB Redo
op: 0x02 ver: 0x01
op: C uba: 0x008002ea.0058.5a
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x0100008f hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 34(0x22) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 03 3a

*-----------------------------
* Rec #0x2 slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x01
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: 0x008002eb.0058.01
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x0100008f hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 35(0x23) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 03 3b

*-----------------------------
* Rec #0x3 slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x02
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: 0x008002eb.0058.02
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x0100008f hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 36(0x24) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 03 3c

*-----------------------------
* Rec #0x4 slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x03
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: 0x008002eb.0058.03
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x0100008f hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 37(0x25) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 03 3e

*-----------------------------
* Rec #0x5 slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x04
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: 0x008002eb.0058.04
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x0100008f hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 38(0x26) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 03 3f

*-----------------------------
* Rec #0x6 slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x05
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: 0x008002eb.0058.05
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x0100008f hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 39(0x27) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 03 40

*-----------------------------
* Rec #0x7 slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x06
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: 0x008002eb.0058.06
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x0100008f hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 40(0x28) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 03 42

*-----------------------------
* Rec #0x8 slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x07
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: 0x008002eb.0058.07
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x0100008f hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 41(0x29) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 03 43

*-----------------------------
* Rec #0x9 slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x08
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: 0x008002eb.0058.08
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x0100008f hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 42(0x2a) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 03 44

*-----------------------------
* Rec #0xa slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x09
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: 0x008002eb.0058.09
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x0100008f hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 43(0x2b) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 03 46

*-----------------------------
* Rec #0xb slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x0a
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: 0x008002eb.0058.0a
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x0100008f hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 44(0x2c) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 03 47

*-----------------------------
* Rec #0xc slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x0b
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: 0x008002eb.0058.0b
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x0100008f hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 45(0x2d) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 03 48

*-----------------------------
* Rec #0xd slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x0c
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: 0x008002eb.0058.0c
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x0100008f hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 46(0x2e) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 03 4a

*-----------------------------
* Rec #0xe slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x0d
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: 0x008002eb.0058.0d
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x0100008f hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 47(0x2f) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 03 4b

*-----------------------------
* Rec #0xf slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x0e
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: 0x008002eb.0058.0e
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x0100008f hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 48(0x30) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 03 4c

*-----------------------------
* Rec #0x10 slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x0f
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: 0x008002eb.0058.0f
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x0100008f hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 49(0x31) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 03 4e

*-----------------------------
* Rec #0x11 slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x10
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: 0x008002eb.0058.10
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x0100008f hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 50(0x32) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 03 4f

*-----------------------------
* Rec #0x12 slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x11
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: 0x008002eb.0058.11
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x0100008f hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 51(0x33) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 03 50

*-----------------------------
* Rec #0x13 slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x12
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: 0x008002eb.0058.12
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x0100008f hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 52(0x34) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 03 52

*-----------------------------
* Rec #0x14 slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x13
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: 0x008002eb.0058.13
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x0100008f hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 53(0x35) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 03 53

*-----------------------------
* Rec #0x15 slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x14
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: 0x008002eb.0058.14
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x0100008f hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 54(0x36) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 03 54

*-----------------------------
* Rec #0x16 slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x15
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: 0x008002eb.0058.15
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x0100008f hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 55(0x37) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 03 56

*-----------------------------
* Rec #0x17 slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x16
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: 0x008002eb.0058.16
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x0100008f hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 56(0x38) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 03 57

*-----------------------------
* Rec #0x18 slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x17
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: 0x008002eb.0058.17
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x0100008f hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 57(0x39) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 03 58

*-----------------------------
* Rec #0x19 slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x18
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: 0x008002eb.0058.18
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x0100008f hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 58(0x3a) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 03 5a

*-----------------------------
* Rec #0x1a slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x19
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: 0x008002eb.0058.19
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x0100008f hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 59(0x3b) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 03 5b

*-----------------------------
* Rec #0x1b slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x1a
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: 0x008002eb.0058.1a
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x0100008f hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 60(0x3c) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 03 5c

*-----------------------------
* Rec #0x1c slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x1b
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: 0x008002eb.0058.1b
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x0100008f hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 61(0x3d) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 03 5e

*-----------------------------
* Rec #0x1d slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x1c
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: 0x008002eb.0058.1c
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x0100008f hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 62(0x3e) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 03 5f

*-----------------------------
* Rec #0x1e slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x1d
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: 0x008001c6.0056.2a
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x01000090 hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 0(0x0) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 03 60

*-----------------------------
* Rec #0x1f slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x1e
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: 0x008002eb.0058.1e
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x01000090 hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 1(0x1) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 03 62

*-----------------------------
* Rec #0x20 slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x1f
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: 0x008002eb.0058.1f
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x01000090 hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 2(0x2) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 03 63

*-----------------------------
* Rec #0x21 slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x20
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: 0x008002eb.0058.20
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x01000090 hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 3(0x3) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 03 64

*-----------------------------
* Rec #0x22 slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x21
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: 0x008002eb.0058.21
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x01000090 hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 4(0x4) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 04 02

*-----------------------------
* Rec #0x23 slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x22
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: 0x008002eb.0058.22
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x01000090 hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 5(0x5) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 04 03

*-----------------------------
* Rec #0x24 slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x23
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: 0x008002eb.0058.23
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x01000090 hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 6(0x6) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 04 04

*-----------------------------
* Rec #0x25 slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x24
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: 0x008002eb.0058.24
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x01000090 hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 7(0x7) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 04 06

*-----------------------------
* Rec #0x26 slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x25
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: 0x008002eb.0058.25
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x01000090 hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 8(0x8) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 04 07

*-----------------------------
* Rec #0x27 slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x26
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: 0x008002eb.0058.26
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x01000090 hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 9(0x9) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 04 08

*-----------------------------
* Rec #0x28 slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x27
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: 0x008002eb.0058.27
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x01000090 hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 10(0xa) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 04 0a

*-----------------------------
* Rec #0x29 slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x28
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: 0x008002eb.0058.28
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x01000090 hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 11(0xb) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 04 0b

*-----------------------------
* Rec #0x2a slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x29
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: 0x008002eb.0058.29
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x01000090 hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 12(0xc) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 04 0c

*-----------------------------
* Rec #0x2b slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x2a
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: 0x008002eb.0058.2a
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x01000090 hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 13(0xd) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 04 0e

*-----------------------------
* Rec #0x2c slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x2b
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: 0x008002eb.0058.2b
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x01000090 hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 14(0xe) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 04 0f

*-----------------------------
* Rec #0x2d slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x2c
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: 0x008002eb.0058.2c
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x01000090 hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 15(0xf) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 04 10

*-----------------------------
* Rec #0x2e slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x2d
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: 0x008002eb.0058.2d
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x01000090 hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 16(0x10) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 04 12

*-----------------------------
* Rec #0x2f slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x2e
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: 0x008002eb.0058.2e
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x01000090 hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 17(0x11) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 04 13

*-----------------------------
* Rec #0x30 slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x2f
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: 0x008002eb.0058.2f
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x01000090 hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 18(0x12) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 04 14

*-----------------------------
* Rec #0x31 slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x30
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: 0x008002eb.0058.30
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x01000090 hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 19(0x13) flag: 0x2c lock: 2 ckix: 7
ncol: 13 nnew: 1 size: 2
col 3: [ 4] c3 02 04 1c

End dump data blocks tsn: 1 file#: 2 minblk 747 maxblk 747
--==============================================
block 37的dump信息如下：
--==============================================
Start dump data blocks tsn: 1 file#: 2 minblk 37 maxblk 37
buffer tsn: 1 rdba: 0x00800025 (2/37)
scn: 0x0000.00075e2f seq: 0x2a flg: 0x04 tail: 0x5e2f022a
frmt: 0x02 chkval: 0x7238 type: 0x02=KTU UNDO BLOCK
Hex dump of block: st=0, typ_found=1
Dump of memory from 0x07172200 to 0x07174200
...........省去一些无关信息
********************************************************************************
UNDO BLK:
xid: 0x0004.01a.0000007c seq: 0x4b cnt: 0x31 irb: 0x7 icl: 0x0 flg: 0x0000

Rec Offset Rec Offset Rec Offset Rec Offset Rec Offset
---------------------------------------------------------------------------
0x01 0x1f74 0x02 0x1f24 0x03 0x1ea4 0x04 0x1e38 0x05 0x1dd8
0x06 0x1d80 0x07 0x1a2c 0x08 0x1700 0x09 0x13d4 0x0a 0x10a8
0x0b 0x0ec4 0x0c 0x0d5c 0x0d 0x0d04 0x0e 0x0cac 0x0f 0x0c54
0x10 0x0bfc 0x11 0x0ba4 0x12 0x0b4c 0x13 0x0af4 0x14 0x0a9c
0x15 0x0a44 0x16 0x09ec 0x17 0x0994 0x18 0x093c 0x19 0x08e4
0x1a 0x088c 0x1b 0x0834 0x1c 0x07dc 0x1d 0x0784 0x1e 0x072c
0x1f 0x06d4 0x20 0x067c 0x21 0x0624 0x22 0x05cc 0x23 0x0574
0x24 0x051c 0x25 0x04c4 0x26 0x046c 0x27 0x0414 0x28 0x03bc
0x29 0x0364 0x2a 0x030c 0x2b 0x02b4 0x2c 0x025c 0x2d 0x0204
0x2e 0x01ac 0x2f 0x0154 0x30 0x00fc 0x31 0x00a4

*-----------------------------
* Rec #0x1 slt: 0x08 objn: 10291(0x00002833) objd: 10291 tblspc: 2(0x00000002)
* Layer: 10 (Index) opc: 21 rci 0x00
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00800024
*-----------------------------
index general undo (branch) operations
KTB Redo
op: 0x05 ver: 0x01
op: R itc: 2
Itl Xid Uba Flag Lck Scn/Fsc
0x01 0x0000.000.00000000 0x00000000.0000.00 ---- 0 fsc 0x0000.00000000
0x02 0x0000.000.00000000 0x00000000.0000.00 ---- 0 fsc 0x0000.00000000
Dump kdige : block dba :0x00c02063, seghdr dba: 0x00c01e73
make leaf block empty
(2): 01 00

*-----------------------------
* Rec #0x2 slt: 0x08 objn: 10291(0x00002833) objd: 10291 tblspc: 2(0x00000002)
* Layer: 10 (Index) opc: 21 rci 0x01
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index general undo (branch) operations
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0002.029.0000007e uba: 0x008000c1.0041.02
flg: C--- lkc: 0 scn: 0x0000.00075638
Dump kdige : block dba :0x00c01e74, seghdr dba: 0x00c01e73
branch block row purge
(4): 01 00 0c 00

*-----------------------------
* Rec #0x3 slt: 0x14 objn: 3680(0x00000e60) objd: 3680 tblspc: 2(0x00000002)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
uba: 0x00800022.004b.03 ctl max scn: 0x0000.000703e0 prv tx scn: 0x0000.000703e8
txn start scn: scn: 0x0000.00075d67 logon user: 0
prev brb: 8389228 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0002.006.0000007f uba: 0x008000c1.0041.35
flg: C--- lkc: 0 scn: 0x0000.00075d64
KDO Op code: LKR row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x00c002e6 hdba: 0x00c002e3
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 13 to: 0

*-----------------------------
* Rec #0x4 slt: 0x14 objn: 3680(0x00000e60) objd: 3680 tblspc: 2(0x00000002)
* Layer: 11 (Row) opc: 1 rci 0x03
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: 0x00800025.004b.03
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x00c002e6 hdba: 0x00c002e3
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 13(0xd) flag: 0x2c lock: 2 ckix: 0
ncol: 25 nnew: 4 size: -9
col 8: [ 7] 78 6d 02 19 13 01 35
col 13: *NULL*
col 15: [ 2] c1 02
col 23: *NULL*

*-----------------------------
* Rec #0x5 slt: 0x14 objn: 3684(0x00000e64) objd: 3684 tblspc: 2(0x00000002)
* Layer: 10 (Index) opc: 22 rci 0x04
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0008.016.00000080 uba: 0x0080007b.0049.06
flg: C--- lkc: 0 scn: 0x0000.00075d5e
Dump kdilk : itl=2, kdxlkflg=0x1 sdc=0 indexid=0xc00303 block=0x00c00304
(kdxlre): restore leaf row (clear leaf delete flags)
key :(11): 02 c1 02 ff 06 00 c0 02 e6 00 0d

*-----------------------------
* Rec #0x6 slt: 0x14 objn: 3684(0x00000e64) objd: 3684 tblspc: 2(0x00000002)
* Layer: 10 (Index) opc: 22 rci 0x05
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x02 ver: 0x01
op: C uba: 0x00800025.004b.05
Dump kdilk : itl=2, kdxlkflg=0x1 sdc=126633488 indexid=0xc00303 block=0x00c00304
(kdxlpu): purge leaf row
key :(18): 02 c1 02 07 78 6d 02 19 13 01 35 06 00 c0 02 e6 00 0d

*-----------------------------
* Rec #0x7 slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
uba: 0x00800025.004b.03 ctl max scn: 0x0000.000703e8 prv tx scn: 0x0000.00070582
txn start scn: scn: 0x0000.00075e0e logon user: 0
prev brb: 8389228 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x03 ver: 0x01
op: Z
Array Update of 20 rows:
tabn: 0 slot: 0(0x0) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 12
col 3: [ 2] c1 03
tabn: 0 slot: 1(0x1) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 12
col 3: [ 2] c1 04
tabn: 0 slot: 2(0x2) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 10
col 3: [ 2] c1 05
tabn: 0 slot: 3(0x3) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 10
col 3: [ 2] c1 06
tabn: 0 slot: 4(0x4) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 11
col 3: [ 2] c1 07
tabn: 0 slot: 5(0x5) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 11
col 3: [ 2] c1 08
tabn: 0 slot: 6(0x6) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 20
col 3: [ 2] c1 09
tabn: 0 slot: 7(0x7) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 20
col 3: [ 2] c1 0a
tabn: 0 slot: 8(0x8) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 13
col 3: [ 2] c1 0b
tabn: 0 slot: 9(0x9) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 13
col 3: [ 2] c1 0c
tabn: 0 slot: 10(0xa) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 10
col 3: [ 2] c1 0d
tabn: 0 slot: 11(0xb) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 10
col 3: [ 2] c1 0e
tabn: 0 slot: 12(0xc) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 10
col 3: [ 2] c1 0f
tabn: 0 slot: 13(0xd) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 11
col 3: [ 2] c1 10
tabn: 0 slot: 14(0xe) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 9
col 3: [ 2] c1 11
tabn: 0 slot: 15(0xf) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 11
col 3: [ 2] c1 12
tabn: 0 slot: 16(0x10) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 10
col 3: [ 2] c1 13
tabn: 0 slot: 17(0x11) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 10
col 3: [ 2] c1 14
tabn: 0 slot: 18(0x12) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 11
col 3: [ 2] c1 15
tabn: 0 slot: 19(0x13) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 10
col 3: [ 2] c1 16

*-----------------------------
* Rec #0x8 slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x07
Undo type: Regular undo User Undo Applied Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
KDO undo record:
KTB Redo
op: 0x02 ver: 0x01
op: C uba: 0x00800025.004b.07
Array Update of 20 rows:
tabn: 0 slot: 20(0x14) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 11
col 3: [ 2] c1 17
tabn: 0 slot: 21(0x15) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 17
col 3: [ 2] c1 18
tabn: 0 slot: 22(0x16) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 19
col 3: [ 2] c1 19
tabn: 0 slot: 23(0x17) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 22
col 3: [ 2] c1 1a
tabn: 0 slot: 24(0x18) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 26
col 3: [ 2] c1 1b
tabn: 0 slot: 25(0x19) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 26
col 3: [ 2] c1 1c
tabn: 0 slot: 26(0x1a) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 10
col 3: [ 2] c1 1d
tabn: 0 slot: 27(0x1b) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 13
col 3: [ 2] c1 1e
tabn: 0 slot: 28(0x1c) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 13
col 3: [ 2] c1 1f
tabn: 0 slot: 29(0x1d) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 11
col 3: [ 2] c1 20
tabn: 0 slot: 30(0x1e) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 11
col 3: [ 2] c1 21
tabn: 0 slot: 31(0x1f) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 12
col 3: [ 2] c1 22
tabn: 0 slot: 32(0x20) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 13
col 3: [ 2] c1 23
tabn: 0 slot: 33(0x21) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 13
col 3: [ 2] c1 24
tabn: 0 slot: 34(0x22) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 12
col 3: [ 2] c1 25
tabn: 0 slot: 35(0x23) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 12
col 3: [ 2] c1 26
tabn: 0 slot: 36(0x24) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 12
col 3: [ 2] c1 27
tabn: 0 slot: 37(0x25) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 12
col 3: [ 2] c1 28
tabn: 0 slot: 38(0x26) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 13
col 3: [ 2] c1 29
tabn: 0 slot: 39(0x27) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 13
col 3: [ 2] c1 2a

*-----------------------------
* Rec #0x9 slt: 0x1a objn: 10327(0x00002857) objd: 10327 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x08
Undo type: Regular undo User Undo Applied Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
KDO undo record:
KTB Redo
op: 0x02 ver: 0x01
op: C uba: 0x00800025.004b.08
Array Update of 20 rows:
tabn: 0 slot: 40(0x28) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 13
col 3: [ 2] c1 2b
tabn: 0 slot: 41(0x29) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 11
col 3: [ 2] c1 2c
tabn: 0 slot: 42(0x2a) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 13
col 3: [ 2] c1 2d
tabn: 0 slot: 43(0x2b) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 12
col 3: [ 2] c1 2e
tabn: 0 slot: 44(0x2c) flag: 0x2c lock: 0 ckix: 7
ncol: 13 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x0100000c hdba: 0x0100000b
itli: 2 ispac: 0 maxfr: 4858
vect = 12
col 3: [ 2] c1 2f<

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/19602/viewspace-1017840/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/19602/viewspace-1017840/

clt3617

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
undo的一点内部机理！

--其实主要介绍了undo中的2条单向链表，明白了这2条链，有助于我们更深入的研究undo...[@more@]--创建一个测试表tt，注意按照object_id事先排序了SQL> create table tt tabl...
复制链接

扫一扫