oracle 下bdump占用大,bdump下产生很大的trc文件

REDO: SINGLE / NONKEY / --

itl: 2, sno: 186, row size 17

insert key: (44):

10 89 91 21 d4 7d 1b b0 ba 8a b5 c4 30 85 6b 41 db 10 a2 5d 43 e4 e4 7a 1b

3d 84 11 30 43 ff b6 ed c0 01 20 07 78 6f 03 0b 17 16 1f

nonkey (length: 5):

fb: --H-FL-- lb: 0x0  cc: 1

(2):  01 80

prefix exists on block, sno: 0  len: 36CHANGE #7 TYP:0 CLS: 1 AFN:3 DBA:0x00c05a3f OBJ:49874 SCN:0x0000.055b393b SEQ:  1 OP:10.35

index redo (kdxlcnu): update nonkey, count=5

KTB Redo

op: 0x02  ver: 0x01

op: C  uba: 0x04003245.001a.35

REDO: SINGLE / NONKEY / --

itl: 2, sno: 21, row size 19

ncol: 2  nnew: 2 size: 0 flag: 0x02

nonkey columns updated:

col  0: [ 7]  78 6f 03 0b 17 16 1f

col  1: [ 1]  80

CHANGE #8 TYP:2 CLS: 1 AFN:3 DBA:0x00c0722f OBJ:49871 SCN:0x0000.055b3886 SEQ:  2 OP:10.2

index redo (kdxlin):  insert leaf row

KTB Redo

op: 0x01  ver: 0x01

op: F  xid:  0x0016.007.00000075    uba: 0x04003245.001a.36

REDO: SINGLE / NONKEY / --

itl: 2, sno: 196, row size 19

insert key: (44):

10 89 91 21 d4 7d 1b b0 ba 8a b5 c4 30 85 6b 41 db 10 0a 7a 39 48 70 a7 18

91 79 aa d0 3a 67 64 e4 de 01 20 07 78 6f 03 0b 17 16 1f

nonkey (length: 7):

fb: --H-FL-- lb: 0x0  cc: 1

(4):  03 3f 47 66

prefix exists on block, sno: 2  len: 36CHANGE #9 TYP:0 CLS: 1 AFN:3 DBA:0x00c05a3d OBJ:49874 SCN:0x0000.055b393a SEQ:  1 OP:10.35

index redo (kdxlcnu): update nonkey, count=5

KTB Redo

op: 0x01  ver: 0x01

op: F  xid:  0x0016.007.00000075    uba: 0x04003245.001a.37

REDO: SINGLE / NONKEY / --

itl: 3, sno: 39, row size 21

ncol: 2  nnew: 2 size: 0 flag: 0x02

nonkey columns updated:

col  0: [ 7]  78 6f 03 0b 17 16 1f

col  1: [ 3]  3f 47 66

CHANGE #10 TYP:2 CLS: 1 AFN:3 DBA:0x00c059fc OBJ:49864 SCN:0x0000.055b392f SEQ:  3 OP:11.4

KTB Redo

op: 0x11  ver: 0x01

op: F  xid:  0x0016.007.00000075    uba: 0x04003245.001a.38

Block cleanout record, scn:  0x0000.055b393a ver: 0x01 opt: 0x02, entries follow...

itli: 1  flg: 2  scn: 0x0000.055b392f

KDO Op code: LKR row dependencies Disabled

xtype: XA flags: 0x00000000  bdba: 0x00c059fc  hdba: 0x00c059fb

itli: 2  ispac: 0  maxfr: 4858

tabn: 0 slot: 2 to: 2

CHANGE #11 TYP:0 CLS: 1 AFN:3 DBA:0x00c059fc OBJ:49864 SCN:0x0000.055b393b SEQ:  1 OP:11.5

KTB Redo

op: 0x02  ver: 0x01

op: C  uba: 0x04003245.001a.39

KDO Op code: URP row dependencies Disabled

xtype: XA flags: 0x00000000  bdba: 0x00c059fc  hdba: 0x00c059fb

itli: 2  ispac: 0  maxfr: 4858

tabn: 0 slot: 2(0x2) flag: 0x2c lock: 2 ckix: 0

ncol: 25 nnew: 8 size: 0

col  3: [ 5]  31 30 67 52 32

col  4: [ 1]  32

col  5: [ 2]  44 42

col  6: [ 1]  20

col  7: [ 1]  20

col 17: [ 7]  78 6f 03 0b 17 16 1f

