[b]Oracle10g 动态性能视图之—V$TRANSACTION[/b]
[size=small]老规矩打开Oracle 10g的帮助文档 "Most Popular" ->"Reference" 选择HTML->"7 Dynamic Performance (V$) Views: V$NLS_PARAMETERS to V$XML_AUDIT_TRAIL" ->
点击"V$TRANSACTION"链接，进入官方对该动态性能视图的解释。[/size]
[size=small][b]
首先"V$TRANSACTION" 的作用[/b][/size]
[size=small]V$TRANSACTION 列出当前数据库系统中的活动事务,其实就是监控当前数据库系统正在执行的事务[/size]
[size=small][b]观注各列字段的含意[/b][/size]
列名 数据类型 含义
ADDR RAW(4|8) Address of the transaction state object
XIDUSN NUMBER 使用的回滚段号,可以和v$rollstat对应
XIDSLOT NUMBER RBS TX 表中的槽号 USN.SLOT.SQN
XIDSQN NUMBER 序列号，TX-USNxSLOT-SQNxxxxx
UBAFIL NUMBER 最后一个撤销块地址所在的文件号
UBABLK NUMBER UBA 块号
UBASQN NUMBER UBA 序列号
UBAREC NUMBER UBA 记录号
STATUS VARCHAR2(16) 当前事务的状态
START_TIME VARCHAR2(20) Start time (wall clock)
START_SCNB NUMBER 开始的系统改变号
START_SCNW NUMBER Start SCN wrap
START_UEXT NUMBER Start extent number
START_UBAFIL NUMBER Start UBA file number
START_UBABLK NUMBER Start UBA block number
START_UBASQN NUMBER Start UBA sequence number
START_UBAREC NUMBER Start UBA record number
SES_ADDR RAW(4|8) 用户会话对象地址，对v$session 的saddr列
FLAG NUMBER Flag
SPACE VARCHAR2(3) YES if a space transaction
RECURSIVE VARCHAR2(3) YES if a recursive transaction
NOUNDO VARCHAR2(3) YES if a no undo transaction
PTX VARCHAR 2(3) YES if parallel transaction
NAME VARCHAR2(256) Name of a named transaction
PRV_XIDUSN NUMBER Previous transaction undo segment number
PRV_XIDSLT NUMBER Previous transaction slot number
PRV_XIDSQN NUMBER Previous transaction sequence number
PTX_XIDUSN NUMBER Rollback segment number of the parent XID
PTX_XIDSLT NUMBER Slot number of the parent XID
PTX_XIDSQN NUMBER Sequence number of the parent XID
DSCN-B NUMBER This column is obsolete and maintained for backward compatibility. The value of this column is always equal to the value in DSCN_BASE.
DSCN-W NUMBER This column is obsolete and maintained for backward compatibility. The value of this column is always equal to the value in DSCN_WRAP.
USED_UBLK NUMBER 已占用的undo 块数
USED_UREC NUMBER 已使用的undo 记录数
LOG_IO NUMBER 逻辑 I/O
PHY_IO NUMBER 物理 I/O
CR_GET NUMBER 一致读的次数
CR_CHANGE NUMBER Consistent changes
START_DATE DATE Start time (wall clock)
DSCN_BASE NUMBER Dependent SCN base
DSCN_WRAP NUMBER Dependent SCN wrap
START_SCN NUMBER Start SCN
DEPENDENT_SCN NUMBER Dependent SCN
XID RAW(8) Transaction XID
PRV_XID RAW(8) Previous transaction XID
PTX_XID RAW(8) Parent transaction XID
[size=small][b]示例了解该动态性能视图[/b][/size]
[size=small][b]准备测试表[/b][/size]SQL> DESC T1; //数据量级是百万记录的一张表
Name Null? Type
----------------------------------------- -------- ---------------------
ID NUMBER
OWNER NOT NULL VARCHAR2(30)
OBJECT_NAME NOT NULL VARCHAR2(30)
SUBOBJECT_NAME VARCHAR2(30)
OBJECT_ID NOT NULL NUMBER
DATA_OBJECT_ID NUMBER
OBJECT_TYPE VARCHAR2(19)
CREATED NOT NULL DATE
LAST_DDL_TIME NOT NULL DATE
TIMESTAMP VARCHAR2(19)
STATUS VARCHAR2(7)
TEMPORARY VARCHAR2(1)
GENERATED VARCHAR2(1)
SECONDARY VARCHAR2(1)
[b][size=small]使用UPDATE 语句更新这张表[/size][/b]
SQL> update t1 set owner='loris';
[b][size=small]查询该更新事务信息[/size][/b]
SYS@ orcl>select xid,xidusn,xidslot,xidsqn,start_time,start_scnb,used_ublk,used_urec,log_io,phy_io from v$transaction;
XID XIDUSN XIDSLOT XIDSQN START_TIME START_SCNB USED_UBLK USED_UREC LOG_IO PHY_IO
---------------- ---------- ---------- ---------- -------------------- ---------- ---------- ---------- ---------- ----------
07002900AE050000 7 41 1454 11/27/13 10:50:33 0 0 0 2 0
0500090008060000 5 9 1544 11/27/13 10:47:00 2804989 12369 1312538 4069121 34370
隔了5分钟再查一次
XID XIDUSN XIDSLOT XIDSQN START_TIME START_SCNB USED_UBLK USED_UREC LOG_IO PHY_IO
---------------- ---------- ---------- ---------- -------------------- ---------- ---------- ---------- ---------- ----------
0500090008060000 5 9 1544 11/27/13 10:47:00 2804989 14582 1496747 4635250 40912
03002500FE050000 3 37 1534 11/27/13 10:55:19 0 0 0 2 0
02001B00F6050000 2 27 1526 11/27/13 10:55:19 2832534 1 2 10 0
[size=small][b]
联合v$session 再查一次，这样就知道是哪个用户的哪些事务了，进而可以跟踪到sql[/b][/size]
[size=small][b]注：used_urec 字段不断增加，说明该事物正在继续，如果该字段不断下降，说明该事物正在回滚[/b][/size]
SYS@ orcl>select b.sid,b.username,xid,a.status,start_time,used_ublk,used_urec,log_io,phy_io from v$transaction a,v$session b where a.ses_addr = b.saddr;
[size=small][b]事务进阶 [/b] [/size]
一个事务的活动信息是保存在undo 段中，V$TRANSACTION事务表中的
[b]XID由XIDUSN.XIDSLOT.XIDSQN组成 ，如xid: 0x000a.00f.000005b5 10.15.1461[/b]
SYS@ orcl>select xid,xidusn,cr_get,used_ublk,used_urec,ubafil,log_io,phy_io,status from v$transaction;
XID XIDUSN CR_GET USED_UBLK USED_UREC UBAFIL LOG_IO PHY_IO STATUS
---------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ----------------
0A000F00B5050000 10 7 1 1 2 5 0 ACTIVE
[size=x-small][b]Oracle 在undo段的第一个数据块，回滚段头块存放事务信息 也就是有一个数据结构—事务表[/b][/size]SYS@ orcl>select name from v$rollname where usn=10;
NAME
------------------------------
_SYSSMU10$
[size=small][b]dump回滚段头: [/b][/size]
SYS@ orcl>alter system dump undo header '_SYSSMU10$'
2 ;
System altered.
在数据库udump目录下，可以找到dump出来的文件
********************************************************************************
Undo Segment: _SYSSMU10$ (10)
********************************************************************************
Extent Control Header
-----------------------------------------------------------------
Extent Header:: spare1: 0 spare2: 0 #extents: 3 #blocks: 143
last map 0x00000000 #maps: 0 offset: 4080
Highwater:: 0x00800249 ext#: 2 blk#: 64 ext size: 128
#blocks in seg. hdr's freelists: 0
#blocks below: 0
mapblk 0x00000000 offset: 2
Unlocked
Map Header:: next 0x00000000 #extents: 3 obj#: 0 flag: 0x40000000
Extent Map
-----------------------------------------------------------------
0x0080009a length: 7
0x00801b29 length: 8
0x00800209 length: 128
Retention Table
-----------------------------------------------------------
Extent Number:0 Commit Time: 1385439155
Extent Number:1 Commit Time: 1385439155
Extent Number:2 Commit Time: 1385439155
TRN CTL:: seq: 0x052a chd: 0x0005 ctl: 0x002e inc: 0x00000000 nfb: 0x0000
mgc: 0x8201 xts: 0x0068 flg: 0x0001 opt: 2147483646 (0x7ffffffe)
uba: 0x00800249.052a.26 scn: 0x0000.002b5d0c
Version: 0x01
FREE BLOCK POOL::
uba: 0x00000000.052a.25 ext: 0x2 spc: 0x960
uba: 0x00000000.052a.01 ext: 0x2 spc: 0x1f88
uba: 0x00000000.052a.01 ext: 0x2 spc: 0x1f88
uba: 0x00000000.052a.01 ext: 0x2 spc: 0x1f88
uba: 0x00000000.0000.00 ext: 0x0 spc: 0x0
TRN TBL::
index state cflags wrap# uel scn dba parent-xid nub stmt_num cmt
------------------------------------------------------------------------------------------------
0x00 9 0x00 0x05b7 0x0023 0x0000.002b5d7b 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x01 9 0x00 0x05b5 0x0000 0x0000.002b5d71 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x02 9 0x00 0x05b7 0x0027 0x0000.002b6077 0x00800248 0x0000.000.00000000 0x00000001 0x00000000 1385529850
0x03 9 0x00 0x05b6 0x001f 0x0000.002b5d48 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x04 9 0x00 0x05b7 0x0002 0x0000.002b606e 0x00800248 0x0000.000.00000000 0x00000001 0x00000000 1385529850
0x05 9 0x00 0x05b6 0x0024 0x0000.002b5d16 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x06 9 0x00 0x05b7 0x002c 0x0000.002b6163 0x00800249 0x0000.000.00000000 0x00000001 0x00000000 1385530335
0x07 9 0x00 0x05b7 0x0017 0x0000.002b5e82 0x00800248 0x0000.000.00000000 0x00000001 0x00000000 1385528946
0x08 9 0x00 0x05b5 0x000b 0x0000.002b5dc2 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x09 9 0x00 0x05b6 0x0019 0x0000.002b5d5c 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x0a 9 0x00 0x05b6 0x0028 0x0000.002b5fbf 0x00800248 0x0000.000.00000000 0x00000001 0x00000000 1385529597
0x0b 9 0x00 0x05b5 0x0029 0x0000.002b5dcc 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x0c 9 0x00 0x05b7 0x0026 0x0000.002b6108 0x00800248 0x0000.000.00000000 0x00000001 0x00000000 1385530182
0x0d 9 0x00 0x05b4 0x001e 0x0000.002b5d8f 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x0e 9 0x00 0x05b6 0x002d 0x0000.002b6020 0x00800248 0x0000.000.00000000 0x00000001 0x00000000 1385529791
[color=red][b][size=small] 0x0f 10 0x80 0x05b5 0x0002 0x0000.002b6223 0x00800249 0x0000.000.00000000 0x00000001 0x00000000 0[/size][/b][/color] 0x10 9 0x00 0x05b6 0x0006 0x0000.002b6136 0x00800249 0x0000.000.00000000 0x00000001 0x00000000 1385530248
0x11 9 0x00 0x05b3 0x000a 0x0000.002b5f9b 0x00800248 0x0000.000.00000000 0x00000001 0x00000000 1385529532
0x12 9 0x00 0x05b7 0x001a 0x0000.002b6049 0x00800248 0x0000.000.00000000 0x00000001 0x00000000 1385529850
0x13 9 0x00 0x05b6 0x0008 0x0000.002b5db8 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x14 9 0x00 0x05b6 0x002b 0x0000.002b5f0b 0x00800248 0x0000.000.00000000 0x00000001 0x00000000 1385529206
0x15 9 0x00 0x05b6 0x0007 0x0000.002b5e58 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528881
0x16 9 0x00 0x05b5 0x0004 0x0000.002b6065 0x00800248 0x0000.000.00000000 0x00000001 0x00000000 1385529850
0x17 9 0x00 0x05b6 0x0018 0x0000.002b5e93 0x00800248 0x0000.000.00000000 0x00000001 0x00000000 1385528954
0x18 9 0x00 0x05b6 0x0014 0x0000.002b5ecd 0x00800248 0x0000.000.00000000 0x00000001 0x00000000 1385529076
0x19 9 0x00 0x05b6 0x0001 0x0000.002b5d67 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x1a 9 0x00 0x05b3 0x001b 0x0000.002b6053 0x00800248 0x0000.000.00000000 0x00000001 0x00000000 1385529850
0x1b 9 0x00 0x05b4 0x0016 0x0000.002b605c 0x00800248 0x0000.000.00000000 0x00000001 0x00000000 1385529850
0x1c 9 0x00 0x05b6 0x0025 0x0000.002b5da4 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x1d 9 0x00 0x05b3 0x0003 0x0000.002b5d3e 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x1e 9 0x00 0x05b5 0x001c 0x0000.002b5d9a 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x1f 9 0x00 0x05b4 0x0009 0x0000.002b5d52 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x20 9 0x00 0x05b4 0x001d 0x0000.002b5d34 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x21 9 0x00 0x05b5 0x002f 0x0000.002b5dea 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x22 9 0x00 0x05b5 0x0020 0x0000.002b5d2a 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x23 9 0x00 0x05b5 0x000d 0x0000.002b5d85 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x24 9 0x00 0x05b6 0x0022 0x0000.002b5d20 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x25 9 0x00 0x05b5 0x0013 0x0000.002b5dae 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x26 9 0x00 0x05b5 0x0010 0x0000.002b612d 0x00800249 0x0000.000.00000000 0x00000002 0x00000000 1385530248
0x27 9 0x00 0x05b5 0x000c 0x0000.002b60b7 0x00800248 0x0000.000.00000000 0x00000001 0x00000000 1385529987
0x28 9 0x00 0x05b5 0x000e 0x0000.002b5fc9 0x00800248 0x0000.000.00000000 0x00000001 0x00000000 1385529597
0x29 9 0x00 0x05b5 0x002a 0x0000.002b5dd6 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x2a 9 0x00 0x05b5 0x0021 0x0000.002b5de0 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x2b 9 0x00 0x05b6 0x0011 0x0000.002b5f5f 0x00800248 0x0000.000.00000000 0x00000001 0x00000000 1385529401
0x2c 9 0x00 0x05b5 0x002e 0x0000.002b619a 0x00800249 0x0000.000.00000000 0x00000001 0x00000000 1385530450
0x2d 9 0x00 0x05b5 0x0012 0x0000.002b6040 0x00800248 0x0000.000.00000000 0x00000001 0x00000000 1385529850
0x2e 9 0x00 0x05b6 0xffff 0x0000.002b61d8 0x00800249 0x0000.000.00000000 0x00000001 0x00000000 1385530576
0x2f 9 0x00 0x05b5 0x0015 0x0000.002b5e01 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528684
[size=small][b]dump回滚块[/b][/size]
YS@ orcl>select xid,xidusn,cr_get,used_ublk,used_urec,ubafil,ubablk,ubasqn,log_io,phy_io,status from v$transaction;
XID XIDUSN CR_GET USED_UBLK USED_UREC UBAFIL UBABLK UBASQN LOG_IO PHY_IO STATUS
---------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ----------------
0A000F00B5050000 10 7 1 1 2 585 1322 5 0 ACTIVE
SYS@ orcl>alter system dump datafile 2 block 585;
System altered.
Start dump data blocks tsn: 1 file#: 2 minblk 585 maxblk 585
buffer tsn: 1 rdba: 0x00800249 (2/585)
scn: 0x0000.002b6223 seq: 0x01 flg: 0x04 tail: 0x62230201
frmt: 0x02 chkval: 0x94e2 type: 0x02=KTU UNDO BLOCK
Hex dump of block: st=0, typ_found=1
Dump of memory from 0x0CC2B600 to 0x0CC2D600
CC2B600 0000A202 00800249 002B6223 04010000 [....I...#b+.....]
CC2B610 000094E2 000F000A 000005B5 2626052A [............*.&&]
CC2B620 1FE80000 1EF01F64 1DE01E64 1CE01D54 [....d...d...T...]
CC2B630 1BD01C5C 1AC01B4C 19A41A3C 18BC1920 [\...L...<... ...]
省略部分，重点在如下部分
********************************************************************************
UNDO BLK:
xid: 0x000a.00f.000005b5 seq: 0x52a cnt: 0x26 irb: 0x26 icl: 0x0 flg: 0x0000
Rec Offset Rec Offset Rec Offset Rec Offset Rec Offset
---------------------------------------------------------------------------
0x01 0x1f64 0x02 0x1ef0 0x03 0x1e64 0x04 0x1de0 0x05 0x1d54
0x06 0x1ce0 0x07 0x1c5c 0x08 0x1bd0 0x09 0x1b4c 0x0a 0x1ac0
0x0b 0x1a3c 0x0c 0x19a4 0x0d 0x1920 0x0e 0x18bc 0x0f 0x1868
0x10 0x17fc 0x11 0x1778 0x12 0x1708 0x13 0x1688 0x14 0x1604
0x15 0x15a4 0x16 0x1544 0x17 0x0fe4 0x18 0x0f7c 0x19 0x0f2c
0x1a 0x0ec4 0x1b 0x0e74 0x1c 0x0d88 0x1d 0x0d30 0x1e 0x0cd8
0x1f 0x0c54 0x20 0x0bf0 0x21 0x0b9c 0x22 0x0b30 0x23 0x0aac
0x24 0x0a3c 0x25 0x09bc 0x26 0x0724
*-----------------------------
* Rec #0x1 slt: 0x26 objn: 49948(0x0000c31c) objd: 49948 tblspc: 2(0x00000002)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00800248
*-----------------------------
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0009.029.0000061b uba: 0x008000da.05b9.0c
flg: C--- lkc: 0 scn: 0x0000.002b6128
Array Update of 1 rows:
tabn: 0 slot: 4(0x4) flag: 0x2c lock: 0 ckix: 191
ncol: 12 nnew: 2 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x00c05be8 hdba: 0x00c05be3
itli: 1 ispac: 0 maxfr: 4858
vect = 74
col 9: [ 1] 80
col 10: [ 1] 80
*-----------------------------
* Rec #0x2 slt: 0x26 objn: 49871(0x0000c2cf) objd: 49871 tblspc: 2(0x00000002)
* Layer: 10 (Index) opc: 22 rci 0x01
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x02 ver: 0x01
op: C uba: 0x00800248.052a.36
Dump kdilk : itl=2, kdxlkflg=0x41 sdc=1 indexid=0xc059ab block=0x00c0758b
(kdxlpu): purge leaf row
key :(44):
10 0c 48 c5 ae 0f af b4 2e d9 1f 89 7f f3 98 fc 84 10 7b 53 ef 40 72 c3 ee
d7 df a5 46 74 a4 4e a7 77 01 20 07 78 71 0b 1b 0e 1f 31
*-----------------------------
* Rec #0x3 slt: 0x26 objn: 49874(0x0000c2d2) objd: 49874 tblspc: 2(0x00000002)
* Layer: 10 (Index) opc: 22 rci 0x02
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x02 ver: 0x01
op: C uba: 0x00800248.052a.37
Dump kdilk : itl=2, kdxlkflg=0x51 sdc=4 indexid=0xc059bb block=0x00c059bf
(kdxlcnu): column-vector nonkey update
ncol: 2 nnew: 2 size: 0 flag: 0x02
key :(36):
10 0c 48 c5 ae 0f af b4 2e d9 1f 89 7f f3 98 fc 84 10 7b 53 ef 40 72 c3 ee
d7 df a5 46 74 a4 4e a7 77 01 20
nonkey columns updated:
col 0: [ 7] 78 71 0b 1b 0e 14 3a
col 1: [ 1] 80
*-----------------------------
* Rec #0x4 slt: 0x26 objn: 49871(0x0000c2cf) objd: 49871 tblspc: 2(0x00000002)
* Layer: 10 (Index) opc: 22 rci 0x03
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0003.009.00000602 uba: 0x00804511.0520.36
flg: C--- lkc: 0 scn: 0x0000.002b5fc6
Dump kdilk : itl=2, kdxlkflg=0x41 sdc=0 indexid=0xc059ab block=0x00c0758a
(kdxlpu): purge leaf row
key :(44):
10 0c 48 c5 ae 0f af b4 2e d9 1f 89 7f f3 98 fc 84 10 3d 47 f6 fd 64 c9 16
90 e0 d9 09 07 8c 14 9e bc 01 20 07 78 71 0b 1b 0e 1f 31
*-----------------------------
* Rec #0x5 slt: 0x26 objn: 49874(0x0000c2d2) objd: 49874 tblspc: 2(0x00000002)
* Layer: 10 (Index) opc: 22 rci 0x04
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x02 ver: 0x01
op: C uba: 0x00800249.052a.03
Dump kdilk : itl=2, kdxlkflg=0x51 sdc=4 indexid=0xc059bb block=0x00c059bf
(kdxlcnu): column-vector nonkey update
ncol: 2 nnew: 2 size: 0 flag: 0x02
key :(36):
10 0c 48 c5 ae 0f af b4 2e d9 1f 89 7f f3 98 fc 84 10 3d 47 f6 fd 64 c9 16
90 e0 d9 09 07 8c 14 9e bc 01 20
nonkey columns updated:
col 0: [ 7] 78 71 0b 1b 0e 14 3a
col 1: [ 1] 80
*-----------------------------
* Rec #0x6 slt: 0x26 objn: 49948(0x0000c31c) objd: 49948 tblspc: 2(0x00000002)
* Layer: 11 (Row) opc: 1 rci 0x05
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
op: C uba: 0x00800249.052a.01
Array Update of 1 rows:
tabn: 0 slot: 5(0x5) flag: 0x2c lock: 0 ckix: 191
ncol: 12 nnew: 2 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x00c05be8 hdba: 0x00c05be3
itli: 1 ispac: 0 maxfr: 4858
vect = 77
col 9: [ 1] 80
col 10: [ 1] 80
*-----------------------------
* Rec #0x7 slt: 0x26 objn: 49871(0x0000c2cf) objd: 49871 tblspc: 2(0x00000002)
* Layer: 10 (Index) opc: 22 rci 0x06
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0009.029.0000061b uba: 0x008000da.05b9.15
flg: C--- lkc: 0 scn: 0x0000.002b6128
Dump kdilk : itl=2, kdxlkflg=0x41 sdc=0 indexid=0xc059ab block=0x00c07b1e
(kdxlpu): purge leaf row
key :(44):
10 0c 48 c5 ae 0f af b4 2e d9 1f 89 7f f3 98 fc 84 10 a7 1c cd f9 ae 28 aa
9e 04 11 ef 94 b8 5b 6c 13 01 20 07 78 71 0b 1b 0e 1f 31
*-----------------------------
* Rec #0x8 slt: 0x26 objn: 49874(0x0000c2d2) objd: 49874 tblspc: 2(0x00000002)
* Layer: 10 (Index) opc: 22 rci 0x07
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x02 ver: 0x01
op: C uba: 0x00800249.052a.05
Dump kdilk : itl=2, kdxlkflg=0x51 sdc=4 indexid=0xc059bb block=0x00c059bf
(kdxlcnu): column-vector nonkey update
ncol: 2 nnew: 2 size: 0 flag: 0x02
key :(36):
10 0c 48 c5 ae 0f af b4 2e d9 1f 89 7f f3 98 fc 84 10 a7 1c cd f9 ae 28 aa
9e 04 11 ef 94 b8 5b 6c 13 01 20
nonkey columns updated:
col 0: [ 7] 78 71 0b 1b 0e 14 3a
col 1: [ 1] 80
*-----------------------------
* Rec #0x9 slt: 0x26 objn: 49871(0x0000c2cf) objd: 49871 tblspc: 2(0x00000002)
* Layer: 10 (Index) opc: 22 rci 0x08
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0009.029.0000061b uba: 0x008000da.05b9.1f
flg: C--- lkc: 0 scn: 0x0000.002b6128
Dump kdilk : itl=2, kdxlkflg=0x41 sdc=0 indexid=0xc059ab block=0x00c07b1a
(kdxlpu): purge leaf row
key :(44):
10 0c 48 c5 ae 0f af b4 2e d9 1f 89 7f f3 98 fc 84 10 58 cf 07 a4 d5 f7 ef
85 e1 dd 63 23 a0 c9 52 31 01 20 07 78 71 0b 1b 0e 1f 31
*-----------------------------
* Rec #0xa slt: 0x26 objn: 49874(0x0000c2d2) objd: 49874 tblspc: 2(0x00000002)
* Layer: 10 (Index) opc: 22 rci 0x09
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x02 ver: 0x01
op: C uba: 0x00800249.052a.08
Dump kdilk : itl=2, kdxlkflg=0x51 sdc=4 indexid=0xc059bb block=0x00c059bf
(kdxlcnu): column-vector nonkey update
ncol: 2 nnew: 2 size: 0 flag: 0x02
key :(36):
10 0c 48 c5 ae 0f af b4 2e d9 1f 89 7f f3 98 fc 84 10 58 cf 07 a4 d5 f7 ef
85 e1 dd 63 23 a0 c9 52 31 01 20
nonkey columns updated:
col 0: [ 7] 78 71 0b 1b 0e 14 3a
col 1: [ 1] 80
*-----------------------------
* Rec #0xb slt: 0x10 objn: 50291(0x0000c473) objd: 50291 tblspc: 2(0x00000002)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
uba: 0x00800248.052a.34 ctl max scn: 0x0000.002b5c7b prv tx scn: 0x0000.002b5c8a
txn start scn: scn: 0x0000.002b6135 logon user: 51
prev brb: 8389191 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0009.005.0000061b uba: 0x008000da.05b9.23
flg: C--- lkc: 0 scn: 0x0000.002b6132
KDO Op code: DRP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x00c0664f hdba: 0x00c0664b
itli: 1 ispac: 0 maxfr: 4858
tabn: 0 slot: 108(0x6c)
*-----------------------------
* Rec #0xc slt: 0x10 objn: 50493(0x0000c53d) objd: 50493 tblspc: 2(0x00000002)
* Layer: 10 (Index) opc: 22 rci 0x0b
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0004.020.000005b0 uba: 0x00800022.0427.30
flg: C--- lkc: 0 scn: 0x0000.002b5fc7
Dump kdilk : itl=2, kdxlkflg=0x41 sdc=0 indexid=0xc06c5b block=0x00c06c5d
(kdxlpu): purge leaf row
key :(63):
23 45 4d 44 5f 43 4f 4c 4c 45 43 54 49 4f 4e 2e 43 6f 6c 6c 65 63 74 69 6f
6e 20 53 75 62 73 79 73 74 65 6d 07 78 71 0b 1b 0e 1f 31 0b 43 6f 6c 6c 65
63 74 69 6f 6e 73 06 00 c0 66 4f 00 6c
*-----------------------------
* Rec #0xd slt: 0x06 objn: 8779(0x0000224b) objd: 8779 tblspc: 2(0x00000002)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
uba: 0x00800249.052a.0b ctl max scn: 0x0000.002b5c8a prv tx scn: 0x0000.002b5cc0
txn start scn: scn: 0x0000.002b6162 logon user: 0
prev brb: 8389191 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0005.018.0000060b uba: 0x008044a6.0623.2d
flg: C--- lkc: 0 scn: 0x0000.002b60e2
KDO Op code: DRP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x00c00a65 hdba: 0x00c00a63
itli: 1 ispac: 0 maxfr: 4858
tabn: 0 slot: 3(0x3)
*-----------------------------
* Rec #0xe slt: 0x06 objn: 8780(0x0000224c) objd: 8780 tblspc: 2(0x00000002)
* Layer: 10 (Index) opc: 22 rci 0x0d
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0004.01f.000005b1 uba: 0x00800023.0427.19
flg: C--- lkc: 0 scn: 0x0000.002b60fd
Dump kdilk : itl=2, kdxlkflg=0x1 sdc=180352046 indexid=0xc00a6b block=0x00c00a6c
(kdxlpu): purge leaf row
key :(12): 03 c2 02 16 02 c1 06 01 80 02 c1 02
*-----------------------------
* Rec #0xf slt: 0x06 objn: 8786(0x00002252) objd: 8786 tblspc: 2(0x00000002)
* Layer: 11 (Row) opc: 1 rci 0x0e
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0005.018.0000060b uba: 0x008044a6.0623.2f
flg: C--- lkc: 0 scn: 0x0000.002b60e2
KDO Op code: DRP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x00c08988 hdba: 0x00c00a83
itli: 1 ispac: 0 maxfr: 4858
tabn: 0 slot: 14(0xe)
*-----------------------------
* Rec #0x10 slt: 0x06 objn: 8789(0x00002255) objd: 8789 tblspc: 2(0x00000002)
* Layer: 10 (Index) opc: 22 rci 0x0f
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0004.01f.000005b1 uba: 0x00800023.0427.1d
flg: C--- lkc: 0 scn: 0x0000.002b60fd
Dump kdilk : itl=2, kdxlkflg=0x1 sdc=-1073826568 indexid=0xc00a9b block=0x00c07636
(kdxlpu): purge leaf row
key :(17): 10 ec 20 60 c7 8e ab 88 da e0 40 a8 c0 6e 01 0a 2b
*-----------------------------
* Rec #0x11 slt: 0x06 objn: 8803(0x00002263) objd: 8803 tblspc: 2(0x00000002)
* Layer: 10 (Index) opc: 22 rci 0x10
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0004.01f.000005b1 uba: 0x00800023.0427.1e
flg: C--- lkc: 0 scn: 0x0000.002b60fd
Dump kdilk : itl=2, kdxlkflg=0x1 sdc=213658176 indexid=0xc00ad3 block=0x00c082df
(kdxlpu): purge leaf row
key :(42):
02 c1 2a 01 30 01 80 0b 78 71 0b 1a 17 21 11 08 75 9e 70 01 80 01 80 01 80
10 ec 20 60 c7 8e ab 88 da e0 40 a8 c0 6e 01 0a 2b
*-----------------------------
* Rec #0x12 slt: 0x06 objn: 8798(0x0000225e) objd: 8798 tblspc: 2(0x00000002)
* Layer: 10 (Index) opc: 22 rci 0x11
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0005.018.0000060b uba: 0x008044a6.0623.32
flg: C--- lkc: 0 scn: 0x0000.002b60e2
Dump kdilk : itl=3, kdxlkflg=0x1 sdc=8803 indexid=0xc00abb block=0x00c00cd5
(kdxlpu): purge leaf row
key :(24):
10 ec 20 60 c7 8e ab 88 da e0 40 a8 c0 6e 01 0a 2b 02 c1 2a 01 30 01 80
*-----------------------------
* Rec #0x13 slt: 0x06 objn: 8796(0x0000225c) objd: 8796 tblspc: 2(0x00000002)
* Layer: 10 (Index) opc: 22 rci 0x12
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0005.018.0000060b uba: 0x008044a7.0623.01
flg: C--- lkc: 0 scn: 0x0000.002b60e2
Dump kdilk : itl=2, kdxlkflg=0x1 sdc=1 indexid=0xc00ab3 block=0x00c08730
(kdxlpu): purge leaf row
key :(39):
0b 78 71 0c 03 17 21 11 08 75 9e 70 09 31 30 2e 36 2e 31 34 36 33 10 ec 20
60 c7 8e ab 88 da e0 40 a8 c0 6e 01 0a 2b
*-----------------------------
* Rec #0x14 slt: 0x2c objn: 575(0x0000023f) objd: 573 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: 0x00000000
*-----------------------------
uba: 0x00800249.052a.0d ctl max scn: 0x0000.002b5cc0 prv tx scn: 0x0000.002b5cf7
txn start scn: scn: 0x0000.002b6199 logon user: 0
prev brb: 8389191 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0007.021.00000595 uba: 0x00801c06.049f.19
flg: C--- lkc: 0 scn: 0x0000.0029e550
KDO Op code: DRP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x0040f173 hdba: 0x004011c1
itli: 2 ispac: 0 maxfr: 4863
tabn: 1 slot: 0(0x0)
*-----------------------------
* Rec #0x15 slt: 0x2c objn: 576(0x00000240) objd: 576 tblspc: 0(0x00000000)
* Layer: 10 (Index) opc: 22 rci 0x14
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0005.01c.0000060b uba: 0x008044a6.0623.1c
flg: C--- lkc: 0 scn: 0x0000.002b6039
Dump kdilk : itl=2, kdxlkflg=0x1 sdc=0 indexid=0x4011d1 block=0x004011d4
(kdxlpu): purge leaf row
key :(7): 06 c5 09 21 3c 57 38
*-----------------------------
* Rec #0x16 slt: 0x2c objn: 577(0x00000241) objd: 577 tblspc: 0(0x00000000)
* Layer: 10 (Index) opc: 22 rci 0x15
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0005.01c.0000060b uba: 0x008044a6.0623.1e
flg: C--- lkc: 0 scn: 0x0000.002b6039
Dump kdilk : itl=2, kdxlkflg=0x1 sdc=0 indexid=0x4011d9 block=0x004011df
(kdxlpu): purge leaf row
key :(6): 05 c4 03 55 1c 2f
*-----------------------------
* Rec #0x17 slt: 0x2c objn: 575(0x0000023f) objd: 573 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x16
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0005.01c.0000060b uba: 0x008044a6.0623.1f
flg: C--- lkc: 0 scn: 0x0000.002b6039
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x0040f2a3 hdba: 0x004011c1
itli: 2 ispac: 0 maxfr: 4863
tabn: 1 slot: 3(0x3) flag: 0x6c lock: 0 ckix: 0
ncol: 8 nnew: 8 size: 204
col 0: [ 6] c5 08 3f 2c 27 1c
col 1: [ 7] 78 6f 09 15 0c 0b 1c
col 2: [ 1] 80
col 3: [ 5] c4 03 17 5f 35
col 4: [ 2] c2 02
col 5: [1200]
29 d1 71 2d 49 05 22 00 00 00 5d 0c 2c d1 71 2d 4d 05 22 00 00 00 ff bf 2f
d1 71 2d d8 05 22 00 00 00 73 09 35 d1 71 2d de 05 22 00 00 00 ff bf 38 d1
71 2d df 05 22 00 00 00 ff bf 3b d1 71 2d e0 05 22 00 00 00 ff bf 3e d1 71
2d e1 05 22 00 00 00 73 09 41 d1 71 2d e2 05 22 00 00 00 00 00 44 d1 71 2d
e3 05 22 00 00 00 93 08 47 d1 71 2d e4 05 22 00 00 00 c5 0a 4a d1 71 2d e5
05 22 00 00 00 ff bf 4d d1 71 2d e6 05 22 00 00 00 ff bf 50 d1 71 2d e7 05
22 00 00 00 73 09 53 d1 71 2d e8 05 22 00 00 00 73 09 56 d1 71 2d e9 05 22
00 00 00 00 00 59 d1 71 2d ea 05 22 00 00 00 00 00 5c d1 71 2d eb 05 22 00
00 00 73 09 5f d1 71 2d ee 05 22 00 00 00 73 09 65 d1 71 2d 07 06 22 00 00
00 ff bf 68 d1 71 2d 08 06 22 00 00 00 00 00 6b d1 71 2d 09 06 22 00 00 00
00 00 6e d1 71 2d 0a 06 22 00 00 00 00 00 71 d1 71 2d 0b 06 22 00 00 00 2c
b7 74 d1 71 2d 0c 06 22 00 00 00 bc 0c 77 d1 71 2d 0d 06 22 00 00 00 bc 0c
7a d1 71 2d 0e 06 22 00 00 00 bc 0c 7d d1 71 2d 0f 06 22 00 00 00 ff bf 80
d1 71 2d 10 06 22 00 00 00 ff bf 83 d1 71 2d 11 06 22 00 00 00 ff bf 86 d1
71 2d 12 06 22 00 00 00 00 00 89 d1 71 2d 13 06 22 00 00 00 ff bf 8c d1 71
2d 14 06 22 00 00 00 73 09 8f d1 71 2d 15 06 22 00 00 00 93 2a 92 d1 71 2d
16 06 22 00 00 00 00 00 95 d1 71 2d 17 06 22 00 00 00 00 00 98 d1 71 2d 18
06 22 00 00 00 00 00 9b d1 71 2d 19 06 22 00 00 00 00 00 9e d1 71 2d 1b 06
22 00 00 00 73 09 a4 d1 71 2d 22 06 22 00 00 00 00 00 a7 d1 71 2d 23 06 22
00 00 00 00 00 aa d1 71 2d 24 06 22 00 00 00 73 09 ad d1 71 2d 25 06 22 00
00 00 2d b7 b0 d1 71 2d 26 06 22 00 00 00 00 00 b3 d1 71 2d 27 06 22 00 00
00 3b 2c b6 d1 71 2d 28 06 22 00 00 00 00 00 b9 d1 71 2d 29 06 22 00 00 00
93 08 bc d1 71 2d 2a 06 22 00 00 00 00 00 bf d1 71 2d 2b 06 22 00 00 00 00
00 c2 d1 71 2d 2c 06 22 00 00 00 7e 2b c5 d1 71 2d 2d 06 22 00 00 00 00 00
c8 d1 71 2d 2e 06 22 00 00 00 00 00 ce d1 71 2d 26 09 22 00 00 00 f3 29 d1
d1 71 2d 27 09 22 00 00 00 00 00 d4 d1 71 2d 28 09 22 00 00 00 70 09 d7 d1
71 2d 29 09 22 00 00 00 34 2c dd d1 71 2d 2d 09 22 00 00 00 f3 29 e0 d1 71
2d 2e 09 22 00 00 00 bc 0c e6 d1 71 2d 35 09 22 00 00 00 40 02 e9 d1 71 2d
36 09 22 00 00 00 03 00 ec d1 71 2d 37 09 22 00 00 00 00 00 ef d1 71 2d 38
09 22 00 00 00 00 00 f2 d1 71 2d 39 09 22 00 00 00 00 00 f5 d1 71 2d 3a 09
22 00 00 00 00 00 f8 d1 71 2d 3b 09 22 00 00 00 00 00 fb d1 71 2d 3c 09 22
00 00 00 00 00 fe d1 71 2d 3d 09 22 00 00 00 ff ff 01 d2 71 2d 3e 09 22 00
00 00 00 00 04 d2 71 2d 3f 09 22 00 00 00 00 00 07 d2 71 2d 40 09 22 00 00
00 00 00 0a d2 71 2d 42 09 22 00 00 00 50 45 0d d2 71 2d 43 09 22 00 00 00
00 00 10 d2 71 2d 48 09 22 00 00 00 00 00 13 d2 71 2d 49 09 22 00 00 00 00
00 16 d2 71 2d 4a 09 22 00 00 00 00 00 19 d2 71 2d 4b 09 22 00 00 00 00 00
1c d2 71 2d 4c 09 22 00 00 00 00 00 1f d2 71 2d 4d 09 22 00 00 00 00 00 22
d2 71 2d 4e 09 22 00 00 00 00 00 28 d2 71 2d 55 09 22 00 00 00 70 09 2b d2
71 2d 58 09 22 00 00 00 00 00 2f d2 71 2d 59 09 22 00 00 00 00 00 32 d2 71
2d 5a 09 22 00 00 00 00 00 35 d2 71 2d 63 09 22 00 00 00 00 00 3b d2 71 2d
77 09 22 00 00 00 8b 2a 3e d2 71 2d 78 09 22 00 00 00 00 00 41 d2 71 2d 79
09 22 00 00 00 00 00 47 d2 71 2d 7e 09 22 00 00 00 00 bf 4a d2 71 2d 7f 09
22 00 00 00 00 00 4d d2 71 2d 80 09 22 00 00 00 00 00 50 d2 71 2d 81 09 22
00 00 00 00 00 53 d2 71 2d 82 09 22 00 00 00 00 00 56 d2 71 2d 83 09 22 00
00 00 83 2b 59 d2 71 2d 84 09 22 00 00 00 00 00 5c d2 71 2d 85 09 22 00 00
00 41 08 5f d2 71 2d 86 09 22 00 00 00 bf 0a 62 d2 71 2d 08 0a 22 00 00 00
ff bf 65 d2 71 2d a6 0d 22 00 00 00 3b 2c 69 d2 71 2d c9 10 22 00 00 00 3b
2c 6c d2 71 2d 2d 11 22 00 00 00 ff bf 6f d2 71 2d c9 11 22 00 00 00 00 00
col 6: [ 5] c4 03 17 5f 35
col 7: [ 1] 80
*-----------------------------
* Rec #0x18 slt: 0x2c objn: 576(0x00000240) objd: 576 tblspc: 0(0x00000000)
* Layer: 10 (Index) opc: 22 rci 0x17
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0005.01c.0000060b uba: 0x008044a6.0623.20
flg: C--- lkc: 0 scn: 0x0000.002b6039
Dump kdilk : itl=2, kdxlkflg=0x1 sdc=8 indexid=0x4011d1 block=0x004011d5
(kdxlre): restore leaf row (clear leaf delete flags)
key :(7): 06 c5 08 3f 2c 27 1c
keydata/bitmap: (6): 00 40 f2 a3 00 03
*-----------------------------
* Rec #0x19 slt: 0x2c objn: 576(0x00000240) objd: 576 tblspc: 0(0x00000000)
* Layer: 10 (Index) opc: 22 rci 0x18
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x02 ver: 0x01
op: C uba: 0x00800249.052a.15
Dump kdilk : itl=2, kdxlkflg=0x1 sdc=612499548 indexid=0x4011d1 block=0x004011d4
(kdxlpu): purge leaf row
key :(7): 06 c5 09 21 3c 5a 4d
*-----------------------------
* Rec #0x1a slt: 0x2c objn: 577(0x00000241) objd: 577 tblspc: 0(0x00000000)
* Layer: 10 (Index) opc: 22 rci 0x19
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0005.01c.0000060b uba: 0x008044a6.0623.21
flg: C--- lkc: 0 scn: 0x0000.002b6039
Dump kdilk : itl=2, kdxlkflg=0x1 sdc=7 indexid=0x4011d9 block=0x004011db
(kdxlre): restore leaf row (clear leaf delete flags)
key :(6): 05 c4 03 17 5f 35
keydata/bitmap: (6): 00 40 f2 a3 00 03
*-----------------------------
* Rec #0x1b slt: 0x2c objn: 577(0x00000241) objd: 577 tblspc: 0(0x00000000)
* Layer: 10 (Index) opc: 22 rci 0x1a
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x02 ver: 0x01
op: C uba: 0x00800249.052a.16
Dump kdilk : itl=2, kdxlkflg=0x1 sdc=612540508 indexid=0x4011d9 block=0x004011df
(kdxlpu): purge leaf row
key :(6): 05 c4 03 55 1d 56
*-----------------------------
* Rec #0x1c slt: 0x2c objn: 575(0x0000023f) objd: 573 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x1b
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0008.00a.00000600 uba: 0x008000ae.0441.26
flg: C--- lkc: 0 scn: 0x0000.002b5cf9
KDO Op code: IRP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x0040f29b hdba: 0x004011c1
itli: 2 ispac: 0 maxfr: 4863
tabn: 1 slot: 3(0x3) size/delt: 99
fb: -CH-FL-- lb: 0x0 cc: 8 cki: 0
null: --------
col 0: [ 6] c5 08 3f 2c 2a 3f
col 1: [ 7] 78 6f 09 15 0c 11 03
col 2: [ 1] 80
col 3: [ 5] c4 03 18 1c 5d
col 4: [ 2] c1 06
col 5: [60]
75 d2 71 2d da 11 22 00 00 00 5d 0c 78 d2 71 2d d5 12 22 00 00 00 ff bf 7b
d2 71 2d 25 14 22 00 00 00 73 09 7e d2 71 2d 3d 17 22 00 00 00 ff bf 81 d2
71 2d e8 19 22 00 00 00 ff bf
col 6: [ 5] c4 03 18 1c 5d
col 7: [ 1] 80
*-----------------------------
* Rec #0x1d slt: 0x2c objn: 576(0x00000240) objd: 576 tblspc: 0(0x00000000)
* Layer: 10 (Index) opc: 22 rci 0x1c
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x02 ver: 0x01
op: C uba: 0x00800249.052a.18
Dump kdilk : itl=2, kdxlkflg=0x1 sdc=8 indexid=0x4011d1 block=0x004011d5
(kdxlre): restore leaf row (clear leaf delete flags)
key :(7): 06 c5 08 3f 2c 2a 3f
keydata/bitmap: (6): 00 40 f2 9b 00 03
*-----------------------------
* Rec #0x1e slt: 0x2c objn: 577(0x00000241) objd: 577 tblspc: 0(0x00000000)
* Layer: 10 (Index) opc: 22 rci 0x1d
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x02 ver: 0x01
op: C uba: 0x00800249.052a.1a
Dump kdilk : itl=2, kdxlkflg=0x1 sdc=7 indexid=0x4011d9 block=0x004011db
(kdxlre): restore leaf row (clear leaf delete flags)
key :(6): 05 c4 03 18 1c 5d
keydata/bitmap: (6): 00 40 f2 9b 00 03
*-----------------------------
* Rec #0x1f slt: 0x2e objn: 8779(0x0000224b) objd: 8779 tblspc: 2(0x00000002)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
uba: 0x00800249.052a.14 ctl max scn: 0x0000.002b5cf7 prv tx scn: 0x0000.002b5d02
txn start scn: scn: 0x0000.002b61d7 logon user: 0
prev brb: 8389191 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0005.029.0000060a uba: 0x008044a7.0623.16
flg: C--- lkc: 0 scn: 0x0000.002b61b9
KDO Op code: DRP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x00c00a65 hdba: 0x00c00a63
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 3(0x3)
*-----------------------------
* Rec #0x20 slt: 0x2e objn: 8780(0x0000224c) objd: 8780 tblspc: 2(0x00000002)
* Layer: 10 (Index) opc: 22 rci 0x1f
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0004.00c.000005b2 uba: 0x00800023.0427.2d
flg: C--- lkc: 0 scn: 0x0000.002b61d6
Dump kdilk : itl=2, kdxlkflg=0x1 sdc=180352046 indexid=0xc00a6b block=0x00c00a6c
(kdxlpu): purge leaf row
key :(12): 03 c2 02 16 02 c1 05 01 80 02 c1 02
*-----------------------------
* Rec #0x21 slt: 0x2e objn: 8786(0x00002252) objd: 8786 tblspc: 2(0x00000002)
* Layer: 11 (Row) opc: 1 rci 0x20
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0005.029.0000060a uba: 0x008044a7.0623.1a
flg: C--- lkc: 0 scn: 0x0000.002b61b9
KDO Op code: DRP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x00c08949 hdba: 0x00c00a83
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 2(0x2)
*-----------------------------
* Rec #0x22 slt: 0x2e objn: 8789(0x00002255) objd: 8789 tblspc: 2(0x00000002)
* Layer: 10 (Index) opc: 22 rci 0x21
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0004.00c.000005b2 uba: 0x00800023.0427.31
flg: C--- lkc: 0 scn: 0x0000.002b61d6
Dump kdilk : itl=2, kdxlkflg=0x1 sdc=-1073826568 indexid=0xc00a9b block=0x00c07636
(kdxlpu): purge leaf row
key :(17): 10 ec 20 60 c7 8e b0 88 da e0 40 a8 c0 6e 01 0a 2b
*-----------------------------
* Rec #0x23 slt: 0x2e objn: 8803(0x00002263) objd: 8803 tblspc: 2(0x00000002)
* Layer: 10 (Index) opc: 22 rci 0x22
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0004.00c.000005b2 uba: 0x00800023.0427.32
flg: C--- lkc: 0 scn: 0x0000.002b61d6
Dump kdilk : itl=2, kdxlkflg=0x1 sdc=213658176 indexid=0xc00ad3 block=0x00c082df
(kdxlpu): purge leaf row
key :(42):
02 c1 2a 01 30 01 80 0b 78 71 0b 1a 17 25 11 10 5b d9 d8 01 80 01 80 01 80
10 ec 20 60 c7 8e b0 88 da e0 40 a8 c0 6e 01 0a 2b
*-----------------------------
* Rec #0x24 slt: 0x2e objn: 8798(0x0000225e) objd: 8798 tblspc: 2(0x00000002)
* Layer: 10 (Index) opc: 22 rci 0x23
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0005.029.0000060a uba: 0x008044a7.0623.1d
flg: C--- lkc: 0 scn: 0x0000.002b61b9
Dump kdilk : itl=2, kdxlkflg=0x1 sdc=8803 indexid=0xc00abb block=0x00c00cd5
(kdxlpu): purge leaf row
key :(24):
10 ec 20 60 c7 8e b0 88 da e0 40 a8 c0 6e 01 0a 2b 02 c1 2a 01 30 01 80
*-----------------------------
* Rec #0x25 slt: 0x2e objn: 8796(0x0000225c) objd: 8796 tblspc: 2(0x00000002)
* Layer: 10 (Index) opc: 22 rci 0x24
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0005.029.0000060a uba: 0x008044a7.0623.1e
flg: C--- lkc: 0 scn: 0x0000.002b61b9
Dump kdilk : itl=3, kdxlkflg=0x1 sdc=1 indexid=0xc00ab3 block=0x00c08730
(kdxlpu): purge leaf row
key :(40):
0b 78 71 0c 03 17 25 11 10 5b d9 d8 0a 31 30 2e 34 36 2e 31 34 36 32 10 ec
20 60 c7 8e b0 88 da e0 40 a8 c0 6e 01 0a 2b
*-----------------------------
* Rec #0x26 slt: 0x0f objn: 51148(0x0000c7cc) objd: 51148 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
uba: 0x00800249.052a.1f ctl max scn: 0x0000.002b5d02 prv tx scn: 0x0000.002b5d0c
txn start scn: scn: 0x0000.002b6223 logon user: 54
prev brb: 8389191 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0008.01d.0000051c uba: 0x00800506.03cb.33
flg: C--- lkc: 0 scn: 0x0000.00244c6b
Array Update of 14 rows:
tabn: 0 slot: 0(0x0) flag: 0x2c lock: 0 ckix: 183
ncol: 8 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x01000020 hdba: 0x0100001b
itli: 2 ispac: 0 maxfr: 4858
vect = 28
col 5: [ 2] c2 0c
tabn: 0 slot: 1(0x1) flag: 0x2c lock: 0 ckix: 183
ncol: 8 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x01000020 hdba: 0x0100001b
itli: 2 ispac: 0 maxfr: 4858
vect = 31
col 5: [ 2] c2 12
tabn: 0 slot: 2(0x2) flag: 0x2c lock: 0 ckix: 183
ncol: 8 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x01000020 hdba: 0x0100001b
itli: 2 ispac: 0 maxfr: 4858
vect = 30
col 5: [ 3] c2 0e 33
tabn: 0 slot: 3(0x3) flag: 0x2c lock: 0 ckix: 183
ncol: 8 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x01000020 hdba: 0x0100001b
itli: 2 ispac: 0 maxfr: 4858
vect = 30
col 5: [ 3] c2 1f 4c
tabn: 0 slot: 4(0x4) flag: 0x2c lock: 0 ckix: 183
ncol: 8 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x01000020 hdba: 0x0100001b
itli: 2 ispac: 0 maxfr: 4858
vect = 32
col 5: [ 3] c2 0e 33
tabn: 0 slot: 5(0x5) flag: 0x2c lock: 0 ckix: 183
ncol: 8 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x01000020 hdba: 0x0100001b
itli: 2 ispac: 0 maxfr: 4858
vect = 30
col 5: [ 3] c2 1e 33
tabn: 0 slot: 6(0x6) flag: 0x2c lock: 0 ckix: 183
ncol: 8 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x01000020 hdba: 0x0100001b
itli: 2 ispac: 0 maxfr: 4858
vect = 30
col 5: [ 3] c2 1a 33
tabn: 0 slot: 7(0x7) flag: 0x2c lock: 0 ckix: 183
ncol: 8 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x01000020 hdba: 0x0100001b
itli: 2 ispac: 0 maxfr: 4858
vect = 30
col 5: [ 2] c2 20
tabn: 0 slot: 8(0x8) flag: 0x2c lock: 0 ckix: 183
ncol: 8 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x01000020 hdba: 0x0100001b
itli: 2 ispac: 0 maxfr: 4858
vect = 28
col 5: [ 2] c2 34
tabn: 0 slot: 9(0x9) flag: 0x2c lock: 0 ckix: 183
ncol: 8 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x01000020 hdba: 0x0100001b
itli: 2 ispac: 0 maxfr: 4858
vect = 32
col 5: [ 2] c2 11
tabn: 0 slot: 10(0xa) flag: 0x2c lock: 0 ckix: 183
ncol: 8 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x01000020 hdba: 0x0100001b
itli: 2 ispac: 0 maxfr: 4858
vect = 28
col 5: [ 2] c2 0d
tabn: 0 slot: 11(0xb) flag: 0x2c lock: 0 ckix: 183
ncol: 8 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x01000020 hdba: 0x0100001b
itli: 2 ispac: 0 maxfr: 4858
vect = 27
col 5: [ 3] c2 0b 33
tabn: 0 slot: 12(0xc) flag: 0x2c lock: 0 ckix: 183
ncol: 8 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x01000020 hdba: 0x0100001b
itli: 2 ispac: 0 maxfr: 4858
vect = 29
col 5: [ 2] c2 20
tabn: 0 slot: 13(0xd) flag: 0x2c lock: 0 ckix: 183
ncol: 8 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x01000020 hdba: 0x0100001b
itli: 2 ispac: 0 maxfr: 4858
vect = 29
col 5: [ 2] c2 0f
End dump data blocks tsn: 1 file#: 2 minblk 585 maxblk 585
[size=small]老规矩打开Oracle 10g的帮助文档 "Most Popular" ->"Reference" 选择HTML->"7 Dynamic Performance (V$) Views: V$NLS_PARAMETERS to V$XML_AUDIT_TRAIL" ->
点击"V$TRANSACTION"链接，进入官方对该动态性能视图的解释。[/size]
[size=small][b]
首先"V$TRANSACTION" 的作用[/b][/size]
[size=small]V$TRANSACTION 列出当前数据库系统中的活动事务,其实就是监控当前数据库系统正在执行的事务[/size]
[size=small][b]观注各列字段的含意[/b][/size]
列名 数据类型 含义
ADDR RAW(4|8) Address of the transaction state object
XIDUSN NUMBER 使用的回滚段号,可以和v$rollstat对应
XIDSLOT NUMBER RBS TX 表中的槽号 USN.SLOT.SQN
XIDSQN NUMBER 序列号，TX-USNxSLOT-SQNxxxxx
UBAFIL NUMBER 最后一个撤销块地址所在的文件号
UBABLK NUMBER UBA 块号
UBASQN NUMBER UBA 序列号
UBAREC NUMBER UBA 记录号
STATUS VARCHAR2(16) 当前事务的状态
START_TIME VARCHAR2(20) Start time (wall clock)
START_SCNB NUMBER 开始的系统改变号
START_SCNW NUMBER Start SCN wrap
START_UEXT NUMBER Start extent number
START_UBAFIL NUMBER Start UBA file number
START_UBABLK NUMBER Start UBA block number
START_UBASQN NUMBER Start UBA sequence number
START_UBAREC NUMBER Start UBA record number
SES_ADDR RAW(4|8) 用户会话对象地址，对v$session 的saddr列
FLAG NUMBER Flag
SPACE VARCHAR2(3) YES if a space transaction
RECURSIVE VARCHAR2(3) YES if a recursive transaction
NOUNDO VARCHAR2(3) YES if a no undo transaction
PTX VARCHAR 2(3) YES if parallel transaction
NAME VARCHAR2(256) Name of a named transaction
PRV_XIDUSN NUMBER Previous transaction undo segment number
PRV_XIDSLT NUMBER Previous transaction slot number
PRV_XIDSQN NUMBER Previous transaction sequence number
PTX_XIDUSN NUMBER Rollback segment number of the parent XID
PTX_XIDSLT NUMBER Slot number of the parent XID
PTX_XIDSQN NUMBER Sequence number of the parent XID
DSCN-B NUMBER This column is obsolete and maintained for backward compatibility. The value of this column is always equal to the value in DSCN_BASE.
DSCN-W NUMBER This column is obsolete and maintained for backward compatibility. The value of this column is always equal to the value in DSCN_WRAP.
USED_UBLK NUMBER 已占用的undo 块数
USED_UREC NUMBER 已使用的undo 记录数
LOG_IO NUMBER 逻辑 I/O
PHY_IO NUMBER 物理 I/O
CR_GET NUMBER 一致读的次数
CR_CHANGE NUMBER Consistent changes
START_DATE DATE Start time (wall clock)
DSCN_BASE NUMBER Dependent SCN base
DSCN_WRAP NUMBER Dependent SCN wrap
START_SCN NUMBER Start SCN
DEPENDENT_SCN NUMBER Dependent SCN
XID RAW(8) Transaction XID
PRV_XID RAW(8) Previous transaction XID
PTX_XID RAW(8) Parent transaction XID
[size=small][b]示例了解该动态性能视图[/b][/size]
[size=small][b]准备测试表[/b][/size]SQL> DESC T1; //数据量级是百万记录的一张表
Name Null? Type
----------------------------------------- -------- ---------------------
ID NUMBER
OWNER NOT NULL VARCHAR2(30)
OBJECT_NAME NOT NULL VARCHAR2(30)
SUBOBJECT_NAME VARCHAR2(30)
OBJECT_ID NOT NULL NUMBER
DATA_OBJECT_ID NUMBER
OBJECT_TYPE VARCHAR2(19)
CREATED NOT NULL DATE
LAST_DDL_TIME NOT NULL DATE
TIMESTAMP VARCHAR2(19)
STATUS VARCHAR2(7)
TEMPORARY VARCHAR2(1)
GENERATED VARCHAR2(1)
SECONDARY VARCHAR2(1)
[b][size=small]使用UPDATE 语句更新这张表[/size][/b]
SQL> update t1 set owner='loris';
[b][size=small]查询该更新事务信息[/size][/b]
SYS@ orcl>select xid,xidusn,xidslot,xidsqn,start_time,start_scnb,used_ublk,used_urec,log_io,phy_io from v$transaction;
XID XIDUSN XIDSLOT XIDSQN START_TIME START_SCNB USED_UBLK USED_UREC LOG_IO PHY_IO
---------------- ---------- ---------- ---------- -------------------- ---------- ---------- ---------- ---------- ----------
07002900AE050000 7 41 1454 11/27/13 10:50:33 0 0 0 2 0
0500090008060000 5 9 1544 11/27/13 10:47:00 2804989 12369 1312538 4069121 34370
隔了5分钟再查一次
XID XIDUSN XIDSLOT XIDSQN START_TIME START_SCNB USED_UBLK USED_UREC LOG_IO PHY_IO
---------------- ---------- ---------- ---------- -------------------- ---------- ---------- ---------- ---------- ----------
0500090008060000 5 9 1544 11/27/13 10:47:00 2804989 14582 1496747 4635250 40912
03002500FE050000 3 37 1534 11/27/13 10:55:19 0 0 0 2 0
02001B00F6050000 2 27 1526 11/27/13 10:55:19 2832534 1 2 10 0
[size=small][b]
联合v$session 再查一次，这样就知道是哪个用户的哪些事务了，进而可以跟踪到sql[/b][/size]
[size=small][b]注：used_urec 字段不断增加，说明该事物正在继续，如果该字段不断下降，说明该事物正在回滚[/b][/size]
SYS@ orcl>select b.sid,b.username,xid,a.status,start_time,used_ublk,used_urec,log_io,phy_io from v$transaction a,v$session b where a.ses_addr = b.saddr;
[size=small][b]事务进阶 [/b] [/size]
一个事务的活动信息是保存在undo 段中，V$TRANSACTION事务表中的
[b]XID由XIDUSN.XIDSLOT.XIDSQN组成 ，如xid: 0x000a.00f.000005b5 10.15.1461[/b]
SYS@ orcl>select xid,xidusn,cr_get,used_ublk,used_urec,ubafil,log_io,phy_io,status from v$transaction;
XID XIDUSN CR_GET USED_UBLK USED_UREC UBAFIL LOG_IO PHY_IO STATUS
---------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ----------------
0A000F00B5050000 10 7 1 1 2 5 0 ACTIVE
[size=x-small][b]Oracle 在undo段的第一个数据块，回滚段头块存放事务信息 也就是有一个数据结构—事务表[/b][/size]SYS@ orcl>select name from v$rollname where usn=10;
NAME
------------------------------
_SYSSMU10$
[size=small][b]dump回滚段头: [/b][/size]
SYS@ orcl>alter system dump undo header '_SYSSMU10$'
2 ;
System altered.
在数据库udump目录下，可以找到dump出来的文件
********************************************************************************
Undo Segment: _SYSSMU10$ (10)
********************************************************************************
Extent Control Header
-----------------------------------------------------------------
Extent Header:: spare1: 0 spare2: 0 #extents: 3 #blocks: 143
last map 0x00000000 #maps: 0 offset: 4080
Highwater:: 0x00800249 ext#: 2 blk#: 64 ext size: 128
#blocks in seg. hdr's freelists: 0
#blocks below: 0
mapblk 0x00000000 offset: 2
Unlocked
Map Header:: next 0x00000000 #extents: 3 obj#: 0 flag: 0x40000000
Extent Map
-----------------------------------------------------------------
0x0080009a length: 7
0x00801b29 length: 8
0x00800209 length: 128
Retention Table
-----------------------------------------------------------
Extent Number:0 Commit Time: 1385439155
Extent Number:1 Commit Time: 1385439155
Extent Number:2 Commit Time: 1385439155
TRN CTL:: seq: 0x052a chd: 0x0005 ctl: 0x002e inc: 0x00000000 nfb: 0x0000
mgc: 0x8201 xts: 0x0068 flg: 0x0001 opt: 2147483646 (0x7ffffffe)
uba: 0x00800249.052a.26 scn: 0x0000.002b5d0c
Version: 0x01
FREE BLOCK POOL::
uba: 0x00000000.052a.25 ext: 0x2 spc: 0x960
uba: 0x00000000.052a.01 ext: 0x2 spc: 0x1f88
uba: 0x00000000.052a.01 ext: 0x2 spc: 0x1f88
uba: 0x00000000.052a.01 ext: 0x2 spc: 0x1f88
uba: 0x00000000.0000.00 ext: 0x0 spc: 0x0
TRN TBL::
index state cflags wrap# uel scn dba parent-xid nub stmt_num cmt
------------------------------------------------------------------------------------------------
0x00 9 0x00 0x05b7 0x0023 0x0000.002b5d7b 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x01 9 0x00 0x05b5 0x0000 0x0000.002b5d71 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x02 9 0x00 0x05b7 0x0027 0x0000.002b6077 0x00800248 0x0000.000.00000000 0x00000001 0x00000000 1385529850
0x03 9 0x00 0x05b6 0x001f 0x0000.002b5d48 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x04 9 0x00 0x05b7 0x0002 0x0000.002b606e 0x00800248 0x0000.000.00000000 0x00000001 0x00000000 1385529850
0x05 9 0x00 0x05b6 0x0024 0x0000.002b5d16 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x06 9 0x00 0x05b7 0x002c 0x0000.002b6163 0x00800249 0x0000.000.00000000 0x00000001 0x00000000 1385530335
0x07 9 0x00 0x05b7 0x0017 0x0000.002b5e82 0x00800248 0x0000.000.00000000 0x00000001 0x00000000 1385528946
0x08 9 0x00 0x05b5 0x000b 0x0000.002b5dc2 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x09 9 0x00 0x05b6 0x0019 0x0000.002b5d5c 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x0a 9 0x00 0x05b6 0x0028 0x0000.002b5fbf 0x00800248 0x0000.000.00000000 0x00000001 0x00000000 1385529597
0x0b 9 0x00 0x05b5 0x0029 0x0000.002b5dcc 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x0c 9 0x00 0x05b7 0x0026 0x0000.002b6108 0x00800248 0x0000.000.00000000 0x00000001 0x00000000 1385530182
0x0d 9 0x00 0x05b4 0x001e 0x0000.002b5d8f 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x0e 9 0x00 0x05b6 0x002d 0x0000.002b6020 0x00800248 0x0000.000.00000000 0x00000001 0x00000000 1385529791
[color=red][b][size=small] 0x0f 10 0x80 0x05b5 0x0002 0x0000.002b6223 0x00800249 0x0000.000.00000000 0x00000001 0x00000000 0[/size][/b][/color] 0x10 9 0x00 0x05b6 0x0006 0x0000.002b6136 0x00800249 0x0000.000.00000000 0x00000001 0x00000000 1385530248
0x11 9 0x00 0x05b3 0x000a 0x0000.002b5f9b 0x00800248 0x0000.000.00000000 0x00000001 0x00000000 1385529532
0x12 9 0x00 0x05b7 0x001a 0x0000.002b6049 0x00800248 0x0000.000.00000000 0x00000001 0x00000000 1385529850
0x13 9 0x00 0x05b6 0x0008 0x0000.002b5db8 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x14 9 0x00 0x05b6 0x002b 0x0000.002b5f0b 0x00800248 0x0000.000.00000000 0x00000001 0x00000000 1385529206
0x15 9 0x00 0x05b6 0x0007 0x0000.002b5e58 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528881
0x16 9 0x00 0x05b5 0x0004 0x0000.002b6065 0x00800248 0x0000.000.00000000 0x00000001 0x00000000 1385529850
0x17 9 0x00 0x05b6 0x0018 0x0000.002b5e93 0x00800248 0x0000.000.00000000 0x00000001 0x00000000 1385528954
0x18 9 0x00 0x05b6 0x0014 0x0000.002b5ecd 0x00800248 0x0000.000.00000000 0x00000001 0x00000000 1385529076
0x19 9 0x00 0x05b6 0x0001 0x0000.002b5d67 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x1a 9 0x00 0x05b3 0x001b 0x0000.002b6053 0x00800248 0x0000.000.00000000 0x00000001 0x00000000 1385529850
0x1b 9 0x00 0x05b4 0x0016 0x0000.002b605c 0x00800248 0x0000.000.00000000 0x00000001 0x00000000 1385529850
0x1c 9 0x00 0x05b6 0x0025 0x0000.002b5da4 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x1d 9 0x00 0x05b3 0x0003 0x0000.002b5d3e 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x1e 9 0x00 0x05b5 0x001c 0x0000.002b5d9a 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x1f 9 0x00 0x05b4 0x0009 0x0000.002b5d52 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x20 9 0x00 0x05b4 0x001d 0x0000.002b5d34 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x21 9 0x00 0x05b5 0x002f 0x0000.002b5dea 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x22 9 0x00 0x05b5 0x0020 0x0000.002b5d2a 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x23 9 0x00 0x05b5 0x000d 0x0000.002b5d85 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x24 9 0x00 0x05b6 0x0022 0x0000.002b5d20 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x25 9 0x00 0x05b5 0x0013 0x0000.002b5dae 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x26 9 0x00 0x05b5 0x0010 0x0000.002b612d 0x00800249 0x0000.000.00000000 0x00000002 0x00000000 1385530248
0x27 9 0x00 0x05b5 0x000c 0x0000.002b60b7 0x00800248 0x0000.000.00000000 0x00000001 0x00000000 1385529987
0x28 9 0x00 0x05b5 0x000e 0x0000.002b5fc9 0x00800248 0x0000.000.00000000 0x00000001 0x00000000 1385529597
0x29 9 0x00 0x05b5 0x002a 0x0000.002b5dd6 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x2a 9 0x00 0x05b5 0x0021 0x0000.002b5de0 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528650
0x2b 9 0x00 0x05b6 0x0011 0x0000.002b5f5f 0x00800248 0x0000.000.00000000 0x00000001 0x00000000 1385529401
0x2c 9 0x00 0x05b5 0x002e 0x0000.002b619a 0x00800249 0x0000.000.00000000 0x00000001 0x00000000 1385530450
0x2d 9 0x00 0x05b5 0x0012 0x0000.002b6040 0x00800248 0x0000.000.00000000 0x00000001 0x00000000 1385529850
0x2e 9 0x00 0x05b6 0xffff 0x0000.002b61d8 0x00800249 0x0000.000.00000000 0x00000001 0x00000000 1385530576
0x2f 9 0x00 0x05b5 0x0015 0x0000.002b5e01 0x00800247 0x0000.000.00000000 0x00000001 0x00000000 1385528684
[size=small][b]dump回滚块[/b][/size]
YS@ orcl>select xid,xidusn,cr_get,used_ublk,used_urec,ubafil,ubablk,ubasqn,log_io,phy_io,status from v$transaction;
XID XIDUSN CR_GET USED_UBLK USED_UREC UBAFIL UBABLK UBASQN LOG_IO PHY_IO STATUS
---------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ----------------
0A000F00B5050000 10 7 1 1 2 585 1322 5 0 ACTIVE
SYS@ orcl>alter system dump datafile 2 block 585;
System altered.
Start dump data blocks tsn: 1 file#: 2 minblk 585 maxblk 585
buffer tsn: 1 rdba: 0x00800249 (2/585)
scn: 0x0000.002b6223 seq: 0x01 flg: 0x04 tail: 0x62230201
frmt: 0x02 chkval: 0x94e2 type: 0x02=KTU UNDO BLOCK
Hex dump of block: st=0, typ_found=1
Dump of memory from 0x0CC2B600 to 0x0CC2D600
CC2B600 0000A202 00800249 002B6223 04010000 [....I...#b+.....]
CC2B610 000094E2 000F000A 000005B5 2626052A [............*.&&]
CC2B620 1FE80000 1EF01F64 1DE01E64 1CE01D54 [....d...d...T...]
CC2B630 1BD01C5C 1AC01B4C 19A41A3C 18BC1920 [\...L...<... ...]
省略部分，重点在如下部分
********************************************************************************
UNDO BLK:
xid: 0x000a.00f.000005b5 seq: 0x52a cnt: 0x26 irb: 0x26 icl: 0x0 flg: 0x0000
Rec Offset Rec Offset Rec Offset Rec Offset Rec Offset
---------------------------------------------------------------------------
0x01 0x1f64 0x02 0x1ef0 0x03 0x1e64 0x04 0x1de0 0x05 0x1d54
0x06 0x1ce0 0x07 0x1c5c 0x08 0x1bd0 0x09 0x1b4c 0x0a 0x1ac0
0x0b 0x1a3c 0x0c 0x19a4 0x0d 0x1920 0x0e 0x18bc 0x0f 0x1868
0x10 0x17fc 0x11 0x1778 0x12 0x1708 0x13 0x1688 0x14 0x1604
0x15 0x15a4 0x16 0x1544 0x17 0x0fe4 0x18 0x0f7c 0x19 0x0f2c
0x1a 0x0ec4 0x1b 0x0e74 0x1c 0x0d88 0x1d 0x0d30 0x1e 0x0cd8
0x1f 0x0c54 0x20 0x0bf0 0x21 0x0b9c 0x22 0x0b30 0x23 0x0aac
0x24 0x0a3c 0x25 0x09bc 0x26 0x0724
*-----------------------------
* Rec #0x1 slt: 0x26 objn: 49948(0x0000c31c) objd: 49948 tblspc: 2(0x00000002)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00800248
*-----------------------------
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0009.029.0000061b uba: 0x008000da.05b9.0c
flg: C--- lkc: 0 scn: 0x0000.002b6128
Array Update of 1 rows:
tabn: 0 slot: 4(0x4) flag: 0x2c lock: 0 ckix: 191
ncol: 12 nnew: 2 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x00c05be8 hdba: 0x00c05be3
itli: 1 ispac: 0 maxfr: 4858
vect = 74
col 9: [ 1] 80
col 10: [ 1] 80
*-----------------------------
* Rec #0x2 slt: 0x26 objn: 49871(0x0000c2cf) objd: 49871 tblspc: 2(0x00000002)
* Layer: 10 (Index) opc: 22 rci 0x01
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x02 ver: 0x01
op: C uba: 0x00800248.052a.36
Dump kdilk : itl=2, kdxlkflg=0x41 sdc=1 indexid=0xc059ab block=0x00c0758b
(kdxlpu): purge leaf row
key :(44):
10 0c 48 c5 ae 0f af b4 2e d9 1f 89 7f f3 98 fc 84 10 7b 53 ef 40 72 c3 ee
d7 df a5 46 74 a4 4e a7 77 01 20 07 78 71 0b 1b 0e 1f 31
*-----------------------------
* Rec #0x3 slt: 0x26 objn: 49874(0x0000c2d2) objd: 49874 tblspc: 2(0x00000002)
* Layer: 10 (Index) opc: 22 rci 0x02
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x02 ver: 0x01
op: C uba: 0x00800248.052a.37
Dump kdilk : itl=2, kdxlkflg=0x51 sdc=4 indexid=0xc059bb block=0x00c059bf
(kdxlcnu): column-vector nonkey update
ncol: 2 nnew: 2 size: 0 flag: 0x02
key :(36):
10 0c 48 c5 ae 0f af b4 2e d9 1f 89 7f f3 98 fc 84 10 7b 53 ef 40 72 c3 ee
d7 df a5 46 74 a4 4e a7 77 01 20
nonkey columns updated:
col 0: [ 7] 78 71 0b 1b 0e 14 3a
col 1: [ 1] 80
*-----------------------------
* Rec #0x4 slt: 0x26 objn: 49871(0x0000c2cf) objd: 49871 tblspc: 2(0x00000002)
* Layer: 10 (Index) opc: 22 rci 0x03
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0003.009.00000602 uba: 0x00804511.0520.36
flg: C--- lkc: 0 scn: 0x0000.002b5fc6
Dump kdilk : itl=2, kdxlkflg=0x41 sdc=0 indexid=0xc059ab block=0x00c0758a
(kdxlpu): purge leaf row
key :(44):
10 0c 48 c5 ae 0f af b4 2e d9 1f 89 7f f3 98 fc 84 10 3d 47 f6 fd 64 c9 16
90 e0 d9 09 07 8c 14 9e bc 01 20 07 78 71 0b 1b 0e 1f 31
*-----------------------------
* Rec #0x5 slt: 0x26 objn: 49874(0x0000c2d2) objd: 49874 tblspc: 2(0x00000002)
* Layer: 10 (Index) opc: 22 rci 0x04
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x02 ver: 0x01
op: C uba: 0x00800249.052a.03
Dump kdilk : itl=2, kdxlkflg=0x51 sdc=4 indexid=0xc059bb block=0x00c059bf
(kdxlcnu): column-vector nonkey update
ncol: 2 nnew: 2 size: 0 flag: 0x02
key :(36):
10 0c 48 c5 ae 0f af b4 2e d9 1f 89 7f f3 98 fc 84 10 3d 47 f6 fd 64 c9 16
90 e0 d9 09 07 8c 14 9e bc 01 20
nonkey columns updated:
col 0: [ 7] 78 71 0b 1b 0e 14 3a
col 1: [ 1] 80
*-----------------------------
* Rec #0x6 slt: 0x26 objn: 49948(0x0000c31c) objd: 49948 tblspc: 2(0x00000002)
* Layer: 11 (Row) opc: 1 rci 0x05
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
op: C uba: 0x00800249.052a.01
Array Update of 1 rows:
tabn: 0 slot: 5(0x5) flag: 0x2c lock: 0 ckix: 191
ncol: 12 nnew: 2 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x00c05be8 hdba: 0x00c05be3
itli: 1 ispac: 0 maxfr: 4858
vect = 77
col 9: [ 1] 80
col 10: [ 1] 80
*-----------------------------
* Rec #0x7 slt: 0x26 objn: 49871(0x0000c2cf) objd: 49871 tblspc: 2(0x00000002)
* Layer: 10 (Index) opc: 22 rci 0x06
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0009.029.0000061b uba: 0x008000da.05b9.15
flg: C--- lkc: 0 scn: 0x0000.002b6128
Dump kdilk : itl=2, kdxlkflg=0x41 sdc=0 indexid=0xc059ab block=0x00c07b1e
(kdxlpu): purge leaf row
key :(44):
10 0c 48 c5 ae 0f af b4 2e d9 1f 89 7f f3 98 fc 84 10 a7 1c cd f9 ae 28 aa
9e 04 11 ef 94 b8 5b 6c 13 01 20 07 78 71 0b 1b 0e 1f 31
*-----------------------------
* Rec #0x8 slt: 0x26 objn: 49874(0x0000c2d2) objd: 49874 tblspc: 2(0x00000002)
* Layer: 10 (Index) opc: 22 rci 0x07
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x02 ver: 0x01
op: C uba: 0x00800249.052a.05
Dump kdilk : itl=2, kdxlkflg=0x51 sdc=4 indexid=0xc059bb block=0x00c059bf
(kdxlcnu): column-vector nonkey update
ncol: 2 nnew: 2 size: 0 flag: 0x02
key :(36):
10 0c 48 c5 ae 0f af b4 2e d9 1f 89 7f f3 98 fc 84 10 a7 1c cd f9 ae 28 aa
9e 04 11 ef 94 b8 5b 6c 13 01 20
nonkey columns updated:
col 0: [ 7] 78 71 0b 1b 0e 14 3a
col 1: [ 1] 80
*-----------------------------
* Rec #0x9 slt: 0x26 objn: 49871(0x0000c2cf) objd: 49871 tblspc: 2(0x00000002)
* Layer: 10 (Index) opc: 22 rci 0x08
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0009.029.0000061b uba: 0x008000da.05b9.1f
flg: C--- lkc: 0 scn: 0x0000.002b6128
Dump kdilk : itl=2, kdxlkflg=0x41 sdc=0 indexid=0xc059ab block=0x00c07b1a
(kdxlpu): purge leaf row
key :(44):
10 0c 48 c5 ae 0f af b4 2e d9 1f 89 7f f3 98 fc 84 10 58 cf 07 a4 d5 f7 ef
85 e1 dd 63 23 a0 c9 52 31 01 20 07 78 71 0b 1b 0e 1f 31
*-----------------------------
* Rec #0xa slt: 0x26 objn: 49874(0x0000c2d2) objd: 49874 tblspc: 2(0x00000002)
* Layer: 10 (Index) opc: 22 rci 0x09
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x02 ver: 0x01
op: C uba: 0x00800249.052a.08
Dump kdilk : itl=2, kdxlkflg=0x51 sdc=4 indexid=0xc059bb block=0x00c059bf
(kdxlcnu): column-vector nonkey update
ncol: 2 nnew: 2 size: 0 flag: 0x02
key :(36):
10 0c 48 c5 ae 0f af b4 2e d9 1f 89 7f f3 98 fc 84 10 58 cf 07 a4 d5 f7 ef
85 e1 dd 63 23 a0 c9 52 31 01 20
nonkey columns updated:
col 0: [ 7] 78 71 0b 1b 0e 14 3a
col 1: [ 1] 80
*-----------------------------
* Rec #0xb slt: 0x10 objn: 50291(0x0000c473) objd: 50291 tblspc: 2(0x00000002)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
uba: 0x00800248.052a.34 ctl max scn: 0x0000.002b5c7b prv tx scn: 0x0000.002b5c8a
txn start scn: scn: 0x0000.002b6135 logon user: 51
prev brb: 8389191 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0009.005.0000061b uba: 0x008000da.05b9.23
flg: C--- lkc: 0 scn: 0x0000.002b6132
KDO Op code: DRP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x00c0664f hdba: 0x00c0664b
itli: 1 ispac: 0 maxfr: 4858
tabn: 0 slot: 108(0x6c)
*-----------------------------
* Rec #0xc slt: 0x10 objn: 50493(0x0000c53d) objd: 50493 tblspc: 2(0x00000002)
* Layer: 10 (Index) opc: 22 rci 0x0b
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0004.020.000005b0 uba: 0x00800022.0427.30
flg: C--- lkc: 0 scn: 0x0000.002b5fc7
Dump kdilk : itl=2, kdxlkflg=0x41 sdc=0 indexid=0xc06c5b block=0x00c06c5d
(kdxlpu): purge leaf row
key :(63):
23 45 4d 44 5f 43 4f 4c 4c 45 43 54 49 4f 4e 2e 43 6f 6c 6c 65 63 74 69 6f
6e 20 53 75 62 73 79 73 74 65 6d 07 78 71 0b 1b 0e 1f 31 0b 43 6f 6c 6c 65
63 74 69 6f 6e 73 06 00 c0 66 4f 00 6c
*-----------------------------
* Rec #0xd slt: 0x06 objn: 8779(0x0000224b) objd: 8779 tblspc: 2(0x00000002)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
uba: 0x00800249.052a.0b ctl max scn: 0x0000.002b5c8a prv tx scn: 0x0000.002b5cc0
txn start scn: scn: 0x0000.002b6162 logon user: 0
prev brb: 8389191 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0005.018.0000060b uba: 0x008044a6.0623.2d
flg: C--- lkc: 0 scn: 0x0000.002b60e2
KDO Op code: DRP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x00c00a65 hdba: 0x00c00a63
itli: 1 ispac: 0 maxfr: 4858
tabn: 0 slot: 3(0x3)
*-----------------------------
* Rec #0xe slt: 0x06 objn: 8780(0x0000224c) objd: 8780 tblspc: 2(0x00000002)
* Layer: 10 (Index) opc: 22 rci 0x0d
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0004.01f.000005b1 uba: 0x00800023.0427.19
flg: C--- lkc: 0 scn: 0x0000.002b60fd
Dump kdilk : itl=2, kdxlkflg=0x1 sdc=180352046 indexid=0xc00a6b block=0x00c00a6c
(kdxlpu): purge leaf row
key :(12): 03 c2 02 16 02 c1 06 01 80 02 c1 02
*-----------------------------
* Rec #0xf slt: 0x06 objn: 8786(0x00002252) objd: 8786 tblspc: 2(0x00000002)
* Layer: 11 (Row) opc: 1 rci 0x0e
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0005.018.0000060b uba: 0x008044a6.0623.2f
flg: C--- lkc: 0 scn: 0x0000.002b60e2
KDO Op code: DRP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x00c08988 hdba: 0x00c00a83
itli: 1 ispac: 0 maxfr: 4858
tabn: 0 slot: 14(0xe)
*-----------------------------
* Rec #0x10 slt: 0x06 objn: 8789(0x00002255) objd: 8789 tblspc: 2(0x00000002)
* Layer: 10 (Index) opc: 22 rci 0x0f
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0004.01f.000005b1 uba: 0x00800023.0427.1d
flg: C--- lkc: 0 scn: 0x0000.002b60fd
Dump kdilk : itl=2, kdxlkflg=0x1 sdc=-1073826568 indexid=0xc00a9b block=0x00c07636
(kdxlpu): purge leaf row
key :(17): 10 ec 20 60 c7 8e ab 88 da e0 40 a8 c0 6e 01 0a 2b
*-----------------------------
* Rec #0x11 slt: 0x06 objn: 8803(0x00002263) objd: 8803 tblspc: 2(0x00000002)
* Layer: 10 (Index) opc: 22 rci 0x10
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0004.01f.000005b1 uba: 0x00800023.0427.1e
flg: C--- lkc: 0 scn: 0x0000.002b60fd
Dump kdilk : itl=2, kdxlkflg=0x1 sdc=213658176 indexid=0xc00ad3 block=0x00c082df
(kdxlpu): purge leaf row
key :(42):
02 c1 2a 01 30 01 80 0b 78 71 0b 1a 17 21 11 08 75 9e 70 01 80 01 80 01 80
10 ec 20 60 c7 8e ab 88 da e0 40 a8 c0 6e 01 0a 2b
*-----------------------------
* Rec #0x12 slt: 0x06 objn: 8798(0x0000225e) objd: 8798 tblspc: 2(0x00000002)
* Layer: 10 (Index) opc: 22 rci 0x11
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0005.018.0000060b uba: 0x008044a6.0623.32
flg: C--- lkc: 0 scn: 0x0000.002b60e2
Dump kdilk : itl=3, kdxlkflg=0x1 sdc=8803 indexid=0xc00abb block=0x00c00cd5
(kdxlpu): purge leaf row
key :(24):
10 ec 20 60 c7 8e ab 88 da e0 40 a8 c0 6e 01 0a 2b 02 c1 2a 01 30 01 80
*-----------------------------
* Rec #0x13 slt: 0x06 objn: 8796(0x0000225c) objd: 8796 tblspc: 2(0x00000002)
* Layer: 10 (Index) opc: 22 rci 0x12
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0005.018.0000060b uba: 0x008044a7.0623.01
flg: C--- lkc: 0 scn: 0x0000.002b60e2
Dump kdilk : itl=2, kdxlkflg=0x1 sdc=1 indexid=0xc00ab3 block=0x00c08730
(kdxlpu): purge leaf row
key :(39):
0b 78 71 0c 03 17 21 11 08 75 9e 70 09 31 30 2e 36 2e 31 34 36 33 10 ec 20
60 c7 8e ab 88 da e0 40 a8 c0 6e 01 0a 2b
*-----------------------------
* Rec #0x14 slt: 0x2c objn: 575(0x0000023f) objd: 573 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: 0x00000000
*-----------------------------
uba: 0x00800249.052a.0d ctl max scn: 0x0000.002b5cc0 prv tx scn: 0x0000.002b5cf7
txn start scn: scn: 0x0000.002b6199 logon user: 0
prev brb: 8389191 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0007.021.00000595 uba: 0x00801c06.049f.19
flg: C--- lkc: 0 scn: 0x0000.0029e550
KDO Op code: DRP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x0040f173 hdba: 0x004011c1
itli: 2 ispac: 0 maxfr: 4863
tabn: 1 slot: 0(0x0)
*-----------------------------
* Rec #0x15 slt: 0x2c objn: 576(0x00000240) objd: 576 tblspc: 0(0x00000000)
* Layer: 10 (Index) opc: 22 rci 0x14
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0005.01c.0000060b uba: 0x008044a6.0623.1c
flg: C--- lkc: 0 scn: 0x0000.002b6039
Dump kdilk : itl=2, kdxlkflg=0x1 sdc=0 indexid=0x4011d1 block=0x004011d4
(kdxlpu): purge leaf row
key :(7): 06 c5 09 21 3c 57 38
*-----------------------------
* Rec #0x16 slt: 0x2c objn: 577(0x00000241) objd: 577 tblspc: 0(0x00000000)
* Layer: 10 (Index) opc: 22 rci 0x15
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0005.01c.0000060b uba: 0x008044a6.0623.1e
flg: C--- lkc: 0 scn: 0x0000.002b6039
Dump kdilk : itl=2, kdxlkflg=0x1 sdc=0 indexid=0x4011d9 block=0x004011df
(kdxlpu): purge leaf row
key :(6): 05 c4 03 55 1c 2f
*-----------------------------
* Rec #0x17 slt: 0x2c objn: 575(0x0000023f) objd: 573 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x16
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0005.01c.0000060b uba: 0x008044a6.0623.1f
flg: C--- lkc: 0 scn: 0x0000.002b6039
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x0040f2a3 hdba: 0x004011c1
itli: 2 ispac: 0 maxfr: 4863
tabn: 1 slot: 3(0x3) flag: 0x6c lock: 0 ckix: 0
ncol: 8 nnew: 8 size: 204
col 0: [ 6] c5 08 3f 2c 27 1c
col 1: [ 7] 78 6f 09 15 0c 0b 1c
col 2: [ 1] 80
col 3: [ 5] c4 03 17 5f 35
col 4: [ 2] c2 02
col 5: [1200]
29 d1 71 2d 49 05 22 00 00 00 5d 0c 2c d1 71 2d 4d 05 22 00 00 00 ff bf 2f
d1 71 2d d8 05 22 00 00 00 73 09 35 d1 71 2d de 05 22 00 00 00 ff bf 38 d1
71 2d df 05 22 00 00 00 ff bf 3b d1 71 2d e0 05 22 00 00 00 ff bf 3e d1 71
2d e1 05 22 00 00 00 73 09 41 d1 71 2d e2 05 22 00 00 00 00 00 44 d1 71 2d
e3 05 22 00 00 00 93 08 47 d1 71 2d e4 05 22 00 00 00 c5 0a 4a d1 71 2d e5
05 22 00 00 00 ff bf 4d d1 71 2d e6 05 22 00 00 00 ff bf 50 d1 71 2d e7 05
22 00 00 00 73 09 53 d1 71 2d e8 05 22 00 00 00 73 09 56 d1 71 2d e9 05 22
00 00 00 00 00 59 d1 71 2d ea 05 22 00 00 00 00 00 5c d1 71 2d eb 05 22 00
00 00 73 09 5f d1 71 2d ee 05 22 00 00 00 73 09 65 d1 71 2d 07 06 22 00 00
00 ff bf 68 d1 71 2d 08 06 22 00 00 00 00 00 6b d1 71 2d 09 06 22 00 00 00
00 00 6e d1 71 2d 0a 06 22 00 00 00 00 00 71 d1 71 2d 0b 06 22 00 00 00 2c
b7 74 d1 71 2d 0c 06 22 00 00 00 bc 0c 77 d1 71 2d 0d 06 22 00 00 00 bc 0c
7a d1 71 2d 0e 06 22 00 00 00 bc 0c 7d d1 71 2d 0f 06 22 00 00 00 ff bf 80
d1 71 2d 10 06 22 00 00 00 ff bf 83 d1 71 2d 11 06 22 00 00 00 ff bf 86 d1
71 2d 12 06 22 00 00 00 00 00 89 d1 71 2d 13 06 22 00 00 00 ff bf 8c d1 71
2d 14 06 22 00 00 00 73 09 8f d1 71 2d 15 06 22 00 00 00 93 2a 92 d1 71 2d
16 06 22 00 00 00 00 00 95 d1 71 2d 17 06 22 00 00 00 00 00 98 d1 71 2d 18
06 22 00 00 00 00 00 9b d1 71 2d 19 06 22 00 00 00 00 00 9e d1 71 2d 1b 06
22 00 00 00 73 09 a4 d1 71 2d 22 06 22 00 00 00 00 00 a7 d1 71 2d 23 06 22
00 00 00 00 00 aa d1 71 2d 24 06 22 00 00 00 73 09 ad d1 71 2d 25 06 22 00
00 00 2d b7 b0 d1 71 2d 26 06 22 00 00 00 00 00 b3 d1 71 2d 27 06 22 00 00
00 3b 2c b6 d1 71 2d 28 06 22 00 00 00 00 00 b9 d1 71 2d 29 06 22 00 00 00
93 08 bc d1 71 2d 2a 06 22 00 00 00 00 00 bf d1 71 2d 2b 06 22 00 00 00 00
00 c2 d1 71 2d 2c 06 22 00 00 00 7e 2b c5 d1 71 2d 2d 06 22 00 00 00 00 00
c8 d1 71 2d 2e 06 22 00 00 00 00 00 ce d1 71 2d 26 09 22 00 00 00 f3 29 d1
d1 71 2d 27 09 22 00 00 00 00 00 d4 d1 71 2d 28 09 22 00 00 00 70 09 d7 d1
71 2d 29 09 22 00 00 00 34 2c dd d1 71 2d 2d 09 22 00 00 00 f3 29 e0 d1 71
2d 2e 09 22 00 00 00 bc 0c e6 d1 71 2d 35 09 22 00 00 00 40 02 e9 d1 71 2d
36 09 22 00 00 00 03 00 ec d1 71 2d 37 09 22 00 00 00 00 00 ef d1 71 2d 38
09 22 00 00 00 00 00 f2 d1 71 2d 39 09 22 00 00 00 00 00 f5 d1 71 2d 3a 09
22 00 00 00 00 00 f8 d1 71 2d 3b 09 22 00 00 00 00 00 fb d1 71 2d 3c 09 22
00 00 00 00 00 fe d1 71 2d 3d 09 22 00 00 00 ff ff 01 d2 71 2d 3e 09 22 00
00 00 00 00 04 d2 71 2d 3f 09 22 00 00 00 00 00 07 d2 71 2d 40 09 22 00 00
00 00 00 0a d2 71 2d 42 09 22 00 00 00 50 45 0d d2 71 2d 43 09 22 00 00 00
00 00 10 d2 71 2d 48 09 22 00 00 00 00 00 13 d2 71 2d 49 09 22 00 00 00 00
00 16 d2 71 2d 4a 09 22 00 00 00 00 00 19 d2 71 2d 4b 09 22 00 00 00 00 00
1c d2 71 2d 4c 09 22 00 00 00 00 00 1f d2 71 2d 4d 09 22 00 00 00 00 00 22
d2 71 2d 4e 09 22 00 00 00 00 00 28 d2 71 2d 55 09 22 00 00 00 70 09 2b d2
71 2d 58 09 22 00 00 00 00 00 2f d2 71 2d 59 09 22 00 00 00 00 00 32 d2 71
2d 5a 09 22 00 00 00 00 00 35 d2 71 2d 63 09 22 00 00 00 00 00 3b d2 71 2d
77 09 22 00 00 00 8b 2a 3e d2 71 2d 78 09 22 00 00 00 00 00 41 d2 71 2d 79
09 22 00 00 00 00 00 47 d2 71 2d 7e 09 22 00 00 00 00 bf 4a d2 71 2d 7f 09
22 00 00 00 00 00 4d d2 71 2d 80 09 22 00 00 00 00 00 50 d2 71 2d 81 09 22
00 00 00 00 00 53 d2 71 2d 82 09 22 00 00 00 00 00 56 d2 71 2d 83 09 22 00
00 00 83 2b 59 d2 71 2d 84 09 22 00 00 00 00 00 5c d2 71 2d 85 09 22 00 00
00 41 08 5f d2 71 2d 86 09 22 00 00 00 bf 0a 62 d2 71 2d 08 0a 22 00 00 00
ff bf 65 d2 71 2d a6 0d 22 00 00 00 3b 2c 69 d2 71 2d c9 10 22 00 00 00 3b
2c 6c d2 71 2d 2d 11 22 00 00 00 ff bf 6f d2 71 2d c9 11 22 00 00 00 00 00
col 6: [ 5] c4 03 17 5f 35
col 7: [ 1] 80
*-----------------------------
* Rec #0x18 slt: 0x2c objn: 576(0x00000240) objd: 576 tblspc: 0(0x00000000)
* Layer: 10 (Index) opc: 22 rci 0x17
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0005.01c.0000060b uba: 0x008044a6.0623.20
flg: C--- lkc: 0 scn: 0x0000.002b6039
Dump kdilk : itl=2, kdxlkflg=0x1 sdc=8 indexid=0x4011d1 block=0x004011d5
(kdxlre): restore leaf row (clear leaf delete flags)
key :(7): 06 c5 08 3f 2c 27 1c
keydata/bitmap: (6): 00 40 f2 a3 00 03
*-----------------------------
* Rec #0x19 slt: 0x2c objn: 576(0x00000240) objd: 576 tblspc: 0(0x00000000)
* Layer: 10 (Index) opc: 22 rci 0x18
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x02 ver: 0x01
op: C uba: 0x00800249.052a.15
Dump kdilk : itl=2, kdxlkflg=0x1 sdc=612499548 indexid=0x4011d1 block=0x004011d4
(kdxlpu): purge leaf row
key :(7): 06 c5 09 21 3c 5a 4d
*-----------------------------
* Rec #0x1a slt: 0x2c objn: 577(0x00000241) objd: 577 tblspc: 0(0x00000000)
* Layer: 10 (Index) opc: 22 rci 0x19
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0005.01c.0000060b uba: 0x008044a6.0623.21
flg: C--- lkc: 0 scn: 0x0000.002b6039
Dump kdilk : itl=2, kdxlkflg=0x1 sdc=7 indexid=0x4011d9 block=0x004011db
(kdxlre): restore leaf row (clear leaf delete flags)
key :(6): 05 c4 03 17 5f 35
keydata/bitmap: (6): 00 40 f2 a3 00 03
*-----------------------------
* Rec #0x1b slt: 0x2c objn: 577(0x00000241) objd: 577 tblspc: 0(0x00000000)
* Layer: 10 (Index) opc: 22 rci 0x1a
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x02 ver: 0x01
op: C uba: 0x00800249.052a.16
Dump kdilk : itl=2, kdxlkflg=0x1 sdc=612540508 indexid=0x4011d9 block=0x004011df
(kdxlpu): purge leaf row
key :(6): 05 c4 03 55 1d 56
*-----------------------------
* Rec #0x1c slt: 0x2c objn: 575(0x0000023f) objd: 573 tblspc: 0(0x00000000)
* Layer: 11 (Row) opc: 1 rci 0x1b
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0008.00a.00000600 uba: 0x008000ae.0441.26
flg: C--- lkc: 0 scn: 0x0000.002b5cf9
KDO Op code: IRP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x0040f29b hdba: 0x004011c1
itli: 2 ispac: 0 maxfr: 4863
tabn: 1 slot: 3(0x3) size/delt: 99
fb: -CH-FL-- lb: 0x0 cc: 8 cki: 0
null: --------
col 0: [ 6] c5 08 3f 2c 2a 3f
col 1: [ 7] 78 6f 09 15 0c 11 03
col 2: [ 1] 80
col 3: [ 5] c4 03 18 1c 5d
col 4: [ 2] c1 06
col 5: [60]
75 d2 71 2d da 11 22 00 00 00 5d 0c 78 d2 71 2d d5 12 22 00 00 00 ff bf 7b
d2 71 2d 25 14 22 00 00 00 73 09 7e d2 71 2d 3d 17 22 00 00 00 ff bf 81 d2
71 2d e8 19 22 00 00 00 ff bf
col 6: [ 5] c4 03 18 1c 5d
col 7: [ 1] 80
*-----------------------------
* Rec #0x1d slt: 0x2c objn: 576(0x00000240) objd: 576 tblspc: 0(0x00000000)
* Layer: 10 (Index) opc: 22 rci 0x1c
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x02 ver: 0x01
op: C uba: 0x00800249.052a.18
Dump kdilk : itl=2, kdxlkflg=0x1 sdc=8 indexid=0x4011d1 block=0x004011d5
(kdxlre): restore leaf row (clear leaf delete flags)
key :(7): 06 c5 08 3f 2c 2a 3f
keydata/bitmap: (6): 00 40 f2 9b 00 03
*-----------------------------
* Rec #0x1e slt: 0x2c objn: 577(0x00000241) objd: 577 tblspc: 0(0x00000000)
* Layer: 10 (Index) opc: 22 rci 0x1d
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x02 ver: 0x01
op: C uba: 0x00800249.052a.1a
Dump kdilk : itl=2, kdxlkflg=0x1 sdc=7 indexid=0x4011d9 block=0x004011db
(kdxlre): restore leaf row (clear leaf delete flags)
key :(6): 05 c4 03 18 1c 5d
keydata/bitmap: (6): 00 40 f2 9b 00 03
*-----------------------------
* Rec #0x1f slt: 0x2e objn: 8779(0x0000224b) objd: 8779 tblspc: 2(0x00000002)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
uba: 0x00800249.052a.14 ctl max scn: 0x0000.002b5cf7 prv tx scn: 0x0000.002b5d02
txn start scn: scn: 0x0000.002b61d7 logon user: 0
prev brb: 8389191 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0005.029.0000060a uba: 0x008044a7.0623.16
flg: C--- lkc: 0 scn: 0x0000.002b61b9
KDO Op code: DRP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x00c00a65 hdba: 0x00c00a63
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 3(0x3)
*-----------------------------
* Rec #0x20 slt: 0x2e objn: 8780(0x0000224c) objd: 8780 tblspc: 2(0x00000002)
* Layer: 10 (Index) opc: 22 rci 0x1f
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0004.00c.000005b2 uba: 0x00800023.0427.2d
flg: C--- lkc: 0 scn: 0x0000.002b61d6
Dump kdilk : itl=2, kdxlkflg=0x1 sdc=180352046 indexid=0xc00a6b block=0x00c00a6c
(kdxlpu): purge leaf row
key :(12): 03 c2 02 16 02 c1 05 01 80 02 c1 02
*-----------------------------
* Rec #0x21 slt: 0x2e objn: 8786(0x00002252) objd: 8786 tblspc: 2(0x00000002)
* Layer: 11 (Row) opc: 1 rci 0x20
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0005.029.0000060a uba: 0x008044a7.0623.1a
flg: C--- lkc: 0 scn: 0x0000.002b61b9
KDO Op code: DRP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x00c08949 hdba: 0x00c00a83
itli: 2 ispac: 0 maxfr: 4858
tabn: 0 slot: 2(0x2)
*-----------------------------
* Rec #0x22 slt: 0x2e objn: 8789(0x00002255) objd: 8789 tblspc: 2(0x00000002)
* Layer: 10 (Index) opc: 22 rci 0x21
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0004.00c.000005b2 uba: 0x00800023.0427.31
flg: C--- lkc: 0 scn: 0x0000.002b61d6
Dump kdilk : itl=2, kdxlkflg=0x1 sdc=-1073826568 indexid=0xc00a9b block=0x00c07636
(kdxlpu): purge leaf row
key :(17): 10 ec 20 60 c7 8e b0 88 da e0 40 a8 c0 6e 01 0a 2b
*-----------------------------
* Rec #0x23 slt: 0x2e objn: 8803(0x00002263) objd: 8803 tblspc: 2(0x00000002)
* Layer: 10 (Index) opc: 22 rci 0x22
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0004.00c.000005b2 uba: 0x00800023.0427.32
flg: C--- lkc: 0 scn: 0x0000.002b61d6
Dump kdilk : itl=2, kdxlkflg=0x1 sdc=213658176 indexid=0xc00ad3 block=0x00c082df
(kdxlpu): purge leaf row
key :(42):
02 c1 2a 01 30 01 80 0b 78 71 0b 1a 17 25 11 10 5b d9 d8 01 80 01 80 01 80
10 ec 20 60 c7 8e b0 88 da e0 40 a8 c0 6e 01 0a 2b
*-----------------------------
* Rec #0x24 slt: 0x2e objn: 8798(0x0000225e) objd: 8798 tblspc: 2(0x00000002)
* Layer: 10 (Index) opc: 22 rci 0x23
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0005.029.0000060a uba: 0x008044a7.0623.1d
flg: C--- lkc: 0 scn: 0x0000.002b61b9
Dump kdilk : itl=2, kdxlkflg=0x1 sdc=8803 indexid=0xc00abb block=0x00c00cd5
(kdxlpu): purge leaf row
key :(24):
10 ec 20 60 c7 8e b0 88 da e0 40 a8 c0 6e 01 0a 2b 02 c1 2a 01 30 01 80
*-----------------------------
* Rec #0x25 slt: 0x2e objn: 8796(0x0000225c) objd: 8796 tblspc: 2(0x00000002)
* Layer: 10 (Index) opc: 22 rci 0x24
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
index undo for leaf key operations
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0005.029.0000060a uba: 0x008044a7.0623.1e
flg: C--- lkc: 0 scn: 0x0000.002b61b9
Dump kdilk : itl=3, kdxlkflg=0x1 sdc=1 indexid=0xc00ab3 block=0x00c08730
(kdxlpu): purge leaf row
key :(40):
0b 78 71 0c 03 17 25 11 10 5b d9 d8 0a 31 30 2e 34 36 2e 31 34 36 32 10 ec
20 60 c7 8e b0 88 da e0 40 a8 c0 6e 01 0a 2b
*-----------------------------
* Rec #0x26 slt: 0x0f objn: 51148(0x0000c7cc) objd: 51148 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
uba: 0x00800249.052a.1f ctl max scn: 0x0000.002b5d02 prv tx scn: 0x0000.002b5d0c
txn start scn: scn: 0x0000.002b6223 logon user: 54
prev brb: 8389191 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0008.01d.0000051c uba: 0x00800506.03cb.33
flg: C--- lkc: 0 scn: 0x0000.00244c6b
Array Update of 14 rows:
tabn: 0 slot: 0(0x0) flag: 0x2c lock: 0 ckix: 183
ncol: 8 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x01000020 hdba: 0x0100001b
itli: 2 ispac: 0 maxfr: 4858
vect = 28
col 5: [ 2] c2 0c
tabn: 0 slot: 1(0x1) flag: 0x2c lock: 0 ckix: 183
ncol: 8 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x01000020 hdba: 0x0100001b
itli: 2 ispac: 0 maxfr: 4858
vect = 31
col 5: [ 2] c2 12
tabn: 0 slot: 2(0x2) flag: 0x2c lock: 0 ckix: 183
ncol: 8 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x01000020 hdba: 0x0100001b
itli: 2 ispac: 0 maxfr: 4858
vect = 30
col 5: [ 3] c2 0e 33
tabn: 0 slot: 3(0x3) flag: 0x2c lock: 0 ckix: 183
ncol: 8 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x01000020 hdba: 0x0100001b
itli: 2 ispac: 0 maxfr: 4858
vect = 30
col 5: [ 3] c2 1f 4c
tabn: 0 slot: 4(0x4) flag: 0x2c lock: 0 ckix: 183
ncol: 8 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x01000020 hdba: 0x0100001b
itli: 2 ispac: 0 maxfr: 4858
vect = 32
col 5: [ 3] c2 0e 33
tabn: 0 slot: 5(0x5) flag: 0x2c lock: 0 ckix: 183
ncol: 8 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x01000020 hdba: 0x0100001b
itli: 2 ispac: 0 maxfr: 4858
vect = 30
col 5: [ 3] c2 1e 33
tabn: 0 slot: 6(0x6) flag: 0x2c lock: 0 ckix: 183
ncol: 8 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x01000020 hdba: 0x0100001b
itli: 2 ispac: 0 maxfr: 4858
vect = 30
col 5: [ 3] c2 1a 33
tabn: 0 slot: 7(0x7) flag: 0x2c lock: 0 ckix: 183
ncol: 8 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x01000020 hdba: 0x0100001b
itli: 2 ispac: 0 maxfr: 4858
vect = 30
col 5: [ 2] c2 20
tabn: 0 slot: 8(0x8) flag: 0x2c lock: 0 ckix: 183
ncol: 8 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x01000020 hdba: 0x0100001b
itli: 2 ispac: 0 maxfr: 4858
vect = 28
col 5: [ 2] c2 34
tabn: 0 slot: 9(0x9) flag: 0x2c lock: 0 ckix: 183
ncol: 8 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x01000020 hdba: 0x0100001b
itli: 2 ispac: 0 maxfr: 4858
vect = 32
col 5: [ 2] c2 11
tabn: 0 slot: 10(0xa) flag: 0x2c lock: 0 ckix: 183
ncol: 8 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x01000020 hdba: 0x0100001b
itli: 2 ispac: 0 maxfr: 4858
vect = 28
col 5: [ 2] c2 0d
tabn: 0 slot: 11(0xb) flag: 0x2c lock: 0 ckix: 183
ncol: 8 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x01000020 hdba: 0x0100001b
itli: 2 ispac: 0 maxfr: 4858
vect = 27
col 5: [ 3] c2 0b 33
tabn: 0 slot: 12(0xc) flag: 0x2c lock: 0 ckix: 183
ncol: 8 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x01000020 hdba: 0x0100001b
itli: 2 ispac: 0 maxfr: 4858
vect = 29
col 5: [ 2] c2 20
tabn: 0 slot: 13(0xd) flag: 0x2c lock: 0 ckix: 183
ncol: 8 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x01000020 hdba: 0x0100001b
itli: 2 ispac: 0 maxfr: 4858
vect = 29
col 5: [ 2] c2 0f
End dump data blocks tsn: 1 file#: 2 minblk 585 maxblk 585
670
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
