|
ndo header
TRN TBL::
index state cflags wrap# uel scn dba parent-xid nub stmt_num
------------------------------------------------------------------------------------------------
0x00 9 0x00 0x0026 0x0060 0x0000.00acf596 0x00c00175 0x0000.000.00000000 0x00000001 0x0000000
0x36 9 0x80 0x0026 0x0034 0x0000.00acf5fe 0x00c00179 0x0000.000.00000000 0x00000001 0x00000000
0x37 9 0x80 0x0026 0x003e 0x0000.00acf61e 0x00c0017d 0x0000.000.00000000 0x00000002 0x00000000
0x38 9 0x80 0x0026 0x0035 0x0000.00acf60c 0x00c0017b 0x0000.000.00000000 0x00000002 0x00000000
0x39 9 0x80 0x0026 0x0033 0x0000.00acf604 0x00c0017a 0x0000.000.00000000 0x00000001 0x00000000
0x3a 9 0x80 0x0026 0x0037 0x0000.00acf610 0x00c0017c 0x0000.000.00000000 0x00000001 0x00000000
0x3b 9 0x80 0x0026 0x003a 0x0000.00acf60f 0x00c0017c 0x0000.000.00000000 0x00000002 0x00000000
0x3c 9 0x80 0x0022 0xffff 0x0000.00acf666 0x00c00122 0x0000.000.00000000 0x00000001 0x00000000
查看undo前镜像：
*-----------------------------
* Rec #0x16 slt: 0x3c objn: 73888(0x000120a0) objd: 73888 tblspc: 5(0x00000005)
* 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: 0x00c00122.016e.13 ctl max scn: 0x0000.00acf0a4 prv tx scn: 0x0000.00acf0a6
txn start scn: scn: 0x0000.00acf251 logon user: 0
prev brb: 12583237 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 1
op: L itl: xid: 0x000d.016.000000d8 uba: 0x020000ed.02b6.08
flg: C--- lkc: 0 scn: 0x0000.00aa0d31
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x01400087 hdba: 0x01400082
itli: 1 ispac: 0 maxfr: 4858
tabn: 0 slot: 1(0x1) flag: 0x2c lock: 0 ckix: 0
ncol: 3 nnew: 1 size: 0
col 0: [ 2] c1 03
查看数据块信息：
Itl Xid Uba Flag Lck Scn/Fsc
0x01 0x0015.03c.00000022 0x00c00122.016e.16 ---- 1 fsc 0x0000.00000000
0x02 0x000b.016.000000df 0x02006448.04fb.07 C--- 0 scn 0x0000.00ab118a
bdba: 0x01400087
data_block_dump,data header at 0x7ff873eada64
|