col 22: [ 7]  78 6f 03 0b 17 18 2e

col 23: [ 1]  80

CHANGE #12 TYP:0 CLS:59 AFN:16 DBA:0x04000089 OBJ:4294967295 SCN:0x0000.055b393b SEQ:  1 OP:5.4

ktucm redo: slt: 0x0007 sqn: 0x00000075 srt: 0 sta: 9 flg: 0x2

ktucf redo: uba: 0x04003245.001a.39 ext: 26 spc: 616 fbi: 0

CHANGE #13 TYP:0 CLS:60 AFN:16 DBA:0x04003245 OBJ:4294967295 SCN:0x0000.055b392f SEQ: 20 OP:5.1

ktudb redo: siz: 176 spc: 2024 flg: 0x0012 seq: 0x001a rec: 0x30

xid:  0x0016.007.00000075

ktubl redo: slt: 7 rci: 0 opc: 10.22 objn: 49871 objd: 49871 tsn: 2

Undo type:  Regular undo        Begin trans    Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

0x00000000  prev ctl uba: 0x04003245.001a.1c

prev ctl max cmt scn:  0x0000.055b3623  prev tx cmt scn:  0x0000.055b3629

txn start scn:  0x0000.055b393a  logon user: 51  prev brb: 67121731  prev bcl: 0 index undo for leaf key operations

KTB Redo

op: 0x04  ver: 0x01

op: L  itl: xid:  0x0016.007.00000074 uba: 0x04003243.001a.0b

flg: C---    lkc:  0     scn: 0x0000.055b3629

Dump kdilk : itl=2, kdxlkflg=0x41 sdc=0 indexid=0xc05a2b block=0x00c079ed

(kdxlpu): purge leaf row

key

44):

10 89 91 21 d4 7d 1b b0 ba 8a b5 c4 30 85 6b 41 db 10 81 a0 b7 36 fb 77 7c

5e be 5f 6f 38 47 37 87 2e 01 20 07 78 6f 03 0b 17 16 1f

CHANGE #14 TYP:0 CLS:60 AFN:16 DBA:0x04003245 OBJ:4294967295 SCN:0x0000.055b393b SEQ:  1 OP:5.1

ktudb redo: siz: 152 spc: 1846 flg: 0x0022 seq: 0x001a rec: 0x31

xid:  0x0016.007.00000075

ktubu redo: slt: 7 rci: 48 opc: 10.22 objn: 49874 objd: 49874 tsn: 2

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:  0x0016.01a.00000074 uba: 0x04003245.001a.2c

flg: C---    lkc:  0     scn: 0x0000.055b392f

Dump kdilk : itl=2, kdxlkflg=0x51 sdc=2 indexid=0xc05a3b block=0x00c05a3f

(kdxlcnu): column-vector nonkey update

ncol: 2 nnew: 2 size: 0 flag: 0x02

key

36):

10 89 91 21 d4 7d 1b b0 ba 8a b5 c4 30 85 6b 41 db 10 81 a0 b7 36 fb 77 7c

5e be 5f 6f 38 47 37 87 2e 01 20

nonkey columns updated:

col  0: [ 7]  78 6f 03 0b 17 11 1f

col  1: [ 3]  3f 47 66

CHANGE #15 TYP:0 CLS:60 AFN:16 DBA:0x04003245 OBJ:4294967295 SCN:0x0000.055b393b SEQ:  2 OP:5.1

ktudb redo: siz: 128 spc: 1692 flg: 0x0022 seq: 0x001a rec: 0x32

xid:  0x0016.007.00000075

ktubu redo: slt: 7 rci: 49 opc: 10.22 objn: 49871 objd: 49871 tsn: 2

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:  0x0016.007.00000074 uba: 0x04003243.001a.0d

flg: C---    lkc:  0     scn: 0x0000.055b3629

Dump kdilk : itl=3, kdxlkflg=0x41 sdc=0 indexid=0xc05a2b block=0x00c078f0

(kdxlpu): purge leaf row

key

44):

10 89 91 21 d4 7d 1b b0 ba 8a b5 c4 30 85 6b 41 db 10 f1 e9 5e 0d 83 3e 1d

9c 67 c1 ae 14 c1 b2 86 8b 01 20 07 78 6f 03 0b 17 16 1f

CHANGE #16 TYP:0 CLS:60 AFN:16 DBA:0x04003245 OBJ:4294967295 SCN:0x0000.055b393b SEQ:  3 OP:5.1

