ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Internal of Redo4

Internal of Redo4

原创 Linux操作系统 作者:tompson1983 时间:2010-02-22 12:42:57 0 删除 编辑
Example of Redo:
CHANGE #3 TYP:0 CLS: 1 AFN:4 DBA:0x01000d44 OBJ:43810 SCN:0x0000.00299b74 SEQ:  1 OP:10.2
index redo (kdxlin):  insert leaf row                                  --insert index index leaf
KTB Redo
op: 0x01  ver: 0x01 
op: F  xid:  0x0007.011.0000023d    uba: 0x0080101c.00ba.15
REDO: SINGLE / -- / --
itl: 2, sno: 0, row size 14
insert key: (10):  02 c1 02 06 01 00 0d 3d 00 00
CHANGE #4 TYP:0 CLS:29 AFN:2 DBA:0x00800069 OBJ:4294967295 SCN:0x0000.00299b76 SEQ:  1 OP:5.4
ktucm redo: slt: 0x0011 sqn: 0x0000023d srt: 0 sta: 9 flg: 0x2
ktucf redo: uba: 0x0080101c.00ba.15 ext: 12 spc: 4868 fbi: 0
CHANGE #5 TYP:0 CLS:30 AFN:2 DBA:0x0080101c OBJ:4294967295 SCN:0x0000.00299b4d SEQ:  4 OP:5.1
ktudb redo: siz: 144 spc: 5116 flg: 0x0012 seq: 0x00ba rec: 0x14
            xid:  0x0007.011.0000023d 
ktubl redo: slt: 17 rci: 0 opc: 11.1 objn: 43809 objd: 43809 tsn: 4
Undo type:  Regular undo        Begin trans    Last buffer split:  No
Temp Object:  No
Tablespace Undo:  No
             0x00000000  prev ctl uba: 0x0080101c.00ba.0e
prev ctl max cmt scn:  0x0000.00299179  prev tx cmt scn:  0x0000.002991cd
txn start scn:  0x0000.00299b74  logon user: 38  prev brb: 8392728  prev bcl: 0 KDO undo record:
KTB Redo
op: 0x04  ver: 0x01 
op: L  itl: xid:  0x0002.003.000002ce uba: 0x00801137.0097.11
                      flg: C---    lkc:  0     scn: 0x0000.00299b67
KDO Op code: URP row dependencies Disabled
  xtype: XA flags: 0x00000000  bdba: 0x01000d3d  hdba: 0x01000d3b
itli: 1  ispac: 0  maxfr: 4858
tabn: 0 slot: 0(0x0) flag: 0x2c lock: 0 ckix: 0
ncol: 0 nnew: 0 size: -3
full row:
CHANGE #6 TYP:0 CLS:30 AFN:2 DBA:0x0080101c OBJ:4294967295 SCN:0x0000.00299b76 SEQ:  1 OP:5.1
ktudb redo: siz: 100 spc: 4970 flg: 0x0022 seq: 0x00ba rec: 0x15
            xid:  0x0007.011.0000023d 
ktubu redo: slt: 17 rci: 20 opc: 10.22 objn: 43810 objd: 43810 tsn: 4
Undo type:  Regular undo       Undo type:  Last buffer split:  No
Tablespace Undo:  No
             0x00000000
index undo for leaf key operations
KTB Redo
op: 0x04  ver: 0x01 
op: L  itl: xid:  0x0008.00a.000002b4 uba: 0x008011dc.00ac.07
                      flg: C---    lkc:  0     scn: 0x0000.00299b70
Dump kdilk : itl=2, kdxlkflg=0x1 sdc=0 indexid=0x1000d43 block=0x01000d44
(kdxlpu): purge leaf row
key :(10):  02 c1 02 06 01 00 0d 3d 00 00
 
REDO RECORD - Thread:1 RBA: 0x000080.00013c90.0010 LEN: 0x0070 VLD: 0x06
SCN: 0x0000.00299bc6 SUBSCN:  1 10/31/2009 14:52:01
CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:  0 OP:23.1
 Block Written - afn: 4 rdba: 0x01000d3d BFT:(1024,16780605) non-BFT:(4,3389)
                   scn: 0x0000.00299b76 seq: 0x02 flg:0x06
END OF REDO DUMP
----- Redo read statistics for thread 1 -----                       Redo 统计信息
Read rate (ASYNC): 40688Kb in 2.23s => 17.82 Mb/sec 
Total physical reads: 40960Kb
Longest record: 37Kb, moves: 0/127712 (0%)
Change moves: 51286/265334 (19%), moved: 9Mb
Longest LWN: 1024Kb, moves: 9/4754 (0%), moved: 3Mb
Last redo scn: 0x0000.00299d16 (2727190)
----------------------------------------------

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

上一篇: Internal of Redo3
下一篇: Internal of Rac ha
请登录后发表评论 登录
全部评论

注册时间:2009-06-15

  • 博文量
    52
  • 访问量
    85441