select header_file,header_block from dba_segments where segment_name='SYSTEM'
FILE#, BLOCK#
------------- ---------------
1 128
Extent Control Header
-----------------------------------------------------------------
Extent Header:: spare1: 0 spare2: 0 #extents: 6 #blocks: 47 => SYSTEM UNDO 段 有6个区,总共47个block,去了一个段头块 128#
last map 0x00000000 #maps: 0 offset: 4128
Highwater:: 0x00400214 (1,532) ext#: 2(区 编号) blk#: 4 第5个块上,从0开始 ext size: 8 (区大小,8个块)
#blocks in seg. hdr's freelists: 0
#blocks below: 0
mapblk 0x00000000 offset: 2
Unlocked
Map Header:: next 0x00000000 #extents: 6 obj#: 0 flag: 0x40000000
Extent Map
区 map
-----------------------------------------------------------------
0x00400081 length: 7 1,128 0号区 7个块,1个undo header(128#)
0x00400088 length: 8 1,136 1号区 8个块
0x00400210 length: 8 1,528 2号区 8个块
0x00400218 length: 8 1,536 3号区 8个块
0x00400220 length: 8 1,544 4号区 8个块
0x00400228 length: 8 1,552 5号区 8个块
TRN CTL :: seq: 0x001a chd: 0x005f ctl: 0x0000 inc: 0x00000000 nfb: 0x0001 事物 控制文件
mgc: 0x8002 xts: 0x0068 flg: 0x0001 opt: 2147483646 (0x7ffffffe)
uba: 0x00400214.001a.18 scn: 0x0000.000e6bb0 ==> dba 1,532, undodba.sequnece.records
Version: 0x01
FREE BLOCK POOL::
undo dba .序列号.record_cnt
uba: 0x00400214.001a.18 ext: 0x2 spc: 0x806 =>2054
uba: 0x00000000.0019.02 ext: 0x1 spc: 0x1f1a
uba: 0x00000000.0017.02 ext: 0x5 spc: 0x1e6a
uba: 0x00000000.0000.00 ext: 0x0 spc: 0x0
uba: 0x00000000.0000.00 ext: 0x0 spc: 0x0
TRN TBL::事物表
index state cflags wrap# uel scn dba parent-xid nub stmt_num
------------------------------------------------------------------------------------------------
0x00 9 0x00 0x0014 0xffff 0x0000.000fb31a 0x00400214 0x0000.000.00000000 0x00000001 0x00000000
0x01 9 0x00 0x0013 0x000e 0x0000.000e6bd0 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x02 9 0x00 0x0013 0x0005 0x0000.000e6bcb 0x00400210 0x0000.000.00000000 0x00000001 0x00000000
0x03 9 0x00 0x0013 0x005c 0x0000.000e6bc3 0x00400210 0x0000.000.00000000 0x00000001 0x00000000
0x04 9 0x00 0x0014 0x004d 0x0000.000fb312 0x00400214 0x0000.000.00000000 0x00000001 0x00000000
0x05 9 0x00 0x0013 0x0001 0x0000.000e6bcd 0x00400210 0x0000.000.00000000 0x00000001 0x00000000
0x06 9 0x00 0x0013 0x0007 0x0000.000e6bb7 0x00400210 0x0000.000.00000000 0x00000001 0x00000000
0x07 9 0x00 0x0013 0x005e 0x0000.000e6bba 0x00400210 0x0000.000.00000000 0x00000001 0x00000000
0x08 9 0x00 0x0013 0x0006 0x0000.000e6bb6 0x00400210 0x0000.000.00000000 0x00000001 0x00000000
0x09 9 0x00 0x0013 0x0008 0x0000.000e6bb4 0x00400210 0x0000.000.00000000 0x00000001 0x00000000
0x0a 9 0x00 0x0013 0x0002 0x0000.000e6bc9 0x00400210 0x0000.000.00000000 0x00000001 0x00000000
0x0b 9 0x00 0x0013 0x0021 0x0000.000e6d83 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x0c 9 0x00 0x0013 0x000f 0x0000.000e6d7b 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x0d 9 0x00 0x0013 0x0019 0x0000.000e6d7f 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x0e 9 0x00 0x0013 0x0015 0x0000.000e6bd2 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x0f 9 0x00 0x0013 0x000d 0x0000.000e6d7d 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x10 9 0x00 0x0013 0x001b 0x0000.000e6d75 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x11 9 0x00 0x0013 0x0014 0x0000.000e74fa 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x12 9 0x00 0x0013 0x001e 0x0000.000e6d87 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x13 9 0x00 0x0013 0x000c 0x0000.000e6d79 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x14 9 0x00 0x0013 0x0029 0x0000.000e7506 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x15 9 0x00 0x0013 0x0017 0x0000.000e6d68 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x16 9 0x00 0x0013 0x0011 0x0000.000e6d9a 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x17 9 0x00 0x0013 0x0010 0x0000.000e6d73 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x18 9 0x00 0x0013 0x002a 0x0000.000e6d93 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x19 9 0x00 0x0013 0x000b 0x0000.000e6d81 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x1a 9 0x00 0x0013 0x0039 0x0000.000efc03 0x00400213 0x0000.000.00000000 0x00000001 0x00000000
0x1b 9 0x00 0x0013 0x0013 0x0000.000e6d77 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x1c 9 0x00 0x0013 0x0022 0x0000.000e6d8f 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x1d 9 0x00 0x0013 0x0016 0x0000.000e6d97 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x1e 9 0x00 0x0013 0x0020 0x0000.000e6d89 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x1f 9 0x00 0x0013 0x001c 0x0000.000e6d8d 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x20 9 0x00 0x0013 0x001f 0x0000.000e6d8b 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x21 9 0x00 0x0013 0x0012 0x0000.000e6d85 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x22 9 0x00 0x0013 0x0018 0x0000.000e6d91 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x23 9 0x00 0x0013 0x002e 0x0000.000e750c 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x24 9 0x00 0x0013 0x0023 0x0000.000e750a 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x25 9 0x00 0x0012 0x0032 0x0000.000e7519 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x26 9 0x00 0x0013 0x003a 0x0000.000efbe4 0x00400213 0x0000.000.00000000 0x00000002 0x00000000
0x27 9 0x00 0x0013 0x0049 0x0000.000fb2fa 0x00400214 0x0000.000.00000000 0x00000001 0x00000000
0x28 9 0x00 0x0013 0x0042 0x0000.000efbff 0x00400213 0x0000.000.00000000 0x00000001 0x00000000
0x29 9 0x00 0x0013 0x0024 0x0000.000e7508 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x2a 9 0x00 0x0013 0x001d 0x0000.000e6d95 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x2b 9 0x00 0x0013 0x0040 0x0000.000e7527 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x2c 9 0x00 0x0013 0x0031 0x0000.000e7515 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x2d 9 0x00 0x0013 0x002c 0x0000.000e7514 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x2e 9 0x00 0x0013 0x0035 0x0000.000e750e 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x2f 9 0x00 0x0013 0x003c 0x0000.000e7523 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x30 9 0x00 0x0013 0x0044 0x0000.000efc09 0x00400213 0x0000.000.00000000 0x00000001 0x00000000
0x31 9 0x00 0x0013 0x0025 0x0000.000e7517 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x32 9 0x00 0x0013 0x003b 0x0000.000e751b 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x33 9 0x00 0x0013 0x002d 0x0000.000e7512 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x34 9 0x00 0x0013 0x002f 0x0000.000e7521 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x35 9 0x00 0x0013 0x0033 0x0000.000e7510 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x36 9 0x00 0x0013 0x0026 0x0000.000e752b 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x37 9 0x00 0x0013 0x0034 0x0000.000e751f 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x38 9 0x00 0x0013 0x003d 0x0000.000efbf1 0x00400213 0x0000.000.00000000 0x00000001 0x00000000
0x39 9 0x00 0x0013 0x004b 0x0000.000efc05 0x00400213 0x0000.000.00000000 0x00000001 0x00000000
0x3a 9 0x00 0x0013 0x0038 0x0000.000efbef 0x00400213 0x0000.000.00000000 0x00000001 0x00000000
0x3b 9 0x00 0x0013 0x0037 0x0000.000e751d 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x3c 9 0x00 0x0013 0x002b 0x0000.000e7525 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x3d 9 0x00 0x0013 0x0048 0x0000.000efbf3 0x00400213 0x0000.000.00000000 0x00000001 0x00000000
0x3e 9 0x00 0x0013 0x0028 0x0000.000efbfd 0x00400213 0x0000.000.00000000 0x00000001 0x00000000
0x3f 9 0x00 0x0013 0x003e 0x0000.000efbfb 0x00400213 0x0000.000.00000000 0x00000001 0x00000000
0x40 9 0x00 0x0013 0x0036 0x0000.000e7529 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x41 9 0x00 0x0013 0x0047 0x0000.000efc11 0x00400213 0x0000.000.00000000 0x00000001 0x00000000
0x42 9 0x00 0x0013 0x001a 0x0000.000efc01 0x00400213 0x0000.000.00000000 0x00000001 0x00000000
0x43 9 0x00 0x0013 0x004c 0x0000.000efbf7 0x00400213 0x0000.000.00000000 0x00000001 0x00000000
0x44 9 0x00 0x0013 0x004a 0x0000.000efc0b 0x00400213 0x0000.000.00000000 0x00000001 0x00000000
0x45 9 0x00 0x0013 0x0041 0x0000.000efc0f 0x00400213 0x0000.000.00000000 0x00000001 0x00000000
0x46 9 0x00 0x0013 0x0060 0x0000.000fb30e 0x00400214 0x0000.000.00000000 0x00000001 0x00000000
0x47 9 0x00 0x0013 0x0058 0x0000.000efc13 0x00400213 0x0000.000.00000000 0x00000001 0x00000000
0x48 9 0x00 0x0013 0x0043 0x0000.000efbf5 0x00400213 0x0000.000.00000000 0x00000001 0x00000000
0x49 9 0x00 0x0013 0x0054 0x0000.000fb2fc 0x00400214 0x0000.000.00000000 0x00000001 0x00000000
0x4a 9 0x00 0x0013 0x0045 0x0000.000efc0d 0x00400213 0x0000.000.00000000 0x00000001 0x00000000
0x4b 9 0x00 0x0013 0x0030 0x0000.000efc07 0x00400213 0x0000.000.00000000 0x00000001 0x00000000
0x4c 9 0x00 0x0013 0x003f 0x0000.000efbf9 0x00400213 0x0000.000.00000000 0x00000001 0x00000000
0x4d 9 0x00 0x0013 0x005d 0x0000.000fb314 0x00400214 0x0000.000.00000000 0x00000001 0x00000000
0x4e 9 0x00 0x0013 0x0052 0x0000.000fb302 0x00400214 0x0000.000.00000000 0x00000001 0x00000000
0x4f 9 0x00 0x0013 0x0057 0x0000.000fb2e9 0x00400214 0x0000.000.00000000 0x00000002 0x00000000
0x50 9 0x00 0x0013 0x004e 0x0000.000fb300 0x00400214 0x0000.000.00000000 0x00000001 0x00000000
0x51 9 0x00 0x0013 0x0059 0x0000.000fb308 0x00400214 0x0000.000.00000000 0x00000001 0x00000000
0x52 9 0x00 0x0013 0x0055 0x0000.000fb304 0x00400214 0x0000.000.00000000 0x00000001 0x00000000
0x53 9 0x00 0x0013 0x0027 0x0000.000fb2f8 0x00400214 0x0000.000.00000000 0x00000001 0x00000000
0x54 9 0x00 0x0013 0x0050 0x0000.000fb2fe 0x00400214 0x0000.000.00000000 0x00000001 0x00000000
0x55 9 0x00 0x0013 0x0051 0x0000.000fb306 0x00400214 0x0000.000.00000000 0x00000001 0x00000000
0x56 9 0x00 0x0013 0x0053 0x0000.000fb2f6 0x00400214 0x0000.000.00000000 0x00000001 0x00000000
0x57 9 0x00 0x0013 0x0056 0x0000.000fb2f4 0x00400214 0x0000.000.00000000 0x00000001 0x00000000
0x58 9 0x00 0x0013 0x004f 0x0000.000efc15 0x00400213 0x0000.000.00000000 0x00000001 0x00000000
0x59 9 0x00 0x0013 0x005a 0x0000.000fb30a 0x00400214 0x0000.000.00000000 0x00000001 0x00000000
0x5a 9 0x00 0x0013 0x0046 0x0000.000fb30c 0x00400214 0x0000.000.00000000 0x00000001 0x00000000
0x5b 9 0x00 0x0013 0x0000 0x0000.000fb318 0x00400214 0x0000.000.00000000 0x00000001 0x00000000
0x5c 9 0x00 0x0012 0x000a 0x0000.000e6bc6 0x00400210 0x0000.000.00000000 0x00000001 0x00000000
0x5d 9 0x00 0x0013 0x005b 0x0000.000fb316 0x00400214 0x0000.000.00000000 0x00000001 0x00000000
0x5e 9 0x00 0x0012 0x0061 0x0000.000e6bbd 0x00400210 0x0000.000.00000000 0x00000001 0x00000000
0x5f 9 0x00 0x0012 0x0009 0x0000.000e6bb2 0x00400210 0x0000.000.00000000 0x00000001 0x00000000
0x60 9 0x00 0x0013 0x0004 0x0000.000fb310 0x00400214 0x0000.000.00000000 0x00000001 0x00000000
0x61 9 0x00 0x0012 0x0003 0x0000.000e6bc0 0x00400210 0x0000.000.00000000 0x00000001 0x00000000 ==> 9 事物非活动,10表示活动
End dump data blocks tsn: 0 file#: 1 minblk 128 maxblk 128
dump undo 块 532
alter system dump datafile 1 block 532;
select value from v$diag_info where name like 'Default%';
********************************************************************************
UNDO BLK:
xid: 0x0000.000.00000014 seq: 0x1a cnt: 0x18=> 24条记录 irb: 0x18 icl: 0x0 flg: 0x0000
uba 0x00400214.001a.18
532#,seq# 26,rec_cnt 24
Rec Offset Rec Offset Rec Offset Rec Offset Rec Offset
---------------------------------------------------------------------------
0x01 0x1f28 0x02 0x1e68 0x03 0x1da8 0x04 0x1ce8 0x05 0x1be0
0x06 0x1ad8 0x07 0x19d0 0x08 0x18c8 0x09 0x17c0 0x0a 0x16b8
0x0b 0x15b0 0x0c 0x14a8 0x0d 0x13a0 0x0e 0x1298 0x0f 0x1190
0x10 0x1088 0x11 0x0f80 0x12 0x0e78 0x13 0x0d70 0x14 0x0c68
0x15 0x0b60 0x16 0x0a58 0x17 0x0950 0x18 0x0848
*-----------------------------
* Rec #0x1 slt: 0x4f => transactions.xidslot objn: 15(0x0000000f) objd: 15 ==>undo$ tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00400213
*-----------------------------
KDO undo record:
KTB Redo
op: 0x02 ver: 0x01
compat bit: 4 (post-11) padding: 0
op: C uba: 0x00400213.001a.22
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 4(0x4) flag: 0x2c lock: 0 ckix: 24
*** 2015-08-13 22:00:16.494
ncol: 17 nnew: 12 size: -1
col 1: [20] 5f 53 59 53 53 4d 55 34 5f 31 34 35 31 39 31 30 36 33 34 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 02 4d
col 5: [ 4] c3 63 14 44
col 6: [ 1] 80
col 7: [ 3] c2 06 47
col 8: [ 3] c2 02 10
col 9: [ 1] 80
col 10: [ 2] c1 04
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0x2 slt: 0x4f objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* 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
compat bit: 4 (post-11) padding: 0
op: C uba: 0x00400214.001a.01
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 3(0x3) flag: 0x2c lock: 0 ckix: 24
ncol: 17 nnew: 12 size: -1
col 1: [19] 5f 53 59 53 53 4d 55 33 5f 34 37 38 36 30 38 39 36 38 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 02 3d
col 5: [ 4] c3 63 14 4a
col 6: [ 1] 80
col 7: [ 3] c2 09 14
col 8: [ 3] c2 03 13
col 9: [ 1] 80
col 10: [ 2] c1 04
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0x3 slt: 0x4f objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* 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
compat bit: 4 (post-11) padding: 0
op: C uba: 0x00400214.001a.02
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 2(0x2) flag: 0x2c lock: 0 ckix: 24
ncol: 17 nnew: 12 size: -1
col 1: [20] 5f 53 59 53 53 4d 55 32 5f 31 35 33 31 39 38 37 30 35 38 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 02 2d
col 5: [ 4] c3 63 14 4e
col 6: [ 1] 80
col 7: [ 3] c2 08 3e
col 8: [ 3] c2 02 2a
col 9: [ 1] 80
col 10: [ 2] c1 04
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0x4 slt: 0x4f objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* 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
compat bit: 4 (post-11) padding: 0
op: C uba: 0x00400214.001a.03
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 1(0x1) flag: 0x2c lock: 0 ckix: 24
ncol: 17 nnew: 12 size: -1
col 1: [20] 5f 53 59 53 53 4d 55 31 5f 33 30 38 36 38 39 39 37 30 37 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 02 1d
col 5: [ 4] c3 63 14 56
col 6: [ 1] 80
col 7: [ 3] c2 07 03
col 8: [ 3] c2 02 15
col 9: [ 1] 80
col 10: [ 2] c1 04
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0x5 slt: 0x57 objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00400213.001a.1d ctl max scn: 0x0000.000e6b87 prv tx scn: 0x0000.000e6b8a
txn start scn: scn: 0x0000.000fb2f3 logon user: 0
prev brb: 4194447 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 0
op: L itl: xid: 0x0000.04f.00000013 uba: 0x00400214.001a.04
flg: C--- lkc: 0 scn: 0x0000.000fb2e9
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 1(0x1) flag: 0x2c lock: 0 ckix: 18
ncol: 17 nnew: 12 size: 0
col 1: [20] 5f 53 59 53 53 4d 55 31 5f 33 30 38 36 38 39 39 37 30 37 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 02 1d
col 5: [ 5] c4 02 03 59 0e
col 6: [ 1] 80
col 7: [ 3] c2 07 2c
col 8: [ 3] c2 02 62
col 9: [ 1] 80
col 10: [ 2] c1 03
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0x6 slt: 0x56 objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00400214.001a.05 ctl max scn: 0x0000.000e6b8a prv tx scn: 0x0000.000e6b8c
txn start scn: scn: 0x0000.000fb2f5 logon user: 0
prev brb: 4194447 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 0
op: L itl: xid: 0x0000.057.00000013 uba: 0x00400214.001a.05
flg: C--- lkc: 0 scn: 0x0000.000fb2f4
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 1(0x1) flag: 0x2c lock: 0 ckix: 18
ncol: 17 nnew: 12 size: 0
col 1: [20] 5f 53 59 53 53 4d 55 31 5f 33 30 38 36 38 39 39 37 30 37 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 02 1d
col 5: [ 5] c4 02 03 59 0e
col 6: [ 1] 80
col 7: [ 3] c2 07 2c
col 8: [ 3] c2 02 62
col 9: [ 1] 80
col 10: [ 2] c1 03
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0x7 slt: 0x53 objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00400214.001a.06 ctl max scn: 0x0000.000e6b8c prv tx scn: 0x0000.000e6b8f
txn start scn: scn: 0x0000.000fb2f7 logon user: 0
prev brb: 4194447 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 0
op: L itl: xid: 0x0000.056.00000013 uba: 0x00400214.001a.06
flg: C--- lkc: 0 scn: 0x0000.000fb2f6
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 2(0x2) flag: 0x2c lock: 0 ckix: 18
ncol: 17 nnew: 12 size: 0
col 1: [20] 5f 53 59 53 53 4d 55 32 5f 31 35 33 31 39 38 37 30 35 38 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 02 2d
col 5: [ 5] c4 02 03 59 26
col 6: [ 1] 80
col 7: [ 3] c2 08 41
col 8: [ 3] c2 02 2a
col 9: [ 1] 80
col 10: [ 2] c1 03
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0x8 slt: 0x27 objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00400214.001a.07 ctl max scn: 0x0000.000e6b8f prv tx scn: 0x0000.000e6b90
txn start scn: scn: 0x0000.000fb2f9 logon user: 0
prev brb: 4194447 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 0
op: L itl: xid: 0x0000.053.00000013 uba: 0x00400214.001a.07
flg: C--- lkc: 0 scn: 0x0000.000fb2f8
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 2(0x2) flag: 0x2c lock: 0 ckix: 18
ncol: 17 nnew: 12 size: 0
col 1: [20] 5f 53 59 53 53 4d 55 32 5f 31 35 33 31 39 38 37 30 35 38 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 02 2d
col 5: [ 5] c4 02 03 59 26
col 6: [ 1] 80
col 7: [ 3] c2 08 41
col 8: [ 3] c2 02 2a
col 9: [ 1] 80
col 10: [ 2] c1 03
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0x9 slt: 0x49 objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00400214.001a.08 ctl max scn: 0x0000.000e6b90 prv tx scn: 0x0000.000e6b92
txn start scn: scn: 0x0000.000fb2fb logon user: 0
prev brb: 4194447 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 0
op: L itl: xid: 0x0000.027.00000013 uba: 0x00400214.001a.08
flg: C--- lkc: 0 scn: 0x0000.000fb2fa
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 3(0x3) flag: 0x2c lock: 0 ckix: 18
ncol: 17 nnew: 12 size: 0
col 1: [19] 5f 53 59 53 53 4d 55 33 5f 34 37 38 36 30 38 39 36 38 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 02 3d
col 5: [ 5] c4 02 03 59 18
col 6: [ 1] 80
col 7: [ 3] c2 09 17
col 8: [ 3] c2 03 14
col 9: [ 1] 80
col 10: [ 2] c1 03
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0xa slt: 0x54 objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00400214.001a.09 ctl max scn: 0x0000.000e6b92 prv tx scn: 0x0000.000e6b93
txn start scn: scn: 0x0000.000fb2fd logon user: 0
prev brb: 4194447 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 0
op: L itl: xid: 0x0000.049.00000013 uba: 0x00400214.001a.09
flg: C--- lkc: 0 scn: 0x0000.000fb2fc
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 3(0x3) flag: 0x2c lock: 0 ckix: 18
ncol: 17 nnew: 12 size: 0
col 1: [19] 5f 53 59 53 53 4d 55 33 5f 34 37 38 36 30 38 39 36 38 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 02 3d
col 5: [ 5] c4 02 03 59 18
col 6: [ 1] 80
col 7: [ 3] c2 09 17
col 8: [ 3] c2 03 14
col 9: [ 1] 80
col 10: [ 2] c1 03
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0xb slt: 0x50 objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00400214.001a.0a ctl max scn: 0x0000.000e6b93 prv tx scn: 0x0000.000e6b95
txn start scn: scn: 0x0000.000fb2ff logon user: 0
prev brb: 4194447 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 0
op: L itl: xid: 0x0000.054.00000013 uba: 0x00400214.001a.0a
flg: C--- lkc: 0 scn: 0x0000.000fb2fe
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 4(0x4) flag: 0x2c lock: 0 ckix: 18
ncol: 17 nnew: 12 size: 0
col 1: [20] 5f 53 59 53 53 4d 55 34 5f 31 34 35 31 39 31 30 36 33 34 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 02 4d
col 5: [ 5] c4 02 03 59 1e
col 6: [ 1] 80
col 7: [ 3] c2 06 49
col 8: [ 3] c2 02 11
col 9: [ 1] 80
col 10: [ 2] c1 03
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0xc slt: 0x4e objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00400214.001a.0b ctl max scn: 0x0000.000e6b95 prv tx scn: 0x0000.000e6b96
txn start scn: scn: 0x0000.000fb301 logon user: 0
prev brb: 4194447 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 0
op: L itl: xid: 0x0000.050.00000013 uba: 0x00400214.001a.0b
flg: C--- lkc: 0 scn: 0x0000.000fb300
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 4(0x4) flag: 0x2c lock: 0 ckix: 18
ncol: 17 nnew: 12 size: 0
col 1: [20] 5f 53 59 53 53 4d 55 34 5f 31 34 35 31 39 31 30 36 33 34 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 02 4d
col 5: [ 5] c4 02 03 59 1e
col 6: [ 1] 80
col 7: [ 3] c2 06 49
col 8: [ 3] c2 02 11
col 9: [ 1] 80
col 10: [ 2] c1 03
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0xd slt: 0x52 objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00400214.001a.0c ctl max scn: 0x0000.000e6b96 prv tx scn: 0x0000.000e6b98
txn start scn: scn: 0x0000.000fb303 logon user: 0
prev brb: 4194447 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 0
op: L itl: xid: 0x0000.04e.00000013 uba: 0x00400214.001a.0c
flg: C--- lkc: 0 scn: 0x0000.000fb302
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 5(0x5) flag: 0x2c lock: 0 ckix: 18
ncol: 17 nnew: 12 size: 0
col 1: [20] 5f 53 59 53 53 4d 55 35 5f 32 35 32 30 33 34 36 38 30 34 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 02 5d
col 5: [ 5] c4 02 03 59 24
col 6: [ 1] 80
col 7: [ 3] c2 08 63
col 8: [ 3] c2 02 32
col 9: [ 1] 80
col 10: [ 2] c1 03
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0xe slt: 0x55 objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00400214.001a.0d ctl max scn: 0x0000.000e6b98 prv tx scn: 0x0000.000e6b9a
txn start scn: scn: 0x0000.000fb305 logon user: 0
prev brb: 4194832 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 0
op: L itl: xid: 0x0000.052.00000013 uba: 0x00400214.001a.0d
flg: C--- lkc: 0 scn: 0x0000.000fb304
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 5(0x5) flag: 0x2c lock: 0 ckix: 18
ncol: 17 nnew: 12 size: 0
col 1: [20] 5f 53 59 53 53 4d 55 35 5f 32 35 32 30 33 34 36 38 30 34 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 02 5d
col 5: [ 5] c4 02 03 59 24
col 6: [ 1] 80
col 7: [ 3] c2 08 63
col 8: [ 3] c2 02 32
col 9: [ 1] 80
col 10: [ 2] c1 03
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0xf slt: 0x51 objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00400214.001a.0e ctl max scn: 0x0000.000e6b9a prv tx scn: 0x0000.000e6b9d
txn start scn: scn: 0x0000.000fb307 logon user: 0
prev brb: 4194832 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 0
op: L itl: xid: 0x0000.055.00000013 uba: 0x00400214.001a.0e
flg: C--- lkc: 0 scn: 0x0000.000fb306
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 6(0x6) flag: 0x2c lock: 0 ckix: 18
ncol: 17 nnew: 12 size: 0
col 1: [20] 5f 53 59 53 53 4d 55 36 5f 31 34 33 39 32 33 39 36 32 35 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 03 09
col 5: [ 5] c4 02 03 59 22
col 6: [ 1] 80
col 7: [ 3] c2 08 4a
col 8: [ 3] c2 02 22
col 9: [ 1] 80
col 10: [ 2] c1 03
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0x10 slt: 0x59 objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00400214.001a.0f ctl max scn: 0x0000.000e6b9d prv tx scn: 0x0000.000e6b9f
txn start scn: scn: 0x0000.000fb309 logon user: 0
prev brb: 4194832 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 0
op: L itl: xid: 0x0000.051.00000013 uba: 0x00400214.001a.0f
flg: C--- lkc: 0 scn: 0x0000.000fb308
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 6(0x6) flag: 0x2c lock: 0 ckix: 18
ncol: 17 nnew: 12 size: 0
col 1: [20] 5f 53 59 53 53 4d 55 36 5f 31 34 33 39 32 33 39 36 32 35 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 03 09
col 5: [ 5] c4 02 03 59 22
col 6: [ 1] 80
col 7: [ 3] c2 08 4a
col 8: [ 3] c2 02 22
col 9: [ 1] 80
col 10: [ 2] c1 03
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0x11 slt: 0x5a objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00400214.001a.10 ctl max scn: 0x0000.000e6b9f prv tx scn: 0x0000.000e6ba2
txn start scn: scn: 0x0000.000fb30b logon user: 0
prev brb: 4194832 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 0
op: L itl: xid: 0x0000.059.00000013 uba: 0x00400214.001a.10
flg: C--- lkc: 0 scn: 0x0000.000fb30a
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 7(0x7) flag: 0x2c lock: 0 ckix: 18
ncol: 17 nnew: 12 size: 0
col 1: [20] 5f 53 59 53 53 4d 55 37 5f 31 31 30 31 34 37 30 34 30 32 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 03 19
col 5: [ 5] c4 02 03 59 27
col 6: [ 1] 80
col 7: [ 3] c2 06 51
col 8: [ 3] c2 03 02
col 9: [ 1] 80
col 10: [ 2] c1 03
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0x12 slt: 0x46 objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00400214.001a.11 ctl max scn: 0x0000.000e6ba2 prv tx scn: 0x0000.000e6ba4
txn start scn: scn: 0x0000.000fb30d logon user: 0
prev brb: 4194832 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 0
op: L itl: xid: 0x0000.05a.00000013 uba: 0x00400214.001a.11
flg: C--- lkc: 0 scn: 0x0000.000fb30c
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 7(0x7) flag: 0x2c lock: 0 ckix: 18
ncol: 17 nnew: 12 size: 0
col 1: [20] 5f 53 59 53 53 4d 55 37 5f 31 31 30 31 34 37 30 34 30 32 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 03 19
col 5: [ 5] c4 02 03 59 27
col 6: [ 1] 80
col 7: [ 3] c2 06 51
col 8: [ 3] c2 03 02
col 9: [ 1] 80
col 10: [ 2] c1 03
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0x13 slt: 0x60 objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00400214.001a.12 ctl max scn: 0x0000.000e6ba4 prv tx scn: 0x0000.000e6ba6
txn start scn: scn: 0x0000.000fb30f logon user: 0
prev brb: 4194832 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 0
op: L itl: xid: 0x0000.046.00000013 uba: 0x00400214.001a.12
flg: C--- lkc: 0 scn: 0x0000.000fb30e
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 8(0x8) flag: 0x2c lock: 0 ckix: 18
ncol: 17 nnew: 12 size: 0
col 1: [20] 5f 53 59 53 53 4d 55 38 5f 31 36 38 32 32 38 33 31 37 34 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 03 29
col 5: [ 5] c4 02 03 59 1c
col 6: [ 1] 80
col 7: [ 3] c2 0a 36
col 8: [ 3] c2 02 2e
col 9: [ 1] 80
col 10: [ 2] c1 03
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0x14 slt: 0x04 objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00400214.001a.13 ctl max scn: 0x0000.000e6ba6 prv tx scn: 0x0000.000e6ba8
txn start scn: scn: 0x0000.000fb311 logon user: 0
prev brb: 4194832 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 0
op: L itl: xid: 0x0000.060.00000013 uba: 0x00400214.001a.13
flg: C--- lkc: 0 scn: 0x0000.000fb310
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 8(0x8) flag: 0x2c lock: 0 ckix: 18
ncol: 17 nnew: 12 size: 0
col 1: [20] 5f 53 59 53 53 4d 55 38 5f 31 36 38 32 32 38 33 31 37 34 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 03 29
col 5: [ 5] c4 02 03 59 1c
col 6: [ 1] 80
col 7: [ 3] c2 0a 36
col 8: [ 3] c2 02 2e
col 9: [ 1] 80
col 10: [ 2] c1 03
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0x15 slt: 0x4d objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00400214.001a.14 ctl max scn: 0x0000.000e6ba8 prv tx scn: 0x0000.000e6baa
txn start scn: scn: 0x0000.000fb313 logon user: 0
prev brb: 4194832 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 0
op: L itl: xid: 0x0000.004.00000014 uba: 0x00400214.001a.14
flg: C--- lkc: 0 scn: 0x0000.000fb312
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 9(0x9) flag: 0x2c lock: 0 ckix: 18
ncol: 17 nnew: 12 size: 0
col 1: [20] 5f 53 59 53 53 4d 55 39 5f 33 31 38 36 33 34 30 30 38 39 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 03 39
col 5: [ 5] c4 02 03 59 20
col 6: [ 1] 80
col 7: [ 3] c2 08 43
col 8: [ 3] c2 02 2e
col 9: [ 1] 80
col 10: [ 2] c1 03
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0x16 slt: 0x5d objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00400214.001a.15 ctl max scn: 0x0000.000e6baa prv tx scn: 0x0000.000e6bac
txn start scn: scn: 0x0000.000fb315 logon user: 0
prev brb: 4194832 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 0
op: L itl: xid: 0x0000.04d.00000013 uba: 0x00400214.001a.15
flg: C--- lkc: 0 scn: 0x0000.000fb314
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 9(0x9) flag: 0x2c lock: 0 ckix: 18
ncol: 17 nnew: 12 size: 0
col 1: [20] 5f 53 59 53 53 4d 55 39 5f 33 31 38 36 33 34 30 30 38 39 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 03 39
col 5: [ 5] c4 02 03 59 20
col 6: [ 1] 80
col 7: [ 3] c2 08 43
col 8: [ 3] c2 02 2e
col 9: [ 1] 80
col 10: [ 2] c1 03
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0x17 slt: 0x5b objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00400214.001a.16 ctl max scn: 0x0000.000e6bac prv tx scn: 0x0000.000e6bae
txn start scn: scn: 0x0000.000fb317 logon user: 0
prev brb: 4194832 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 0
op: L itl: xid: 0x0000.05d.00000013 uba: 0x00400214.001a.16
flg: C--- lkc: 0 scn: 0x0000.000fb316
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 10(0xa) flag: 0x2c lock: 0 ckix: 18
ncol: 17 nnew: 12 size: 0
col 1: [20] 5f 53 59 53 53 4d 55 31 30 5f 33 37 38 38 31 38 38 35 30 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 03 49
col 5: [ 5] c4 02 03 59 08
col 6: [ 1] 80
col 7: [ 3] c2 07 0c
col 8: [ 3] c2 02 0a
col 9: [ 1] 80
col 10: [ 2] c1 03
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0x18 slt: 0x00 objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00400214.001a.17 ctl max scn: 0x0000.000e6bae prv tx scn: 0x0000.000e6bb0
txn start scn: scn: 0x0000.000fb319 logon user: 0
prev brb: 4194832 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 0
op: L itl: xid: 0x0000.05b.00000013 uba: 0x00400214.001a.17
flg: C--- lkc: 0 scn: 0x0000.000fb318
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 10(0xa) flag: 0x2c lock: 0 ckix: 18
ncol: 17 nnew: 12 size: 0
col 1: [20] 5f 53 59 53 53 4d 55 31 30 5f 33 37 38 38 31 38 38 35 30 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 03 49
col 5: [ 5] c4 02 03 59 08
col 6: [ 1] 80
col 7: [ 3] c2 07 0c
col 8: [ 3] c2 02 0a
col 9: [ 1] 80
col 10: [ 2] c1 03
col 11: [ 2] c1 03
col 16: [ 2] c1 03
End dump data blocks tsn: 0 file#: 1 minblk 532 maxblk 532
FILE#, BLOCK#
------------- ---------------
1 128
Extent Control Header
-----------------------------------------------------------------
Extent Header:: spare1: 0 spare2: 0 #extents: 6 #blocks: 47 => SYSTEM UNDO 段 有6个区,总共47个block,去了一个段头块 128#
last map 0x00000000 #maps: 0 offset: 4128
Highwater:: 0x00400214 (1,532) ext#: 2(区 编号) blk#: 4 第5个块上,从0开始 ext size: 8 (区大小,8个块)
#blocks in seg. hdr's freelists: 0
#blocks below: 0
mapblk 0x00000000 offset: 2
Unlocked
Map Header:: next 0x00000000 #extents: 6 obj#: 0 flag: 0x40000000
Extent Map
区 map
-----------------------------------------------------------------
0x00400081 length: 7 1,128 0号区 7个块,1个undo header(128#)
0x00400088 length: 8 1,136 1号区 8个块
0x00400210 length: 8 1,528 2号区 8个块
0x00400218 length: 8 1,536 3号区 8个块
0x00400220 length: 8 1,544 4号区 8个块
0x00400228 length: 8 1,552 5号区 8个块
TRN CTL :: seq: 0x001a chd: 0x005f ctl: 0x0000 inc: 0x00000000 nfb: 0x0001 事物 控制文件
mgc: 0x8002 xts: 0x0068 flg: 0x0001 opt: 2147483646 (0x7ffffffe)
uba: 0x00400214.001a.18 scn: 0x0000.000e6bb0 ==> dba 1,532, undodba.sequnece.records
Version: 0x01
FREE BLOCK POOL::
undo dba .序列号.record_cnt
uba: 0x00400214.001a.18 ext: 0x2 spc: 0x806 =>2054
uba: 0x00000000.0019.02 ext: 0x1 spc: 0x1f1a
uba: 0x00000000.0017.02 ext: 0x5 spc: 0x1e6a
uba: 0x00000000.0000.00 ext: 0x0 spc: 0x0
uba: 0x00000000.0000.00 ext: 0x0 spc: 0x0
TRN TBL::事物表
index state cflags wrap# uel scn dba parent-xid nub stmt_num
------------------------------------------------------------------------------------------------
0x00 9 0x00 0x0014 0xffff 0x0000.000fb31a 0x00400214 0x0000.000.00000000 0x00000001 0x00000000
0x01 9 0x00 0x0013 0x000e 0x0000.000e6bd0 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x02 9 0x00 0x0013 0x0005 0x0000.000e6bcb 0x00400210 0x0000.000.00000000 0x00000001 0x00000000
0x03 9 0x00 0x0013 0x005c 0x0000.000e6bc3 0x00400210 0x0000.000.00000000 0x00000001 0x00000000
0x04 9 0x00 0x0014 0x004d 0x0000.000fb312 0x00400214 0x0000.000.00000000 0x00000001 0x00000000
0x05 9 0x00 0x0013 0x0001 0x0000.000e6bcd 0x00400210 0x0000.000.00000000 0x00000001 0x00000000
0x06 9 0x00 0x0013 0x0007 0x0000.000e6bb7 0x00400210 0x0000.000.00000000 0x00000001 0x00000000
0x07 9 0x00 0x0013 0x005e 0x0000.000e6bba 0x00400210 0x0000.000.00000000 0x00000001 0x00000000
0x08 9 0x00 0x0013 0x0006 0x0000.000e6bb6 0x00400210 0x0000.000.00000000 0x00000001 0x00000000
0x09 9 0x00 0x0013 0x0008 0x0000.000e6bb4 0x00400210 0x0000.000.00000000 0x00000001 0x00000000
0x0a 9 0x00 0x0013 0x0002 0x0000.000e6bc9 0x00400210 0x0000.000.00000000 0x00000001 0x00000000
0x0b 9 0x00 0x0013 0x0021 0x0000.000e6d83 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x0c 9 0x00 0x0013 0x000f 0x0000.000e6d7b 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x0d 9 0x00 0x0013 0x0019 0x0000.000e6d7f 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x0e 9 0x00 0x0013 0x0015 0x0000.000e6bd2 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x0f 9 0x00 0x0013 0x000d 0x0000.000e6d7d 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x10 9 0x00 0x0013 0x001b 0x0000.000e6d75 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x11 9 0x00 0x0013 0x0014 0x0000.000e74fa 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x12 9 0x00 0x0013 0x001e 0x0000.000e6d87 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x13 9 0x00 0x0013 0x000c 0x0000.000e6d79 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x14 9 0x00 0x0013 0x0029 0x0000.000e7506 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x15 9 0x00 0x0013 0x0017 0x0000.000e6d68 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x16 9 0x00 0x0013 0x0011 0x0000.000e6d9a 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x17 9 0x00 0x0013 0x0010 0x0000.000e6d73 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x18 9 0x00 0x0013 0x002a 0x0000.000e6d93 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x19 9 0x00 0x0013 0x000b 0x0000.000e6d81 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x1a 9 0x00 0x0013 0x0039 0x0000.000efc03 0x00400213 0x0000.000.00000000 0x00000001 0x00000000
0x1b 9 0x00 0x0013 0x0013 0x0000.000e6d77 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x1c 9 0x00 0x0013 0x0022 0x0000.000e6d8f 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x1d 9 0x00 0x0013 0x0016 0x0000.000e6d97 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x1e 9 0x00 0x0013 0x0020 0x0000.000e6d89 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x1f 9 0x00 0x0013 0x001c 0x0000.000e6d8d 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x20 9 0x00 0x0013 0x001f 0x0000.000e6d8b 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x21 9 0x00 0x0013 0x0012 0x0000.000e6d85 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x22 9 0x00 0x0013 0x0018 0x0000.000e6d91 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x23 9 0x00 0x0013 0x002e 0x0000.000e750c 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x24 9 0x00 0x0013 0x0023 0x0000.000e750a 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x25 9 0x00 0x0012 0x0032 0x0000.000e7519 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x26 9 0x00 0x0013 0x003a 0x0000.000efbe4 0x00400213 0x0000.000.00000000 0x00000002 0x00000000
0x27 9 0x00 0x0013 0x0049 0x0000.000fb2fa 0x00400214 0x0000.000.00000000 0x00000001 0x00000000
0x28 9 0x00 0x0013 0x0042 0x0000.000efbff 0x00400213 0x0000.000.00000000 0x00000001 0x00000000
0x29 9 0x00 0x0013 0x0024 0x0000.000e7508 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x2a 9 0x00 0x0013 0x001d 0x0000.000e6d95 0x00400211 0x0000.000.00000000 0x00000001 0x00000000
0x2b 9 0x00 0x0013 0x0040 0x0000.000e7527 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x2c 9 0x00 0x0013 0x0031 0x0000.000e7515 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x2d 9 0x00 0x0013 0x002c 0x0000.000e7514 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x2e 9 0x00 0x0013 0x0035 0x0000.000e750e 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x2f 9 0x00 0x0013 0x003c 0x0000.000e7523 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x30 9 0x00 0x0013 0x0044 0x0000.000efc09 0x00400213 0x0000.000.00000000 0x00000001 0x00000000
0x31 9 0x00 0x0013 0x0025 0x0000.000e7517 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x32 9 0x00 0x0013 0x003b 0x0000.000e751b 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x33 9 0x00 0x0013 0x002d 0x0000.000e7512 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x34 9 0x00 0x0013 0x002f 0x0000.000e7521 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x35 9 0x00 0x0013 0x0033 0x0000.000e7510 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x36 9 0x00 0x0013 0x0026 0x0000.000e752b 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x37 9 0x00 0x0013 0x0034 0x0000.000e751f 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x38 9 0x00 0x0013 0x003d 0x0000.000efbf1 0x00400213 0x0000.000.00000000 0x00000001 0x00000000
0x39 9 0x00 0x0013 0x004b 0x0000.000efc05 0x00400213 0x0000.000.00000000 0x00000001 0x00000000
0x3a 9 0x00 0x0013 0x0038 0x0000.000efbef 0x00400213 0x0000.000.00000000 0x00000001 0x00000000
0x3b 9 0x00 0x0013 0x0037 0x0000.000e751d 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x3c 9 0x00 0x0013 0x002b 0x0000.000e7525 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x3d 9 0x00 0x0013 0x0048 0x0000.000efbf3 0x00400213 0x0000.000.00000000 0x00000001 0x00000000
0x3e 9 0x00 0x0013 0x0028 0x0000.000efbfd 0x00400213 0x0000.000.00000000 0x00000001 0x00000000
0x3f 9 0x00 0x0013 0x003e 0x0000.000efbfb 0x00400213 0x0000.000.00000000 0x00000001 0x00000000
0x40 9 0x00 0x0013 0x0036 0x0000.000e7529 0x00400212 0x0000.000.00000000 0x00000001 0x00000000
0x41 9 0x00 0x0013 0x0047 0x0000.000efc11 0x00400213 0x0000.000.00000000 0x00000001 0x00000000
0x42 9 0x00 0x0013 0x001a 0x0000.000efc01 0x00400213 0x0000.000.00000000 0x00000001 0x00000000
0x43 9 0x00 0x0013 0x004c 0x0000.000efbf7 0x00400213 0x0000.000.00000000 0x00000001 0x00000000
0x44 9 0x00 0x0013 0x004a 0x0000.000efc0b 0x00400213 0x0000.000.00000000 0x00000001 0x00000000
0x45 9 0x00 0x0013 0x0041 0x0000.000efc0f 0x00400213 0x0000.000.00000000 0x00000001 0x00000000
0x46 9 0x00 0x0013 0x0060 0x0000.000fb30e 0x00400214 0x0000.000.00000000 0x00000001 0x00000000
0x47 9 0x00 0x0013 0x0058 0x0000.000efc13 0x00400213 0x0000.000.00000000 0x00000001 0x00000000
0x48 9 0x00 0x0013 0x0043 0x0000.000efbf5 0x00400213 0x0000.000.00000000 0x00000001 0x00000000
0x49 9 0x00 0x0013 0x0054 0x0000.000fb2fc 0x00400214 0x0000.000.00000000 0x00000001 0x00000000
0x4a 9 0x00 0x0013 0x0045 0x0000.000efc0d 0x00400213 0x0000.000.00000000 0x00000001 0x00000000
0x4b 9 0x00 0x0013 0x0030 0x0000.000efc07 0x00400213 0x0000.000.00000000 0x00000001 0x00000000
0x4c 9 0x00 0x0013 0x003f 0x0000.000efbf9 0x00400213 0x0000.000.00000000 0x00000001 0x00000000
0x4d 9 0x00 0x0013 0x005d 0x0000.000fb314 0x00400214 0x0000.000.00000000 0x00000001 0x00000000
0x4e 9 0x00 0x0013 0x0052 0x0000.000fb302 0x00400214 0x0000.000.00000000 0x00000001 0x00000000
0x4f 9 0x00 0x0013 0x0057 0x0000.000fb2e9 0x00400214 0x0000.000.00000000 0x00000002 0x00000000
0x50 9 0x00 0x0013 0x004e 0x0000.000fb300 0x00400214 0x0000.000.00000000 0x00000001 0x00000000
0x51 9 0x00 0x0013 0x0059 0x0000.000fb308 0x00400214 0x0000.000.00000000 0x00000001 0x00000000
0x52 9 0x00 0x0013 0x0055 0x0000.000fb304 0x00400214 0x0000.000.00000000 0x00000001 0x00000000
0x53 9 0x00 0x0013 0x0027 0x0000.000fb2f8 0x00400214 0x0000.000.00000000 0x00000001 0x00000000
0x54 9 0x00 0x0013 0x0050 0x0000.000fb2fe 0x00400214 0x0000.000.00000000 0x00000001 0x00000000
0x55 9 0x00 0x0013 0x0051 0x0000.000fb306 0x00400214 0x0000.000.00000000 0x00000001 0x00000000
0x56 9 0x00 0x0013 0x0053 0x0000.000fb2f6 0x00400214 0x0000.000.00000000 0x00000001 0x00000000
0x57 9 0x00 0x0013 0x0056 0x0000.000fb2f4 0x00400214 0x0000.000.00000000 0x00000001 0x00000000
0x58 9 0x00 0x0013 0x004f 0x0000.000efc15 0x00400213 0x0000.000.00000000 0x00000001 0x00000000
0x59 9 0x00 0x0013 0x005a 0x0000.000fb30a 0x00400214 0x0000.000.00000000 0x00000001 0x00000000
0x5a 9 0x00 0x0013 0x0046 0x0000.000fb30c 0x00400214 0x0000.000.00000000 0x00000001 0x00000000
0x5b 9 0x00 0x0013 0x0000 0x0000.000fb318 0x00400214 0x0000.000.00000000 0x00000001 0x00000000
0x5c 9 0x00 0x0012 0x000a 0x0000.000e6bc6 0x00400210 0x0000.000.00000000 0x00000001 0x00000000
0x5d 9 0x00 0x0013 0x005b 0x0000.000fb316 0x00400214 0x0000.000.00000000 0x00000001 0x00000000
0x5e 9 0x00 0x0012 0x0061 0x0000.000e6bbd 0x00400210 0x0000.000.00000000 0x00000001 0x00000000
0x5f 9 0x00 0x0012 0x0009 0x0000.000e6bb2 0x00400210 0x0000.000.00000000 0x00000001 0x00000000
0x60 9 0x00 0x0013 0x0004 0x0000.000fb310 0x00400214 0x0000.000.00000000 0x00000001 0x00000000
0x61 9 0x00 0x0012 0x0003 0x0000.000e6bc0 0x00400210 0x0000.000.00000000 0x00000001 0x00000000 ==> 9 事物非活动,10表示活动
End dump data blocks tsn: 0 file#: 1 minblk 128 maxblk 128
dump undo 块 532
alter system dump datafile 1 block 532;
select value from v$diag_info where name like 'Default%';
********************************************************************************
UNDO BLK:
xid: 0x0000.000.00000014 seq: 0x1a cnt: 0x18=> 24条记录 irb: 0x18 icl: 0x0 flg: 0x0000
uba 0x00400214.001a.18
532#,seq# 26,rec_cnt 24
Rec Offset Rec Offset Rec Offset Rec Offset Rec Offset
---------------------------------------------------------------------------
0x01 0x1f28 0x02 0x1e68 0x03 0x1da8 0x04 0x1ce8 0x05 0x1be0
0x06 0x1ad8 0x07 0x19d0 0x08 0x18c8 0x09 0x17c0 0x0a 0x16b8
0x0b 0x15b0 0x0c 0x14a8 0x0d 0x13a0 0x0e 0x1298 0x0f 0x1190
0x10 0x1088 0x11 0x0f80 0x12 0x0e78 0x13 0x0d70 0x14 0x0c68
0x15 0x0b60 0x16 0x0a58 0x17 0x0950 0x18 0x0848
*-----------------------------
* Rec #0x1 slt: 0x4f => transactions.xidslot objn: 15(0x0000000f) objd: 15 ==>undo$ tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00400213
*-----------------------------
KDO undo record:
KTB Redo
op: 0x02 ver: 0x01
compat bit: 4 (post-11) padding: 0
op: C uba: 0x00400213.001a.22
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 4(0x4) flag: 0x2c lock: 0 ckix: 24
*** 2015-08-13 22:00:16.494
ncol: 17 nnew: 12 size: -1
col 1: [20] 5f 53 59 53 53 4d 55 34 5f 31 34 35 31 39 31 30 36 33 34 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 02 4d
col 5: [ 4] c3 63 14 44
col 6: [ 1] 80
col 7: [ 3] c2 06 47
col 8: [ 3] c2 02 10
col 9: [ 1] 80
col 10: [ 2] c1 04
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0x2 slt: 0x4f objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* 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
compat bit: 4 (post-11) padding: 0
op: C uba: 0x00400214.001a.01
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 3(0x3) flag: 0x2c lock: 0 ckix: 24
ncol: 17 nnew: 12 size: -1
col 1: [19] 5f 53 59 53 53 4d 55 33 5f 34 37 38 36 30 38 39 36 38 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 02 3d
col 5: [ 4] c3 63 14 4a
col 6: [ 1] 80
col 7: [ 3] c2 09 14
col 8: [ 3] c2 03 13
col 9: [ 1] 80
col 10: [ 2] c1 04
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0x3 slt: 0x4f objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* 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
compat bit: 4 (post-11) padding: 0
op: C uba: 0x00400214.001a.02
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 2(0x2) flag: 0x2c lock: 0 ckix: 24
ncol: 17 nnew: 12 size: -1
col 1: [20] 5f 53 59 53 53 4d 55 32 5f 31 35 33 31 39 38 37 30 35 38 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 02 2d
col 5: [ 4] c3 63 14 4e
col 6: [ 1] 80
col 7: [ 3] c2 08 3e
col 8: [ 3] c2 02 2a
col 9: [ 1] 80
col 10: [ 2] c1 04
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0x4 slt: 0x4f objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* 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
compat bit: 4 (post-11) padding: 0
op: C uba: 0x00400214.001a.03
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 1(0x1) flag: 0x2c lock: 0 ckix: 24
ncol: 17 nnew: 12 size: -1
col 1: [20] 5f 53 59 53 53 4d 55 31 5f 33 30 38 36 38 39 39 37 30 37 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 02 1d
col 5: [ 4] c3 63 14 56
col 6: [ 1] 80
col 7: [ 3] c2 07 03
col 8: [ 3] c2 02 15
col 9: [ 1] 80
col 10: [ 2] c1 04
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0x5 slt: 0x57 objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00400213.001a.1d ctl max scn: 0x0000.000e6b87 prv tx scn: 0x0000.000e6b8a
txn start scn: scn: 0x0000.000fb2f3 logon user: 0
prev brb: 4194447 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 0
op: L itl: xid: 0x0000.04f.00000013 uba: 0x00400214.001a.04
flg: C--- lkc: 0 scn: 0x0000.000fb2e9
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 1(0x1) flag: 0x2c lock: 0 ckix: 18
ncol: 17 nnew: 12 size: 0
col 1: [20] 5f 53 59 53 53 4d 55 31 5f 33 30 38 36 38 39 39 37 30 37 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 02 1d
col 5: [ 5] c4 02 03 59 0e
col 6: [ 1] 80
col 7: [ 3] c2 07 2c
col 8: [ 3] c2 02 62
col 9: [ 1] 80
col 10: [ 2] c1 03
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0x6 slt: 0x56 objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00400214.001a.05 ctl max scn: 0x0000.000e6b8a prv tx scn: 0x0000.000e6b8c
txn start scn: scn: 0x0000.000fb2f5 logon user: 0
prev brb: 4194447 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 0
op: L itl: xid: 0x0000.057.00000013 uba: 0x00400214.001a.05
flg: C--- lkc: 0 scn: 0x0000.000fb2f4
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 1(0x1) flag: 0x2c lock: 0 ckix: 18
ncol: 17 nnew: 12 size: 0
col 1: [20] 5f 53 59 53 53 4d 55 31 5f 33 30 38 36 38 39 39 37 30 37 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 02 1d
col 5: [ 5] c4 02 03 59 0e
col 6: [ 1] 80
col 7: [ 3] c2 07 2c
col 8: [ 3] c2 02 62
col 9: [ 1] 80
col 10: [ 2] c1 03
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0x7 slt: 0x53 objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00400214.001a.06 ctl max scn: 0x0000.000e6b8c prv tx scn: 0x0000.000e6b8f
txn start scn: scn: 0x0000.000fb2f7 logon user: 0
prev brb: 4194447 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 0
op: L itl: xid: 0x0000.056.00000013 uba: 0x00400214.001a.06
flg: C--- lkc: 0 scn: 0x0000.000fb2f6
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 2(0x2) flag: 0x2c lock: 0 ckix: 18
ncol: 17 nnew: 12 size: 0
col 1: [20] 5f 53 59 53 53 4d 55 32 5f 31 35 33 31 39 38 37 30 35 38 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 02 2d
col 5: [ 5] c4 02 03 59 26
col 6: [ 1] 80
col 7: [ 3] c2 08 41
col 8: [ 3] c2 02 2a
col 9: [ 1] 80
col 10: [ 2] c1 03
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0x8 slt: 0x27 objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00400214.001a.07 ctl max scn: 0x0000.000e6b8f prv tx scn: 0x0000.000e6b90
txn start scn: scn: 0x0000.000fb2f9 logon user: 0
prev brb: 4194447 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 0
op: L itl: xid: 0x0000.053.00000013 uba: 0x00400214.001a.07
flg: C--- lkc: 0 scn: 0x0000.000fb2f8
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 2(0x2) flag: 0x2c lock: 0 ckix: 18
ncol: 17 nnew: 12 size: 0
col 1: [20] 5f 53 59 53 53 4d 55 32 5f 31 35 33 31 39 38 37 30 35 38 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 02 2d
col 5: [ 5] c4 02 03 59 26
col 6: [ 1] 80
col 7: [ 3] c2 08 41
col 8: [ 3] c2 02 2a
col 9: [ 1] 80
col 10: [ 2] c1 03
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0x9 slt: 0x49 objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00400214.001a.08 ctl max scn: 0x0000.000e6b90 prv tx scn: 0x0000.000e6b92
txn start scn: scn: 0x0000.000fb2fb logon user: 0
prev brb: 4194447 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 0
op: L itl: xid: 0x0000.027.00000013 uba: 0x00400214.001a.08
flg: C--- lkc: 0 scn: 0x0000.000fb2fa
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 3(0x3) flag: 0x2c lock: 0 ckix: 18
ncol: 17 nnew: 12 size: 0
col 1: [19] 5f 53 59 53 53 4d 55 33 5f 34 37 38 36 30 38 39 36 38 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 02 3d
col 5: [ 5] c4 02 03 59 18
col 6: [ 1] 80
col 7: [ 3] c2 09 17
col 8: [ 3] c2 03 14
col 9: [ 1] 80
col 10: [ 2] c1 03
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0xa slt: 0x54 objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00400214.001a.09 ctl max scn: 0x0000.000e6b92 prv tx scn: 0x0000.000e6b93
txn start scn: scn: 0x0000.000fb2fd logon user: 0
prev brb: 4194447 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 0
op: L itl: xid: 0x0000.049.00000013 uba: 0x00400214.001a.09
flg: C--- lkc: 0 scn: 0x0000.000fb2fc
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 3(0x3) flag: 0x2c lock: 0 ckix: 18
ncol: 17 nnew: 12 size: 0
col 1: [19] 5f 53 59 53 53 4d 55 33 5f 34 37 38 36 30 38 39 36 38 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 02 3d
col 5: [ 5] c4 02 03 59 18
col 6: [ 1] 80
col 7: [ 3] c2 09 17
col 8: [ 3] c2 03 14
col 9: [ 1] 80
col 10: [ 2] c1 03
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0xb slt: 0x50 objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00400214.001a.0a ctl max scn: 0x0000.000e6b93 prv tx scn: 0x0000.000e6b95
txn start scn: scn: 0x0000.000fb2ff logon user: 0
prev brb: 4194447 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 0
op: L itl: xid: 0x0000.054.00000013 uba: 0x00400214.001a.0a
flg: C--- lkc: 0 scn: 0x0000.000fb2fe
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 4(0x4) flag: 0x2c lock: 0 ckix: 18
ncol: 17 nnew: 12 size: 0
col 1: [20] 5f 53 59 53 53 4d 55 34 5f 31 34 35 31 39 31 30 36 33 34 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 02 4d
col 5: [ 5] c4 02 03 59 1e
col 6: [ 1] 80
col 7: [ 3] c2 06 49
col 8: [ 3] c2 02 11
col 9: [ 1] 80
col 10: [ 2] c1 03
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0xc slt: 0x4e objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00400214.001a.0b ctl max scn: 0x0000.000e6b95 prv tx scn: 0x0000.000e6b96
txn start scn: scn: 0x0000.000fb301 logon user: 0
prev brb: 4194447 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 0
op: L itl: xid: 0x0000.050.00000013 uba: 0x00400214.001a.0b
flg: C--- lkc: 0 scn: 0x0000.000fb300
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 4(0x4) flag: 0x2c lock: 0 ckix: 18
ncol: 17 nnew: 12 size: 0
col 1: [20] 5f 53 59 53 53 4d 55 34 5f 31 34 35 31 39 31 30 36 33 34 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 02 4d
col 5: [ 5] c4 02 03 59 1e
col 6: [ 1] 80
col 7: [ 3] c2 06 49
col 8: [ 3] c2 02 11
col 9: [ 1] 80
col 10: [ 2] c1 03
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0xd slt: 0x52 objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00400214.001a.0c ctl max scn: 0x0000.000e6b96 prv tx scn: 0x0000.000e6b98
txn start scn: scn: 0x0000.000fb303 logon user: 0
prev brb: 4194447 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 0
op: L itl: xid: 0x0000.04e.00000013 uba: 0x00400214.001a.0c
flg: C--- lkc: 0 scn: 0x0000.000fb302
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 5(0x5) flag: 0x2c lock: 0 ckix: 18
ncol: 17 nnew: 12 size: 0
col 1: [20] 5f 53 59 53 53 4d 55 35 5f 32 35 32 30 33 34 36 38 30 34 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 02 5d
col 5: [ 5] c4 02 03 59 24
col 6: [ 1] 80
col 7: [ 3] c2 08 63
col 8: [ 3] c2 02 32
col 9: [ 1] 80
col 10: [ 2] c1 03
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0xe slt: 0x55 objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00400214.001a.0d ctl max scn: 0x0000.000e6b98 prv tx scn: 0x0000.000e6b9a
txn start scn: scn: 0x0000.000fb305 logon user: 0
prev brb: 4194832 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 0
op: L itl: xid: 0x0000.052.00000013 uba: 0x00400214.001a.0d
flg: C--- lkc: 0 scn: 0x0000.000fb304
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 5(0x5) flag: 0x2c lock: 0 ckix: 18
ncol: 17 nnew: 12 size: 0
col 1: [20] 5f 53 59 53 53 4d 55 35 5f 32 35 32 30 33 34 36 38 30 34 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 02 5d
col 5: [ 5] c4 02 03 59 24
col 6: [ 1] 80
col 7: [ 3] c2 08 63
col 8: [ 3] c2 02 32
col 9: [ 1] 80
col 10: [ 2] c1 03
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0xf slt: 0x51 objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00400214.001a.0e ctl max scn: 0x0000.000e6b9a prv tx scn: 0x0000.000e6b9d
txn start scn: scn: 0x0000.000fb307 logon user: 0
prev brb: 4194832 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 0
op: L itl: xid: 0x0000.055.00000013 uba: 0x00400214.001a.0e
flg: C--- lkc: 0 scn: 0x0000.000fb306
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 6(0x6) flag: 0x2c lock: 0 ckix: 18
ncol: 17 nnew: 12 size: 0
col 1: [20] 5f 53 59 53 53 4d 55 36 5f 31 34 33 39 32 33 39 36 32 35 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 03 09
col 5: [ 5] c4 02 03 59 22
col 6: [ 1] 80
col 7: [ 3] c2 08 4a
col 8: [ 3] c2 02 22
col 9: [ 1] 80
col 10: [ 2] c1 03
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0x10 slt: 0x59 objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00400214.001a.0f ctl max scn: 0x0000.000e6b9d prv tx scn: 0x0000.000e6b9f
txn start scn: scn: 0x0000.000fb309 logon user: 0
prev brb: 4194832 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 0
op: L itl: xid: 0x0000.051.00000013 uba: 0x00400214.001a.0f
flg: C--- lkc: 0 scn: 0x0000.000fb308
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 6(0x6) flag: 0x2c lock: 0 ckix: 18
ncol: 17 nnew: 12 size: 0
col 1: [20] 5f 53 59 53 53 4d 55 36 5f 31 34 33 39 32 33 39 36 32 35 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 03 09
col 5: [ 5] c4 02 03 59 22
col 6: [ 1] 80
col 7: [ 3] c2 08 4a
col 8: [ 3] c2 02 22
col 9: [ 1] 80
col 10: [ 2] c1 03
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0x11 slt: 0x5a objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00400214.001a.10 ctl max scn: 0x0000.000e6b9f prv tx scn: 0x0000.000e6ba2
txn start scn: scn: 0x0000.000fb30b logon user: 0
prev brb: 4194832 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 0
op: L itl: xid: 0x0000.059.00000013 uba: 0x00400214.001a.10
flg: C--- lkc: 0 scn: 0x0000.000fb30a
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 7(0x7) flag: 0x2c lock: 0 ckix: 18
ncol: 17 nnew: 12 size: 0
col 1: [20] 5f 53 59 53 53 4d 55 37 5f 31 31 30 31 34 37 30 34 30 32 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 03 19
col 5: [ 5] c4 02 03 59 27
col 6: [ 1] 80
col 7: [ 3] c2 06 51
col 8: [ 3] c2 03 02
col 9: [ 1] 80
col 10: [ 2] c1 03
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0x12 slt: 0x46 objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00400214.001a.11 ctl max scn: 0x0000.000e6ba2 prv tx scn: 0x0000.000e6ba4
txn start scn: scn: 0x0000.000fb30d logon user: 0
prev brb: 4194832 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 0
op: L itl: xid: 0x0000.05a.00000013 uba: 0x00400214.001a.11
flg: C--- lkc: 0 scn: 0x0000.000fb30c
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 7(0x7) flag: 0x2c lock: 0 ckix: 18
ncol: 17 nnew: 12 size: 0
col 1: [20] 5f 53 59 53 53 4d 55 37 5f 31 31 30 31 34 37 30 34 30 32 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 03 19
col 5: [ 5] c4 02 03 59 27
col 6: [ 1] 80
col 7: [ 3] c2 06 51
col 8: [ 3] c2 03 02
col 9: [ 1] 80
col 10: [ 2] c1 03
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0x13 slt: 0x60 objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00400214.001a.12 ctl max scn: 0x0000.000e6ba4 prv tx scn: 0x0000.000e6ba6
txn start scn: scn: 0x0000.000fb30f logon user: 0
prev brb: 4194832 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 0
op: L itl: xid: 0x0000.046.00000013 uba: 0x00400214.001a.12
flg: C--- lkc: 0 scn: 0x0000.000fb30e
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 8(0x8) flag: 0x2c lock: 0 ckix: 18
ncol: 17 nnew: 12 size: 0
col 1: [20] 5f 53 59 53 53 4d 55 38 5f 31 36 38 32 32 38 33 31 37 34 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 03 29
col 5: [ 5] c4 02 03 59 1c
col 6: [ 1] 80
col 7: [ 3] c2 0a 36
col 8: [ 3] c2 02 2e
col 9: [ 1] 80
col 10: [ 2] c1 03
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0x14 slt: 0x04 objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00400214.001a.13 ctl max scn: 0x0000.000e6ba6 prv tx scn: 0x0000.000e6ba8
txn start scn: scn: 0x0000.000fb311 logon user: 0
prev brb: 4194832 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 0
op: L itl: xid: 0x0000.060.00000013 uba: 0x00400214.001a.13
flg: C--- lkc: 0 scn: 0x0000.000fb310
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 8(0x8) flag: 0x2c lock: 0 ckix: 18
ncol: 17 nnew: 12 size: 0
col 1: [20] 5f 53 59 53 53 4d 55 38 5f 31 36 38 32 32 38 33 31 37 34 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 03 29
col 5: [ 5] c4 02 03 59 1c
col 6: [ 1] 80
col 7: [ 3] c2 0a 36
col 8: [ 3] c2 02 2e
col 9: [ 1] 80
col 10: [ 2] c1 03
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0x15 slt: 0x4d objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00400214.001a.14 ctl max scn: 0x0000.000e6ba8 prv tx scn: 0x0000.000e6baa
txn start scn: scn: 0x0000.000fb313 logon user: 0
prev brb: 4194832 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 0
op: L itl: xid: 0x0000.004.00000014 uba: 0x00400214.001a.14
flg: C--- lkc: 0 scn: 0x0000.000fb312
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 9(0x9) flag: 0x2c lock: 0 ckix: 18
ncol: 17 nnew: 12 size: 0
col 1: [20] 5f 53 59 53 53 4d 55 39 5f 33 31 38 36 33 34 30 30 38 39 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 03 39
col 5: [ 5] c4 02 03 59 20
col 6: [ 1] 80
col 7: [ 3] c2 08 43
col 8: [ 3] c2 02 2e
col 9: [ 1] 80
col 10: [ 2] c1 03
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0x16 slt: 0x5d objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00400214.001a.15 ctl max scn: 0x0000.000e6baa prv tx scn: 0x0000.000e6bac
txn start scn: scn: 0x0000.000fb315 logon user: 0
prev brb: 4194832 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 0
op: L itl: xid: 0x0000.04d.00000013 uba: 0x00400214.001a.15
flg: C--- lkc: 0 scn: 0x0000.000fb314
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 9(0x9) flag: 0x2c lock: 0 ckix: 18
ncol: 17 nnew: 12 size: 0
col 1: [20] 5f 53 59 53 53 4d 55 39 5f 33 31 38 36 33 34 30 30 38 39 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 03 39
col 5: [ 5] c4 02 03 59 20
col 6: [ 1] 80
col 7: [ 3] c2 08 43
col 8: [ 3] c2 02 2e
col 9: [ 1] 80
col 10: [ 2] c1 03
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0x17 slt: 0x5b objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00400214.001a.16 ctl max scn: 0x0000.000e6bac prv tx scn: 0x0000.000e6bae
txn start scn: scn: 0x0000.000fb317 logon user: 0
prev brb: 4194832 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 0
op: L itl: xid: 0x0000.05d.00000013 uba: 0x00400214.001a.16
flg: C--- lkc: 0 scn: 0x0000.000fb316
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 10(0xa) flag: 0x2c lock: 0 ckix: 18
ncol: 17 nnew: 12 size: 0
col 1: [20] 5f 53 59 53 53 4d 55 31 30 5f 33 37 38 38 31 38 38 35 30 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 03 49
col 5: [ 5] c4 02 03 59 08
col 6: [ 1] 80
col 7: [ 3] c2 07 0c
col 8: [ 3] c2 02 0a
col 9: [ 1] 80
col 10: [ 2] c1 03
col 11: [ 2] c1 03
col 16: [ 2] c1 03
*-----------------------------
* Rec #0x18 slt: 0x00 objn: 15(0x0000000f) objd: 15 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00400214.001a.17 ctl max scn: 0x0000.000e6bae prv tx scn: 0x0000.000e6bb0
txn start scn: scn: 0x0000.000fb319 logon user: 0
prev brb: 4194832 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 0
op: L itl: xid: 0x0000.05b.00000013 uba: 0x00400214.001a.17
flg: C--- lkc: 0 scn: 0x0000.000fb318
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0
itli: 1 ispac: 0 maxfr: 4863
tabn: 0 slot: 10(0xa) flag: 0x2c lock: 0 ckix: 18
ncol: 17 nnew: 12 size: 0
col 1: [20] 5f 53 59 53 53 4d 55 31 30 5f 33 37 38 38 31 38 38 35 30 24
col 2: [ 2] c1 02
col 3: [ 2] c1 04
col 4: [ 3] c2 03 49
col 5: [ 5] c4 02 03 59 08
col 6: [ 1] 80
col 7: [ 3] c2 07 0c
col 8: [ 3] c2 02 0a
col 9: [ 1] 80
col 10: [ 2] c1 03
col 11: [ 2] c1 03
col 16: [ 2] c1 03
End dump data blocks tsn: 0 file#: 1 minblk 532 maxblk 532
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/21980353/viewspace-1771415/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/21980353/viewspace-1771415/