ktudb redo: siz: 152 spc: 1562 flg: 0x0022 seq: 0x001a rec: 0x33

xid:  0x0016.007.00000075

ktubu redo: slt: 7 rci: 50 opc: 10.22 objn: 49874 objd: 49874 tsn: 2

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:  0x0016.01a.00000074 uba: 0x04003245.001a.25

flg: C---    lkc:  0     scn: 0x0000.055b392f

Dump kdilk : itl=2, kdxlkflg=0x51 sdc=2 indexid=0xc05a3b block=0x00c08822

(kdxlcnu): column-vector nonkey update

ncol: 2 nnew: 2 size: 0 flag: 0x02

key

36):

10 89 91 21 d4 7d 1b b0 ba 8a b5 c4 30 85 6b 41 db 10 f1 e9 5e 0d 83 3e 1d

9c 67 c1 ae 14 c1 b2 86 8b 01 20

nonkey columns updated:

col  0: [ 7]  78 6f 03 0b 17 11 1f

col  1: [ 1]  80

CHANGE #17 TYP:0 CLS:60 AFN:16 DBA:0x04003245 OBJ:4294967295 SCN:0x0000.055b393b SEQ:  4 OP:5.1

ktudb redo: siz: 128 spc: 1408 flg: 0x0022 seq: 0x001a rec: 0x34

xid:  0x0016.007.00000075

ktubu redo: slt: 7 rci: 51 opc: 10.22 objn: 49871 objd: 49871 tsn: 2

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:  0x0016.007.00000074 uba: 0x04003243.001a.0f

flg: C---    lkc:  0     scn: 0x0000.055b3629

Dump kdilk : itl=2, kdxlkflg=0x41 sdc=0 indexid=0xc05a2b block=0x00c0777f

(kdxlpu): purge leaf row

key

44):

10 89 91 21 d4 7d 1b b0 ba 8a b5 c4 30 85 6b 41 db 10 a2 5d 43 e4 e4 7a 1b

3d 84 11 30 43 ff b6 ed c0 01 20 07 78 6f 03 0b 17 16 1f

CHANGE #18 TYP:0 CLS:60 AFN:16 DBA:0x04003245 OBJ:4294967295 SCN:0x0000.055b393b SEQ:  5 OP:5.1

ktudb redo: siz: 136 spc: 1278 flg: 0x0022 seq: 0x001a rec: 0x35

xid:  0x0016.007.00000075

ktubu redo: slt: 7 rci: 52 opc: 10.22 objn: 49874 objd: 49874 tsn: 2

Undo type:  Regular undo       Undo type:  Last buffer split:  No

Tablespace Undo:  No

0x00000000

index undo for leaf key operations

KTB Redo

op: 0x02  ver: 0x01

op: C  uba: 0x04003245.001a.31

Dump kdilk : itl=2, kdxlkflg=0x51 sdc=2 indexid=0xc05a3b block=0x00c05a3f

(kdxlcnu): column-vector nonkey update

ncol: 2 nnew: 2 size: 0 flag: 0x02

key

36):

10 89 91 21 d4 7d 1b b0 ba 8a b5 c4 30 85 6b 41 db 10 a2 5d 43 e4 e4 7a 1b

3d 84 11 30 43 ff b6 ed c0 01 20

nonkey columns updated:

col  0: [ 7]  78 6f 03 0b 17 11 1f

col  1: [ 1]  80

CHANGE #19 TYP:0 CLS:60 AFN:16 DBA:0x04003245 OBJ:4294967295 SCN:0x0000.055b393b SEQ:  6 OP:5.1

ktudb redo: siz: 128 spc: 1140 flg: 0x0022 seq: 0x001a rec: 0x36

xid:  0x0016.007.00000075

ktubu redo: slt: 7 rci: 53 opc: 10.22 objn: 49871 objd: 49871 tsn: 2

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:  0x0016.007.00000074 uba: 0x04003243.001a.11

flg: C---    lkc:  0     scn: 0x0000.055b3629

Dump kdilk : itl=2, kdxlkflg=0x41 sdc=0 indexid=0xc05a2b block=0x00c0722f

(kdxlpu): purge leaf row

key

44):

10 89 91 21 d4 7d 1b b0 ba 8a b5 c4 30 85 6b 41 db 10 0a 7a 39 48 70 a7 18

91 79 aa d0 3a 67 64 e4 de 01 20 07 78 6f 03 0b 17 16 1f

