非IMU模式下一条update语句产生REDORECORD条数的探究
注意： 每个实验前最好做下日志切换，更详细方法dump redo 文件的方法及本篇DUMP的TRACE文件见下载附件：本篇TRACE等附件下载，或者另一篇博客 ：非IMU模式下DML语句产生的REDO日志内容式解读 实验1： BYS@ bys3select * from dept; DEPTNO DNAME LOC ------
注意：每个实验前最好做下日志切换，更详细方法dump redo 文件的方法及本篇DUMP的TRACE文件见下载附件：本篇TRACE等附件下载，或者另一篇博客 ：非IMU模式下DML语句产生的REDO日志内容格式解读
实验1：
BYS@ bys3>select * from dept;DEPTNO DNAME LOC
---------- -------------- -------------
10 database NEW YORK
20 database DALLAS
40 OPERATIONS BOSTON
11 database bj
22 test sh
update dept set dname='oracle' where deptno 4 rows updated.
这个更新语句会产生四条REDO RECORD，因为对四条记录改为oracle
#############################
实验2：
BYS@ bys3>select * from dept;DEPTNO DNAME LOC
---------- -------------- -------------
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
40 OPERATIONS BOSTON
11 database bj
22 test sh
BYS@ bys3>update dept set dname='database' where deptno 3 rows updated.
这个更新语句中，已经有一条是database，这次更新了三条语句，但是只有两条REDO RECORD，
有一个REDO RECORD的CHANGE #1不一样：这个REDO RECORD只有CHANGE #1，CHANGE #2，CHANGE #1中就把这两个值放入UNDO，详见后面日志。
##########################################
实验3：
BYS@ bys3>select * from dept;DEPTNO DNAME LOC
---------- -------------- -------------
10 oracle NEW YORK
20 oracle DALLAS
40 OPERATIONS BOSTON
11 oracle bj
22 oracle sh
BYS@ bys3>set time on
09:47:59 BYS@ bys3>update dept set dname='oracle' where deptno=10;
1 row updated.
将一行中oracle--UPDATE为oracle，一条REDO RECORD
####################
实验4：
10:08:32 BYS@ bys3>select * from dept;DEPTNO DNAME LOC
---------- -------------- -------------
10 oracle NEW YORK
20 oracle DALLAS
40 OPERATIONS BOSTON
11 oracle bj
22 oracle sh
10:08:57 BYS@ bys3>update dept set dname='oracle' where deptno 4 rows updated.
更新了四行，这四行原值oracle，更新为oracle，只有一条一条REDO RECORD
##################
附dump 每次操作的redo日志
实验1的：
REDO RECORD - Thread:1 RBA: 0x00013b.00000029.0010 LEN: 0x01e4 VLD: 0x05
SCN: 0x0000.00704cb2 SUBSCN: 1 01/06/2014 22:04:42
(LWN RBA: 0x00013b.00000029.0010 LEN: 0003 NST: 0001 SCN: 0x0000.00704cb1)
CHANGE #1 TYP:0 CLS:33 AFN:3 DBA:0x00c00100 OBJ:4294967295 SCN:0x0000.00704c81 SEQ:1 OP:5.2 ENC:0 RBL:0
ktudh redo: slt: 0x0015 sqn: 0x00000e9f flg: 0x0012 siz: 164 fbi: 0
uba: 0x00c02e0e.0247.2a pxid: 0x0000.000.00000000
CHANGE #2 TYP:0 CLS:34 AFN:3 DBA:0x00c02e0e OBJ:4294967295 SCN:0x0000.00704c80 SEQ:3 OP:5.1 ENC:0 RBL:0
ktudb redo: siz: 164 spc: 3160 flg: 0x0012 seq: 0x0247 rec: 0x2a
xid: 0x0009.015.00000e9f
ktubl redo: slt: 21 rci: 0 opc: 11.1 [objn: 22327 objd: 22327 tsn: 4]
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
0x00000000 prev ctl uba: 0x00c02e0e.0247.27
prev ctl max cmt scn: 0x0000.007049b5 prev tx cmt scn: 0x0000.007049e3
txn start scn: 0xffff.ffffffff logon user: 32 prev brb: 12591203 prev bcl: 0 BuExt idx: 0 flg2: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 1
op: L itl: xid: 0x0001.00f.00000e9c uba: 0x00c01cbf.0250.0f
flg: C--- lkc: 0 scn: 0x0000.00702fe2
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x010000fd hdba: 0x010000fa
itli: 1 ispac: 0 maxfr: 4858
tabn: 0 slot: 2(0x2) flag: 0x2c lock: 0 ckix: 0
ncol: 3 nnew: 1 size: 2
col 1: [ 8] 64 61 74 61 62 61 73 65
CHANGE #3 TYP:2 CLS:1 AFN:4 DBA:0x010000fd OBJ:22327 SCN:0x0000.00703bc4 SEQ:1 OP:11.5 ENC:0 RBL:0
KTB Redo
op: 0x11 ver: 0x01
compat bit: 4 (post-11) padding: 1
op: F xid: 0x0009.015.00000e9f uba: 0x00c02e0e.0247.2a
Block cleanout record, scn: 0x0000.00704cb2 ver: 0x01 opt: 0x02, entries follow...
itli: 2 flg: 2 scn: 0x0000.00703bc4
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x010000fd hdba: 0x010000fa
itli: 1 ispac: 0 maxfr: 4858
tabn: 0 slot: 2(0x2) flag: 0x2c lock: 1 ckix: 0
ncol: 3 nnew: 1 size: -2
col 1: [ 6] 6f 72 61 63 6c 65
##############################################################
REDO RECORD - Thread:1 RBA: 0x00013b.0000002a.0010 LEN: 0x0108 VLD: 0x01
SCN: 0x0000.00704cb2 SUBSCN: 1 01/06/2014 22:04:42
CHANGE #1 TYP:0 CLS:34 AFN:3 DBA:0x00c02e0e OBJ:4294967295 SCN:0x0000.00704cb2 SEQ:1 OP:5.1 ENC:0 RBL:0
ktudb redo: siz: 96 spc: 2994 flg: 0x0022 seq: 0x0247 rec: 0x2b
xid: 0x0009.015.00000e9f
ktubu redo: slt: 21 rci: 42 opc: 11.1 objn: 22327 objd: 22327 tsn: 4
Undo type: Regular undo Undo type: Last buffer split: No
Tablespace Undo: No
0x00000000
KDO undo record:
KTB Redo
op: 0x02 ver: 0x01
compat bit: 4 (post-11) padding: 1
op: C uba: 0x00c02e0e.0247.2a
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x010000fd hdba: 0x010000fa
itli: 1 ispac: 0 maxfr: 4858
tabn: 0 slot: 3(0x3) flag: 0x2c lock: 0 ckix: 0
ncol: 3 nnew: 1 size: 2
col 1: [ 8] 64 61 74 61 62 61 73 65
CHANGE #2 TYP:0 CLS:1 AFN:4 DBA:0x010000fd OBJ:22327 SCN:0x0000.00704cb2 SEQ:1 OP:11.5 ENC:0 RBL:0
KTB Redo
op: 0x02 ver: 0x01
compat bit: 4 (post-11) padding: 1
op: C uba: 0x00c02e0e.0247.2b
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x010000fd hdba: 0x010000fa
itli: 1 ispac: 0 maxfr: 4858
tabn: 0 slot: 3(0x3) flag: 0x2c lock: 1 ckix: 0
ncol: 3 nnew: 1 size: -2
col 1: [ 6] 6f 72 61 63 6c 65
###################################################
REDO RECORD - Thread:1 RBA: 0x00013b.0000002a.0118 LEN: 0x0108 VLD: 0x01
SCN: 0x0000.00704cb2 SUBSCN: 1 01/06/2014 22:04:42
CHANGE #1 TYP:0 CLS:34 AFN:3 DBA:0x00c02e0e OBJ:4294967295 SCN:0x0000.00704cb2 SEQ:2 OP:5.1 ENC:0 RBL:0
ktudb redo: siz: 96 spc: 2896 flg: 0x0022 seq: 0x0247 rec: 0x2c
xid: 0x0009.015.00000e9f
ktubu redo: slt: 21 rci: 43 opc: 11.1 objn: 22327 objd: 22327 tsn: 4
Undo type: Regular undo Undo type: Last buffer split: No
Tablespace Undo: No
0x00000000
KDO undo record:
KTB Redo
op: 0x02 ver: 0x01
compat bit: 4 (post-11) padding: 1
op: C uba: 0x00c02e0e.0247.2b
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x010000fd hdba: 0x010000fa
itli: 1 ispac: 0 maxfr: 4858
tabn: 0 slot: 5(0x5) flag: 0x2c lock: 0 ckix: 0
ncol: 3 nnew: 1 size: 2
col 1: [ 8] 64 61 74 61 62 61 73 65
CHANGE #2 TYP:0 CLS:1 AFN:4 DBA:0x010000fd OBJ:22327 SCN:0x0000.00704cb2 SEQ:2 OP:11.5 ENC:0 RBL:0
KTB Redo
op: 0x02 ver: 0x01
compat bit: 4 (post-11) padding: 1
op: C uba: 0x00c02e0e.0247.2c
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x010000fd hdba: 0x010000fa
itli: 1 ispac: 0 maxfr: 4858
tabn: 0 slot: 5(0x5) flag: 0x2c lock: 1 ckix: 0
ncol: 3 nnew: 1 size: -2
col 1: [ 6] 6f 72 61 63 6c 65
###################################################################
REDO RECORD - Thread:1 RBA: 0x00013b.0000002b.0030 LEN: 0x0104 VLD: 0x01
SCN: 0x0000.00704cb2 SUBSCN: 1 01/06/2014 22:04:42
CHANGE #1 TYP:0 CLS:34 AFN:3 DBA:0x00c02e0e OBJ:4294967295 SCN:0x0000.00704cb2 SEQ:3 OP:5.1 ENC:0 RBL:0
ktudb redo: siz: 92 spc: 2798 flg: 0x0022 seq: 0x0247 rec: 0x2d
xid: 0x0009.015.00000e9f
ktubu redo: slt: 21 rci: 44 opc: 11.1 objn: 22327 objd: 22327 tsn: 4
Undo type: Regular undo Undo type: Last buffer split: No
Tablespace Undo: No
0x00000000
KDO undo record:
KTB Redo
op: 0x02 ver: 0x01
compat bit: 4 (post-11) padding: 1
op: C uba: 0x00c02e0e.0247.2c
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x010000fd hdba: 0x010000fa
itli: 1 ispac: 0 maxfr: 4858
tabn: 0 slot: 6(0x6) flag: 0x2c lock: 0 ckix: 0
ncol: 3 nnew: 1 size: -2
col 1: [ 4] 74 65 73 74
CHANGE #2 TYP:0 CLS:1 AFN:4 DBA:0x010000fd OBJ:22327 SCN:0x0000.00704cb2 SEQ:3 OP:11.5 ENC:0 RBL:0
KTB Redo
op: 0x02 ver: 0x01
compat bit: 4 (post-11) padding: 1
op: C uba: 0x00c02e0e.0247.2d
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x010000fd hdba: 0x010000fa
itli: 1 ispac: 0 maxfr: 4858
tabn: 0 slot: 6(0x6) flag: 0x2c lock: 1 ckix: 0
ncol: 3 nnew: 1 size: 2
col 1: [ 6] 6f 72 61 63 6c 65
################################################提交的日志条目：
REDO RECORD - Thread:1 RBA: 0x00013b.0000002c.0010 LEN: 0x008c VLD: 0x05
SCN: 0x0000.00704cb4 SUBSCN: 1 01/06/2014 22:04:43
(LWN RBA: 0x00013b.0000002c.0010 LEN: 0001 NST: 0001 SCN: 0x0000.00704cb3)
CHANGE #1 TYP:0 CLS:33 AFN:3 DBA:0x00c00100 OBJ:4294967295 SCN:0x0000.00704cb2 SEQ:1 OP:5.4 ENC:0 RBL:0
ktucm redo: slt: 0x0015 sqn: 0x00000e9f srt: 0 sta: 9 flg: 0x2 ktucf redo: uba: 0x00c02e0e.0247.2d ext: 8 spc: 2704 fbi: 0
END OF REDO DUMP
实验2的：
REDO RECORD - Thread:1 RBA: 0x00013a.00000002.0010 LEN: 0x01c0 VLD: 0x05
SCN: 0x0000.00703bc1 SUBSCN: 1 01/06/2014 21:56:03
(LWN RBA: 0x00013a.00000002.0010 LEN: 0002 NST: 0001 SCN: 0x0000.00703bc0)
CHANGE #1 TYP:0 CLS:23 AFN:3 DBA:0x00c000b0 OBJ:4294967295 SCN:0x0000.00703b80 SEQ:1 OP:5.2 ENC:0 RBL:0
ktudh redo: slt: 0x0004 sqn: 0x00000ec7 flg: 0x0012 siz: 168 fbi: 0
uba: 0x00c01ddb.0283.21 pxid: 0x0000.000.00000000
CHANGE #2 TYP:0 CLS:24 AFN:3 DBA:0x00c01ddb OBJ:4294967295 SCN:0x0000.00703b7f SEQ:9 OP:5.1 ENC:0 RBL:0
ktudb redo: siz: 168 spc: 3658 flg: 0x0012 seq: 0x0283 rec: 0x21
xid: 0x0004.004.00000ec7
ktubl redo: slt: 4 rci: 0 opc: 11.1 [objn: 22327 objd: 22327 tsn: 4]
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
0x00000000 prev ctl uba: 0x00c01ddb.0283.01
prev ctl max cmt scn: 0x0000.007034c7 prev tx cmt scn: 0x0000.007034f1
txn start scn: 0xffff.ffffffff logon user: 32 prev brb: 12590550 prev bcl: 0 BuExt idx: 0 flg2: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 1
op: L itl: xid: 0x0003.013.00000eac uba: 0x00c01ac7.0250.06
flg: C--- lkc: 0 scn: 0x0000.00702d7a
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x010000fd hdba: 0x010000fa
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 2(0x2) flag: 0x2c lock: 0 ckix: 0
ncol: 3 nnew: 1 size: 2 ---ACCOUNTING 比database多两个字节
col 1: [10] 41 43 43 4f 55 4e 54 49 4e 47 ---对应的是将第一行第二列的值放进UNDO---ACCOUNTING
CHANGE #3 TYP:0 CLS:1 AFN:4 DBA:0x010000fd OBJ:22327 SCN:0x0000.00703bb3 SEQ:3 OP:11.5 ENC:0 RBL:0
KTB Redo
op: 0x01 ver: 0x01
compat bit: 4 (post-11) padding: 1
op: F xid: 0x0004.004.00000ec7 uba: 0x00c01ddb.0283.21
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x010000fd hdba: 0x010000fa
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 2(0x2) flag: 0x2c lock: 2 ckix: 0
ncol: 3 nnew: 1 size: -2
col 1: [ 8] 64 61 74 61 62 61 73 65
REDO RECORD - Thread:1 RBA: 0x00013a.00000002.01d0 LEN: 0x0190 VLD: 0x01 --这个REDO RECORD只有CHANGE #1，CHANGE
#2
SCN: 0x0000.00703bc1 SUBSCN: 1 01/06/2014 21:56:03
CHANGE #1 TYP:0 CLS:24 AFN:3 DBA:0x00c01ddb OBJ:4294967295 SCN:0x0000.00703bc1 SEQ:1 OP:5.1 ENC:0 RBL:0
ktudb redo: siz: 164 spc: 3488 flg: 0x0022 seq: 0x0283 rec: 0x22
xid: 0x0004.004.00000ec7
ktubu redo: slt: 4 rci: 33 opc: 11.1 objn: 22327 objd: 22327 tsn: 4
Undo type: Regular undo Undo type: Last buffer split: No
Tablespace Undo: No
0x00000000
KDO undo record:
KTB Redo
op: 0x02 ver: 0x01
compat bit: 4 (post-11) padding: 1
op: C uba: 0x00c01ddb.0283.21
Array Update of 2 rows:
tabn: 0 slot: 3(0x3) flag: 0x2c lock: 0 ckix: 0
ncol: 3 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x010000fd hdba: 0x010000fa
itli: 2 ispac: 0 maxfr: 4858
vect = 3
col 1: [ 8] 52 45 53 45 41 52 43 48 ---DUMP('RESEARCH',16)
tabn: 0 slot: 5(0x5) flag: 0x2c lock: 0 ckix: 0
ncol: 3 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x010000fd hdba: 0x010000fa
itli: 2 ispac: 0 maxfr: 4858
vect = 3
col 1: [ 8] 64 61 74 61 62 61 73 65 --DUMP('DATABASE',16)
CHANGE #2 TYP:0 CLS:1 AFN:4 DBA:0x010000fd OBJ:22327 SCN:0x0000.00703bc1 SEQ:1 OP:11.19 ENC:0 RBL:0
KTB Redo
op: 0x02 ver: 0x01
compat bit: 4 (post-11) padding: 1
op: C uba: 0x00c01ddb.0283.22
Array Update of 2 rows:
tabn: 0 slot: 3(0x3) flag: 0x2c lock: 2 ckix: 0
ncol: 3 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x010000fd hdba: 0x010000fa
itli: 2 ispac: 0 maxfr: 4858
vect = 3
col 1: [ 8] 64 61 74 61 62 61 73 65
tabn: 0 slot: 5(0x5) flag: 0x2c lock: 2 ckix: 0
ncol: 3 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x010000fd hdba: 0x010000fa
itli: 2 ispac: 0 maxfr: 4858
vect = 3
col 1: [ 8] 64 61 74 61 62 61 73 65
REDO RECORD - Thread:1 RBA: 0x00013a.00000004.0010 LEN: 0x008c VLD: 0x05 --这个是提交语句的。
SCN: 0x0000.00703bc4 SUBSCN: 1 01/06/2014 21:56:07
(LWN RBA: 0x00013a.00000004.0010 LEN: 0001 NST: 0001 SCN: 0x0000.00703bc3)
CHANGE #1 TYP:0 CLS:23 AFN:3 DBA:0x00c000b0 OBJ:4294967295 SCN:0x0000.00703bc1 SEQ:1 OP:5.4 ENC:0 RBL:0
ktucm redo: slt: 0x0004 sqn: 0x00000ec7 srt: 0 sta: 9 flg: 0x2 ktucf redo: uba: 0x00c01ddb.0283.22 ext: 16 spc: 3322 fbi: 0
实验3的日志：
REDO RECORD - Thread:1 RBA: 0x00013d.00000002.0010 LEN: 0x0214 VLD: 0x05
SCN: 0x0000.0070cae5 SUBSCN: 1 01/07/2014 09:48:10
(LWN RBA: 0x00013d.00000002.0010 LEN: 0002 NST: 0001 SCN: 0x0000.0070cae4)
CHANGE #1 TYP:0 CLS:23 AFN:3 DBA:0x00c000b0 OBJ:4294967295 SCN:0x0000.0070caaa SEQ:1 OP:5.2 ENC:0 RBL:0
ktudh redo: slt: 0x000d sqn: 0x00000ee5 flg: 0x0012 siz: 188 fbi: 0
uba: 0x00c040fa.0286.12 pxid: 0x0000.000.00000000
CHANGE #2 TYP:0 CLS:24 AFN:3 DBA:0x00c040fa OBJ:4294967295 SCN:0x0000.0070caa9 SEQ:3 OP:5.1 ENC:0 RBL:0
ktudb redo: siz: 188 spc: 5884 flg: 0x0012 seq: 0x0286 rec: 0x12
xid: 0x0004.00d.00000ee5
ktubl redo: slt: 13 rci: 0 opc: 11.1 [objn: 22327 objd: 22327 tsn: 4]
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
0x00000000 prev ctl uba: 0x00c040fa.0286.0f
prev ctl max cmt scn: 0x0000.0070c50b prev tx cmt scn: 0x0000.0070c522
txn start scn: 0xffff.ffffffff logon user: 32 prev brb: 12599542 prev bcl: 0 BuExt idx: 0 flg2: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 1
op: L itl: xid: 0x0004.004.00000ec7 uba: 0x00c01ddb.0283.22
flg: C--- lkc: 0 scn: 0x0000.00703bc4
Array Update of 1 rows:
tabn: 0 slot: 2(0x2) flag: 0x2c lock: 0 ckix: 0
ncol: 3 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x010000fd hdba: 0x010000fa
itli: 2 ispac: 0 maxfr: 4858
vect = 3
col 1: [ 6] 6f 72 61 63 6c 65
CHANGE #3 TYP:2 CLS:1 AFN:4 DBA:0x010000fd OBJ:22327 SCN:0x0000.00704cb4 SEQ:1 OP:11.19 ENC:0 RBL:0
KTB Redo
op: 0x11 ver: 0x01
compat bit: 4 (post-11) padding: 1
op: F xid: 0x0004.00d.00000ee5 uba: 0x00c040fa.0286.12
Block cleanout record, scn: 0x0000.0070cae5 ver: 0x01 opt: 0x02, entries follow...
itli: 1 flg: 2 scn: 0x0000.00704cb4
Array Update of 1 rows:
tabn: 0 slot: 2(0x2) flag: 0x2c lock: 2 ckix: 0
ncol: 3 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x010000fd hdba: 0x010000fa
itli: 2 ispac: 0 maxfr: 4858
vect = 3
col 1: [ 6] 6f 72 61 63 6c 65
REDO RECORD - Thread:1 RBA: 0x00013d.00000004.0010 LEN: 0x008c VLD: 0x05
SCN: 0x0000.0070cae7 SUBSCN: 1 01/07/2014 09:48:11
(LWN RBA: 0x00013d.00000004.0010 LEN: 0001 NST: 0001 SCN: 0x0000.0070cae6)
CHANGE #1 TYP:0 CLS:23 AFN:3 DBA:0x00c000b0 OBJ:4294967295 SCN:0x0000.0070cae5 SEQ:1 OP:5.4 ENC:0 RBL:0
ktucm redo: slt: 0x000d sqn: 0x00000ee5 srt: 0 sta: 9 flg: 0x2 ktucf redo: uba: 0x00c040fa.0286.12 ext: 19 spc: 5694 fbi: 0
实验4的：
REDO RECORD - Thread:1 RBA: 0x00013f.000000de.0010 LEN: 0x0304 VLD: 0x05
SCN: 0x0000.0070cfe9 SUBSCN: 1 01/07/2014 10:09:20
(LWN RBA: 0x00013f.000000de.0010 LEN: 0002 NST: 0001 SCN: 0x0000.0070cfe8)
CHANGE #1 TYP:0 CLS:33 AFN:3 DBA:0x00c00100 OBJ:4294967295 SCN:0x0000.0070cfbf SEQ:1 OP:5.2 ENC:0 RBL:0
ktudh redo: slt: 0x0004 sqn: 0x00000ebc flg: 0x0012 siz: 308 fbi: 0
uba: 0x00c037d5.0249.08 pxid: 0x0000.000.00000000
CHANGE #2 TYP:0 CLS:34 AFN:3 DBA:0x00c037d5 OBJ:4294967295 SCN:0x0000.0070cfbe SEQ:3 OP:5.1 ENC:0 RBL:0
ktudb redo: siz: 308 spc: 7252 flg: 0x0012 seq: 0x0249 rec: 0x08
xid: 0x0009.004.00000ebc
ktubl redo: slt: 4 rci: 0 opc: 11.1 [objn: 22327 objd: 22327 tsn: 4]
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
0x00000000 prev ctl uba: 0x00c037d5.0249.05
prev ctl max cmt scn: 0x0000.0070cc57 prev tx cmt scn: 0x0000.0070cc81
txn start scn: 0xffff.ffffffff logon user: 32 prev brb: 12597202 prev bcl: 0 BuExt idx: 0 flg2: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 1
op: L itl: xid: 0x0004.00d.00000ee5 uba: 0x00c040fa.0286.12
flg: C--- lkc: 0 scn: 0x0000.0070cae7
Array Update of 4 rows:
tabn: 0 slot: 2(0x2) flag: 0x2c lock: 0 ckix: 0
ncol: 3 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x010000fd hdba: 0x010000fa
itli: 2 ispac: 0 maxfr: 4858
vect = 3
col 1: [ 6] 6f 72 61 63 6c 65
tabn: 0 slot: 3(0x3) flag: 0x2c lock: 0 ckix: 0
ncol: 3 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x010000fd hdba: 0x010000fa
itli: 2 ispac: 0 maxfr: 4858
vect = 3
col 1: [ 6] 6f 72 61 63 6c 65
tabn: 0 slot: 5(0x5) flag: 0x2c lock: 0 ckix: 0
ncol: 3 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x010000fd hdba: 0x010000fa
itli: 2 ispac: 0 maxfr: 4858
vect = 3
col 1: [ 6] 6f 72 61 63 6c 65
tabn: 0 slot: 6(0x6) flag: 0x2c lock: 0 ckix: 0
ncol: 3 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x010000fd hdba: 0x010000fa
itli: 2 ispac: 0 maxfr: 4858
vect = 3
col 1: [ 6] 6f 72 61 63 6c 65
CHANGE #3 TYP:2 CLS:1 AFN:4 DBA:0x010000fd OBJ:22327 SCN:0x0000.0070cb7f SEQ:1 OP:11.19 ENC:0 RBL:0
KTB Redo
op: 0x11 ver: 0x01
compat bit: 4 (post-11) padding: 1
op: F xid: 0x0009.004.00000ebc uba: 0x00c037d5.0249.08
Block cleanout record, scn: 0x0000.0070cfe9 ver: 0x01 opt: 0x02, entries follow...
itli: 1 flg: 2 scn: 0x0000.0070cb7f
Array Update of 4 rows:
tabn: 0 slot: 2(0x2) flag: 0x2c lock: 2 ckix: 0
ncol: 3 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x010000fd hdba: 0x010000fa
itli: 2 ispac: 0 maxfr: 4858
vect = 3
col 1: [ 6] 6f 72 61 63 6c 65
tabn: 0 slot: 3(0x3) flag: 0x2c lock: 2 ckix: 0
ncol: 3 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x010000fd hdba: 0x010000fa
itli: 2 ispac: 0 maxfr: 4858
vect = 3
col 1: [ 6] 6f 72 61 63 6c 65
tabn: 0 slot: 5(0x5) flag: 0x2c lock: 2 ckix: 0
ncol: 3 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x010000fd hdba: 0x010000fa
itli: 2 ispac: 0 maxfr: 4858
vect = 3
col 1: [ 6] 6f 72 61 63 6c 65
tabn: 0 slot: 6(0x6) flag: 0x2c lock: 2 ckix: 0
ncol: 3 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x010000fd hdba: 0x010000fa
itli: 2 ispac: 0 maxfr: 4858
vect = 3
col 1: [ 6] 6f 72 61 63 6c 65
REDO RECORD - Thread:1 RBA: 0x00013f.000000df.0124 LEN: 0x0060 VLD: 0x01
SCN: 0x0000.0070cfea SUBSCN: 1 01/07/2014 10:09:20
CHANGE #1 TYP:0 CLS:33 AFN:3 DBA:0x00c00100 OBJ:4294967295 SCN:0x0000.0070cfe9 SEQ:1 OP:5.4 ENC:0 RBL:0
ktucm redo: slt: 0x0004 sqn: 0x00000ebc srt: 0 sta: 9 flg: 0x2 ktucf redo: uba: 0x00c037d5.0249.08 ext: 10 spc: 6942 fbi: 0
热AI工具
Undresser.AI Undress
人工智能驱动的应用程序，用于创建逼真的裸体照片
AI Clothes Remover
用于从照片中去除衣服的在线人工智能工具。
Undress AI Tool
免费脱衣服图片
Clothoff.io
AI脱衣机
Video Face Swap
使用我们完全免费的人工智能换脸工具轻松在任何视频中换脸！
热门文章
热工具
记事本++7.3.1
好用且免费的代码编辑器
SublimeText3汉化版
中文版，非常好用
禅工作室 13.0.1
功能强大的PHP集成开发环境
Dreamweaver CS6
视觉化网页开发工具
SublimeText3 Mac版
神级代码编辑软件(SublimeText3)
热门话题
微信的免打扰模式有什么作用
Feb 23, 2024 pm 10:48 PM
微信勿扰模式什么意思如今，随着智能手机的普及和移动互联网的迅猛发展，社交媒体平台已经成为人们日常生活中不可或缺的一部分。而微信作为国内最流行的社交媒体平台之一，几乎每个人都有一个微信账号。我们可以通过微信与朋友、家人、同事进行实时沟通，分享生活中的点滴，了解彼此的近况。然而，在这个时代，我们也不可避免地面临着信息过载和隐私泄露的问题，特别是对于那些需要专注或
iPhone上的睡眠模式有何用途？
Nov 04, 2023 am 11:13 AM
长期以来，iOS设备一直能够使用“健康”应用程序跟踪您的睡眠模式等。但是，当您在睡觉时被通知打扰时，这不是很烦人吗？这些通知可能无关紧要，因此在此过程中会扰乱您的睡眠模式。虽然免打扰模式是避免睡觉时分心的好方法，但它可能会导致您错过夜间收到的重要电话和消息。值得庆幸的是，这就是睡眠模式的用武之地。让我们了解更多关于它以及如何在iPhone上使用它的信息。睡眠模式在iPhone上有什么作用睡眠模式是iOS中专用的专注模式，会根据你在“健康”App中的睡眠定时自动激活。它可以帮助您设置闹钟，然后可以
如何启用/禁用 VS Code 自动更新
Apr 28, 2023 am 09:28 AM
如果您正在使用VisualStudioCode(VSCode)并考虑如何禁用它的自动软件更新以及如何禁用其扩展的自动更新，那么请阅读本文。如果你不经常使用VSCode，隔了很长一段时间打开编辑器并想启用自动更新，本文也将指导你这样做。让我们详细讨论启用或禁用VSCode自动更新的不同方法。目录方法一：使用设置启用/禁用VSCode自动更新第一步：打开VS代码，在左下角点击齿轮状的符号。第2步：在出现的列表中单击设置。第3步：在搜索栏中输入更新并回车。查找更新：模式第4
请勿打扰模式在iPhone中不起作用：修复
Apr 24, 2024 pm 04:50 PM
即使在“请勿打扰”模式下接听电话也可能是一种非常烦人的体验。顾名思义，请勿打扰模式可关闭来自邮件、消息等的所有来电通知和警报。您可以按照这些解决方案集进行修复。修复1–启用对焦模式在手机上启用对焦模式。步骤1–从顶部向下滑动以访问控制中心。步骤2–接下来，在手机上启用“对焦模式”。专注模式可在手机上启用“请勿打扰”模式。它不会让您的手机上出现任何来电提醒。修复2–更改对焦模式设置如果对焦模式设置中存在一些问题，则应进行修复。步骤1–打开您的iPhone设置窗口。步骤2–接下来，打开“对焦”模式设
iPhone 15 Pro：如何摆脱状态栏中的静音模式符号
Sep 24, 2023 pm 10:01 PM
在iPhone15Pro和iPhone15ProMax型号上，Apple推出了一个物理可编程的动作按钮，取代了音量按钮上方的传统响铃/静音开关。可以对操作按钮进行编程以执行几种不同的功能，但是在静音和响铃模式之间切换的能力并没有消失。默认情况下，长按一次操作按钮将使设备静音，按钮的触觉反馈将发出三个脉冲。两款iPhone15Pro机型在状态栏中的时间旁边都会显示一个划掉的铃铛符号，表示静音/静音模式已激活，并且它将一直保持到您再次长按“操作”按钮取消设备静音。如果您倾向于将iPhone置于静音模
KDE Plasma 6.1 为流行的 Linux 桌面带来了许多增强功能
Jun 23, 2024 am 07:54 AM
经过多次预发布后，KDE Plasma 开发团队于 2 月 28 日推出了适用于 Linux 和 BSD 系统的 6.0 版桌面环境，首次使用 Qt6 框架。 KDE Plasma 6.1 现在附带了许多新功能
在 Windows 10/11 上如何离开 S 模式
Aug 03, 2023 pm 08:17 PM
S模式下的窗口旨在通过仅允许从Microsoft应用商店安装应用来提供增强的安全性和性能。虽然此功能有助于防止恶意软件和确保安全的计算环境，但它可能会限制想要从MicrosoftStore以外的源安装应用程序的用户。如果您发现自己处于这种情况并不断问自己如何在Windows10/11中切换出S模式，那么您来对地方了，因为我们将引导您完成如何使用两种不同的方法在Windows10/11中切换出S模式的步骤，确保您可以享受从您选择的任何地方安装应用程序的自由。了解如何在Windows中切换出S模式将
如何启用'记事本++深色模式”和'记事本++深色主题”？
Oct 27, 2023 pm 11:17 PM
记事本++暗模式v8.0没有参数，Notepad++是最有用的文本编辑器。在Windows10上运行的每个应用程序都支持暗模式。您可以命名Web浏览器，例如Chrome、Firefox和MicrosoftEdge。如果您在记事本++上工作，默认的白色背景可能会伤害您的眼睛。开发人员已将暗模式添加到版本8的Notepad++中，这是打开它的方法。为Windows11/10启用记事本++暗模式启动记事本++单击“设置”>“首选项”>“暗模式”选择“启用深色模式”重新启动记