CHANGE #20 TYP:0 CLS:60 AFN:16 DBA:0x04003245 OBJ:4294967295 SCN:0x0000.055b393b SEQ:  7 OP:5.1

ktudb redo: siz: 152 spc: 1010 flg: 0x0022 seq: 0x001a rec: 0x37

xid:  0x0016.007.00000075

ktubu redo: slt: 7 rci: 54 opc: 10.22 objn: 49874 objd: 49874 tsn: 2

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:  0x000f.019.00000076 uba: 0x04003534.001b.35

flg: C---    lkc:  0     scn: 0x0000.055b392b

Dump kdilk : itl=3, kdxlkflg=0x51 sdc=3 indexid=0xc05a3b block=0x00c05a3d

(kdxlcnu): column-vector nonkey update

ncol: 2 nnew: 2 size: 0 flag: 0x02

key

36):

10 89 91 21 d4 7d 1b b0 ba 8a b5 c4 30 85 6b 41 db 10 0a 7a 39 48 70 a7 18

91 79 aa d0 3a 67 64 e4 de 01 20

nonkey columns updated:

col  0: [ 7]  78 6f 03 0b 17 11 1f

col  1: [ 3]  3f 47 66

CHANGE #21 TYP:0 CLS:60 AFN:16 DBA:0x04003245 OBJ:4294967295 SCN:0x0000.055b393b SEQ:  8 OP:5.1

ktudb redo: siz: 80 spc: 856 flg: 0x0022 seq: 0x001a rec: 0x38

xid:  0x0016.007.00000075

ktubu redo: slt: 7 rci: 55 opc: 11.1 objn: 49864 objd: 49864 tsn: 2

Undo type:  Regular undo       Undo type:  Last buffer split:  No

Tablespace Undo:  No

0x00000000

KDO undo record:

KTB Redo

op: 0x04  ver: 0x01

op: L  itl: xid:  0x000f.019.00000076 uba: 0x04003535.001b.01

flg: C---    lkc:  0     scn: 0x0000.055b392b

KDO Op code: LKR row dependencies Disabled

xtype: XA flags: 0x00000000  bdba: 0x00c059fc  hdba: 0x00c059fb

itli: 2  ispac: 0  maxfr: 4858

tabn: 0 slot: 2 to: 0

CHANGE #22 TYP:0 CLS:60 AFN:16 DBA:0x04003245 OBJ:4294967295 SCN:0x0000.055b393b SEQ:  9 OP:5.1

ktudb redo: siz: 156 spc: 774 flg: 0x0022 seq: 0x001a rec: 0x39

xid:  0x0016.007.00000075

ktubu redo: slt: 7 rci: 56 opc: 11.1 objn: 49864 objd: 49864 tsn: 2

Undo type:  Regular undo       Undo type:  Last buffer split:  No

Tablespace Undo:  No

0x00000000

KDO undo record:

KTB Redo

op: 0x02  ver: 0x01

op: C  uba: 0x04003245.001a.38

KDO Op code: URP row dependencies Disabled

xtype: XA flags: 0x00000000  bdba: 0x00c059fc  hdba: 0x00c059fb

itli: 2  ispac: 0  maxfr: 4858

tabn: 0 slot: 2(0x2) flag: 0x2c lock: 2 ckix: 0

ncol: 25 nnew: 8 size: 0

col  3: [ 5]  31 30 67 52 32

col  4: [ 1]  32

col  5: [ 2]  44 42

col  6: [ 1]  20

col  7: [ 1]  20

col 17: [ 7]  78 6f 03 0b 17 15 0d

col 22: [ 7]  78 6f 03 0b 17 18 2e

col 23: [ 1]  80

REDO RECORD - Thread:1 RBA: 0x00000b.0000a7e1.0010 LEN: 0x03c4 VLD: 0x0d

SCN: 0x0000.055b393d SUBSCN:  1 03/11/2011 22:23:45

CHANGE #1 TYP:2 CLS: 1 AFN:3 DBA:0x00c07738 OBJ:50291 SCN:0x0000.055b3939 SEQ:  2 OP:11.2

KTB Redo

op: 0x01  ver: 0x01

op: F  xid:  0x0015.001.00000074    uba: 0x040032ca.0019.0c

KDO Op code: IRP row dependencies Disabled

xtype: XA flags: 0x00000000  bdba: 0x00c07738  hdba: 0x00c066cb

itli: 1  ispac: 0  maxfr: 4858

tabn: 0 slot: 45(0x2d) size/delt: 153

fb: --H-FL-- lb: 0x1  cc: 10

null: ----N-----

col  0: [ 6]  4c 4f 41 44 45 52

col  1: [ 7]  78 6f 03 0b 17 18 2e

col  2: [ 2]  c1 10

col  3: [10]  58 4d 4c 4c 6f 61 64 65 72 30

col  4: *NULL*

col  5: [ 1]  59

col  6: [ 7]  52 45 43 4f 52 44 53

col  7: [ 1]  34

col  8: [77]

64 3a 5c 6f 72 61 63 6c 65 5c 70 72 6f 64 75 63 74 5c 31 30 2e 32 2e 30 5c

64 62 5f 31 5c 7a 67 63 2d 74 6f 6e 67 6a 69 5f 7a 67 63 62 6f 6f 72 63 5c

73 79 73 6d 61 6e 5c 72 65 63 76 5c 30 30 30 30 30 30 30 31 37 39 31 2e 78

6d 6c

col  9: [29]

7a 67 63 2d 74 6f 6e 67 6a 69 5f 4d 61 6e 61 67 65 6d 65 6e 74 5f 53 65 72

76 69 63 65

CHANGE #2 TYP:0 CLS:57 AFN:16 DBA:0x04000079 OBJ:4294967295 SCN:0x0000.055b392d SEQ:  2 OP:5.2

ktudh redo: slt: 0x0001 sqn: 0x00000074 flg: 0x0012 siz: 128 fbi: 0

uba: 0x040032ca.0019.0c    pxid:  0x0000.000.00000000

CHANGE #3 TYP:2 CLS: 1 AFN:3 DBA:0x00c0a1f7 OBJ:50493 SCN:0x0000.055b3939 SEQ:  2 OP:10.2

index redo (kdxlin):  insert leaf row

KTB Redo

op: 0x11  ver: 0x01

op: F  xid:  0x0015.001.00000074    uba: 0x040032ca.0019.0d

Block cleanout record, scn:  0x0000.055b393c ver: 0x01 opt: 0x02, entries follow...

itli: 2  flg: 2  scn: 0x0000.055b3939

REDO: SINGLE / -- / --

itl: 2, sno: 223, row size 27

insert key: (30):

06 4c 4f 41 44 45 52 07 78 6f 03 0b 17 18 2e 07 52 45 43 4f 52 44 53 06 00

c0 77 38 00 2d

prefix exists on block, sno: 0  len: 7CHANGE #4 TYP:0 CLS:57 AFN:16 DBA:0x04000079 OBJ:4294967295 SCN:0x0000.055b393d SEQ:  1 OP:5.4

ktucm redo: slt: 0x0001 sqn: 0x00000074 srt: 0 sta: 9 flg: 0x2

ktucf redo: uba: 0x040032ca.0019.0d ext: 25 spc: 6516 fbi: 0

CHANGE #5 TYP:0 CLS:58 AFN:16 DBA:0x040032ca OBJ:4294967295 SCN:0x0000.055b392d SEQ:  2 OP:5.1

ktudb redo: siz: 128 spc: 6764 flg: 0x0012 seq: 0x0019 rec: 0x0c

xid:  0x0015.001.00000074

ktubl redo: slt: 1 rci: 0 opc: 11.1 objn: 50291 objd: 50291 tsn: 2

Undo type:  Regular undo        Begin trans    Last buffer split:  No

Temp Object:  No

Tablespace Undo:  No

0x00000000  prev ctl uba: 0x040032ca.0019.0a

prev ctl max cmt scn:  0x0000.055b3687  prev tx cmt scn:  0x0000.055b368f

txn start scn:  0x0000.055b393b  logon user: 51  prev brb: 67121863  prev bcl: 0 KDO undo record:

KTB Redo

op: 0x04  ver: 0x01

op: L  itl: xid:  0x000e.014.0000005a uba: 0x04003417.0019.2d

flg: C---    lkc:  0     scn: 0x0000.055b3931

KDO Op code: DRP row dependencies Disabled

xtype: XA flags: 0x00000000  bdba: 0x00c07738  hdba: 0x00c066cb

itli: 1  ispac: 0  maxfr: 4858

tabn: 0 slot: 45(0x2d)

CHANGE #6 TYP:0 CLS:58 AFN:16 DBA:0x040032ca OBJ:4294967295 SCN:0x0000.055b393d SEQ:  1 OP:5.1

ktudb redo: siz: 116 spc: 6634 flg: 0x0022 seq: 0x0019 rec: 0x0d

xid:  0x0015.001.00000074

ktubu redo: slt: 1 rci: 12 opc: 10.22 objn: 50493 objd: 50493 tsn: 2

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:  0x000f.000.00000077 uba: 0x04003535.001b.03

flg: C---    lkc:  0     scn: 0x0000.055b3939

Dump kdilk : itl=2, kdxlkflg=0x41 sdc=0 indexid=0xc06cdb block=0x00c0a1f7

(kdxlpu): purge leaf row

key

30):

06 4c 4f 41 44 45 52 07 78 6f 03 0b 17 18 2e 07 52 45 43 4f 52 44 53 06 00

c0 77 38 00 2d

REDO RECORD - Thread:1 RBA: 0x00000b.0000a7e4.01a0 LEN: 0x5d54 VLD: 0x09

SCN: 0x0000.055b393f SUBSCN:  1 03/11/2011 22:23:45

CHANGE #1 TYP:2 CLS: 1 AFN:3 DBA:0x00c0880b OBJ:49871 SCN:0x0000.055b388a SEQ:  1 OP:10.2

index redo (kdxlin):  insert leaf row

KTB Redo

op: 0x11  ver: 0x01

op: F  xid:  0x0013.00d.00000073    uba: 0x040034a4.001b.01

Block cleanout record, scn:  0x0000.055b393e ver: 0x01 opt: 0x02, entries follow...

itli: 2  flg: 2  scn: 0x0000.055b388a

itli: 3  flg: 2  scn: 0x0000.055b362d

REDO: SINGLE / NONKEY / --

itl: 3, sno: 187, row size 18

insert key: (44):

10 f8 41 55 a9 51 f8 00 31 8a e8 0e 2e 68 f3 f8 14 10 87 b4 b3 58 96 fc 96

24 88 5c 38 70 a8 41 9f ae 01 20 07 78 6f 03 0b 17 17 0b

nonkey (length: 6):

fb: --H-FL-- lb: 0x0  cc: 1

(3):  02 c1 15

prefix exists on block, sno: 0  len: 36CHANGE #2 TYP:0 CLS:53 AFN:16 DBA:0x04000059 OBJ:4294967295 SCN:0x0000.055b3933 SEQ:  1 OP:5.2

ktudh redo: slt: 0x000d sqn: 0x00000073 flg: 0x000a siz: 176 fbi: 2

uba: 0x040034a4.001b.01    pxid:  0x0000.000.00000000

CHANGE #3 TYP:0 CLS: 1 AFN:3 DBA:0x00c05a3e OBJ:49874 SCN:0x0000.055b393e SEQ:  1 OP:10.35

index redo (kdxlcnu): update nonkey, count=5

KTB Redo

op: 0x01  ver: 0x01

op: F  xid:  0x0013.00d.00000073    uba: 0x040034a4.001b.02

REDO: SINGLE / NONKEY / --

itl: 2, sno: 0, row size 20

ncol: 2  nnew: 2 size: 0 flag: 0x02

nonkey columns updated:

col  0: [ 7]  78 6f 03 0b 17 17 0b

col  1: [ 2]  c1 15

CHANGE #4 TYP:2 CLS: 1 AFN:3 DBA:0x00c08809 OBJ:49871 SCN:0x0000.055b388a SEQ:  1 OP:10.2

index redo (kdxlin):  insert leaf row

KTB Redo

op: 0x11  ver: 0x01

op: F  xid:  0x0013.00d.00000073    uba: 0x040034a4.001b.03

Block cleanout record, scn:  0x0000.055b393e ver: 0x01 opt: 0x02, entries follow...

itli: 2  flg: 2  scn: 0x0000.055b362d

itli: 3  flg: 2  scn: 0x0000.055b388a

REDO: SINGLE / NONKEY / --

itl: 2, sno: 187, row size 18

insert key: (44):

10 f8 41 55 a9 51 f8 00 31 8a e8 0e 2e 68 f3 f8 14 10 1e a6 9e 01 8e 16 3e

3e 32 36 09 d3 34 ee 8e 20 01 20 07 78 6f 03 0b 17 17 0b

nonkey (length: 6):

fb: --H-FL-- lb: 0x0  cc: 1

(3):  02 c1 02

prefix exists on block, sno: 0  len: 36CHANGE #5 TYP:0 CLS: 1 AFN:3 DBA:0x00c08825 OBJ:49874 SCN:0x0000.055b393e SEQ:  1 OP:10.35

index redo (kdxlcnu): update nonkey, count=5

KTB Redo

op: 0x01  ver: 0x01

op: F  xid:  0x0013.00d.00000073    uba: 0x040034a4.001b.04

REDO: SINGLE / NONKEY / --

itl: 2, sno: 67, row size 20

ncol: 2  nnew: 2 size: 0 flag: 0x02

nonkey columns updated:

col  0: [ 7]  78 6f 03 0b 17 17 0b

col  1: [ 2]  c1 02

CHANGE #6 TYP:2 CLS: 1 AFN:3 DBA:0x00c0880d OBJ:49871 SCN:0x0000.055b388a SEQ:  1 OP:10.2

index redo (kdxlin):  insert leaf row

KTB Redo

op: 0x11  ver: 0x01

op: F  xid:  0x0013.00d.00000073    uba: 0x040034a4.001b.05

Block cleanout record, scn:  0x0000.055b393e ver: 0x01 opt: 0x02, entries follow...

itli: 2  flg: 2  scn: 0x0000.055b388a

itli: 3  flg: 2  scn: 0x0000.055b362d

REDO: SINGLE / NONKEY / --

itl: 3, sno: 188, row size 20

insert key: (44):

10 89 91 21 d4 7d 1b b0 ba 8a b5 c4 30 85 6b 41 db 10 d6 73 d3 b2 b1 6d e7

f1 9c cc 75 0c 86 67 fa bf 01 20 07 78 6f 03 0b 17 17 13

nonkey (length: 8):

fb: --H-FL-- lb: 0x0  cc: 1

(5):  04 c1 4f 0d 33

prefix exists on block, sno: 0  len: 36CHANGE #7 TYP:0 CLS: 1 AFN:3 DBA:0x00c08824 OBJ:49874 SCN:0x0000.055b393e SEQ:  1 OP:10.35

index redo (kdxlcnu): update nonkey, count=5

KTB Redo

op: 0x01  ver: 0x01

op: F  xid:  0x0013.00d.00000073    uba: 0x040034a4.001b.06

REDO: SINGLE / NONKEY / --

itl: 2, sno: 10, row size 22

ncol: 2  nnew: 2 size: 0 flag: 0x02

nonkey columns updated:

col  0: [ 7]  78 6f 03 0b 17 17 13

col  1: [ 4]  c1 4f 0d 33

CHANGE #8 TYP:2 CLS: 1 AFN:3 DBA:0x00c0c623 OBJ:49871 SCN:0x0000.055b388a SEQ:  1 OP:10.2

index redo (kdxlin):  insert leaf row

KTB Redo

op: 0x01  ver: 0x01

op: F  xid:  0x0013.00d.00000073    uba: 0x040034a4.001b.07

REDO: SINGLE / NONKEY / --

itl: 2, sno: 188, row size 18

insert key: (44):

10 89 91 21 d4 7d 1b b0 ba 8a b5 c4 30 85 6b 41 db 10 3b f8 44 46 b2 73 fe

1f 57 43 fd 62 93 c7 e1 92 01 20 07 78 6f 03 0b 17 17 13

nonkey (length: 6):

fb: --H-FL-- lb: 0x0  cc: 1

(3):  02 c1 02

prefix exists on block, sno: 0  len: 36CHANGE #9 TYP:0 CLS: 1 AFN:3 DBA:0x00c08823 OBJ:49874 SCN:0x0000.055b393e SEQ:  1 OP:10.35

index redo (kdxlcnu): update nonkey, count=5

KTB Redo

op: 0x01  ver: 0x01

op: F  xid:  0x0013.00d.00000073    uba: 0x040034a4.001b.08

REDO: SINGLE / NONKEY / --

itl: 3, sno: 23, row size 20

ncol: 2  nnew: 2 size: 0 flag: 0x02

nonkey columns updated:

col  0: [ 7]  78 6f 03 0b 17 17 13

col  1: [ 2]  c1 02

CHANGE #10 TYP:2 CLS: 1 AFN:3 DBA:0x00c0885e OBJ:49870 SCN:0x0000.055b392f SEQ:  5 OP:11.2

KTB Redo

op: 0x11  ver: 0x01

op: F  xid:  0x0013.00d.00000073    uba: 0x040034a4.001b.09

Block cleanout record, scn:  0x0000.055b393e ver: 0x01 opt: 0x02, entries follow...

itli: 1  flg: 2  scn: 0x0000.055b388a

itli: 2  flg: 2  scn: 0x0000.055b392f

KDO Op code: IRP row dependencies Disabled

xtype: XA flags: 0x00000000  bdba: 0x00c0885e  hdba: 0x00c05a23

itli: 1  ispac: 0  maxfr: 4858

tabn: 0 slot: 109(0x6d) size/delt: 8

fb: -----L-- lb: 0x1  cc: 1

null: -

col  0: [ 4]  4f 50 45 4e

CHANGE #11 TYP:2 CLS: 1 AFN:3 DBA:0x00c079eb OBJ:49871 SCN:0x0000.055b388a SEQ:  1 OP:10.2

index redo (kdxlin):  insert leaf row

KTB Redo

op: 0x01  ver: 0x01

op: F  xid:  0x0013.00d.00000073    uba: 0x040034a4.001b.0a

REDO: SINGLE / NONKEY / --

itl: 2, sno: 188, row size 22

insert key: (44):

10 89 91 21 d4 7d 1b b0 ba 8a b5 c4 30 85 6b 41 db 10 f6 32 dd 23 26 30 ba

07 e7 9f 64 67 d0 3b 97 df 01 20 07 78 6f 03 0b 17 17 13

nonkey (length: 10):

fb: --H-F--- lb: 0x0  cc: 1

nrid:  0x00c0885e.6d

(1):  ff

prefix exists on block, sno: 0  len: 36CHANGE #12 TYP:0 CLS: 1 AFN:3 DBA:0x00c08822 OBJ:49874 SCN:0x0000.055b393e SEQ:  1 OP:10.35

index redo (kdxlcnu): update nonkey, count=5

KTB Redo

op: 0x01  ver: 0x01

op: F  xid:  0x0013.00d.00000073    uba: 0x040034a4.001b.0b

REDO: SINGLE / NONKEY / --

itl: 2, sno: 10, row size 24

ncol: 2  nnew: 2 size: 0 flag: 0x02

nonkey columns updated:

col  0: [ 7]  78 6f 03 0b 17 17 13

col  1: *NULL*

CHANGE #13 TYP:2 CLS: 1 AFN:3 DBA:0x00c05a38 OBJ:49873 SCN:0x0000.055b392f SEQ:  5 OP:11.5

KTB Redo

op: 0x11  ver: 0x01

op: F  xid:  0x0013.00d.00000073    uba: 0x040034a4.001b.0c

Block cleanout record, scn:  0x0000.055b393e ver: 0x01 opt: 0x02, entries follow...

itli: 1  flg: 2  scn: 0x0000.055b392f

itli: 2  flg: 2  scn: 0x0000.055b388a

KDO Op code: URP row dependencies Disabled

xtype: XA flags: 0x00000000  bdba: 0x00c05a38  hdba: 0x00c05a33

itli: 2  ispac: 0  maxfr: 4858

tabn: 0 slot: 0(0x0) flag: 0x04 lock: 2 ckix: 0

ncol: 1 nnew: 1 size: 0

col  0: [ 4]  4f 50 45 4e

CHANGE #14 TYP:2 CLS: 1 AFN:3 DBA:0x00c0c627 OBJ:49871 SCN:0x0000.055b388a SEQ:  1 OP:10.2

index redo (kdxlin):  insert leaf row

KTB Redo

op: 0x11  ver: 0x01

op: F  xid:  0x0013.00d.00000073    uba: 0x040034a4.001b.0d

Block cleanout record, scn:  0x0000.055b393e ver: 0x01 opt: 0x02, entries follow...

itli: 2  flg: 2  scn: 0x0000.055b388a

itli: 3  flg: 2  scn: 0x0000.055b362d

REDO: SINGLE / NONKEY / --

itl: 3, sno: 187, row size 17

insert key: (44):

10 e1 6a 5a b7 3a df 7e 7f 09 e1 8c af 82 a2 af 5f 10 8e 38 b4 9c 40 c7 1f

8b 6b 25 07 45 7f ef 2e 58 01 20 07 78 6f 03 0b 17 17 12

nonkey (length: 5):

fb: --H-FL-- lb: 0x0  cc: 1

(2):  01 80

index redo (kdxlcnu): update nonkey, count=5

KTB Redo

op: 0x02  ver: 0x01