- 浏览: 136184 次
- 性别:
- 来自: 深圳
文章分类
最新评论
Oracle10g 动态性能视图之—V$TRANSACTION
老规矩打开Oracle 10g的帮助文档 "Most Popular" ->"Reference" 选择HTML->"7 Dynamic Performance (V$) Views: V$NLS_PARAMETERS to V$XML_AUDIT_TRAIL" ->
点击"V$TRANSACTION"链接,进入官方对该动态性能视图的解释。
首先"V$TRANSACTION" 的作用
V$TRANSACTION 列出当前数据库系统中的活动事务,其实就是监控当前数据库系统正在执行的事务
观注各列字段的含意
列名 数据类型 含义
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
示例了解该动态性能视图
准备测试表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)
使用UPDATE 语句更新这张表
SQL> update t1 set owner='loris';
查询该更新事务信息
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
联合v$session 再查一次,这样就知道是哪个用户的哪些事务了,进而可以跟踪到sql
注:used_urec 字段不断增加,说明该事物正在继续,如果该字段不断下降,说明该事物正在回滚
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;
事务进阶
一个事务的活动信息是保存在undo 段中,V$TRANSACTION事务表中的
XID由XIDUSN.XIDSLOT.XIDSQN组成 ,如xid: 0x000a.00f.000005b5 10.15.1461
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
Oracle 在undo段的第一个数据块,回滚段头块存放事务信息 也就是有一个数据结构—事务表SYS@ orcl>select name from v$rollname where usn=10;
NAME
------------------------------
_SYSSMU10$
dump回滚段头:
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
0x0f 10 0x80 0x05b5 0x0002 0x0000.002b6223 0x00800249 0x0000.000.00000000 0x00000001 0x00000000 0 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
dump回滚块
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
key44):
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
key36):
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
key44):
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
key36):
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
key44):
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
key36):
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
key44):
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
key36):
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
key63):
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
key12): 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
key17): 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
key42):
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
key24):
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
key39):
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
key7): 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
key6): 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)
key7): 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
key7): 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)
key6): 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
key6): 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)
key7): 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)
key6): 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
key12): 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
key17): 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
key42):
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
key24):
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
key40):
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
老规矩打开Oracle 10g的帮助文档 "Most Popular" ->"Reference" 选择HTML->"7 Dynamic Performance (V$) Views: V$NLS_PARAMETERS to V$XML_AUDIT_TRAIL" ->
点击"V$TRANSACTION"链接,进入官方对该动态性能视图的解释。
首先"V$TRANSACTION" 的作用
V$TRANSACTION 列出当前数据库系统中的活动事务,其实就是监控当前数据库系统正在执行的事务
观注各列字段的含意
列名 数据类型 含义
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
示例了解该动态性能视图
准备测试表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)
使用UPDATE 语句更新这张表
SQL> update t1 set owner='loris';
查询该更新事务信息
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
联合v$session 再查一次,这样就知道是哪个用户的哪些事务了,进而可以跟踪到sql
注:used_urec 字段不断增加,说明该事物正在继续,如果该字段不断下降,说明该事物正在回滚
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;
事务进阶
一个事务的活动信息是保存在undo 段中,V$TRANSACTION事务表中的
XID由XIDUSN.XIDSLOT.XIDSQN组成 ,如xid: 0x000a.00f.000005b5 10.15.1461
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
Oracle 在undo段的第一个数据块,回滚段头块存放事务信息 也就是有一个数据结构—事务表SYS@ orcl>select name from v$rollname where usn=10;
NAME
------------------------------
_SYSSMU10$
dump回滚段头:
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
0x0f 10 0x80 0x05b5 0x0002 0x0000.002b6223 0x00800249 0x0000.000.00000000 0x00000001 0x00000000 0 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
dump回滚块
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
key44):
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
key36):
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
key44):
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
key36):
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
key44):
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
key36):
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
key44):
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
key36):
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
key63):
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
key12): 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
key17): 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
key42):
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
key24):
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
key39):
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
key7): 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
key6): 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)
key7): 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
key7): 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)
key6): 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
key6): 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)
key7): 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)
key6): 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
key12): 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
key17): 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
key42):
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
key24):
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
key40):
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
发表评论
-
轻松卸载 Oracle 11G 数据库
2012-08-11 21:24 4578适用环境:类 unix 系统 或 windows 操作系统环境 ... -
Oracle 通用内存分配计算规则
2011-07-31 10:41 965注意:这只是一个相对通用的计算规则 对于中小型数据库, ... -
Oracle 手工清除回滚段的几种方法
2011-07-31 09:55 1041转自:Blog: http://blog.csdn.net/t ... -
Oracle中如何进行进制转换
2011-07-25 13:31 99116进制转换为10进制 可以通过to_number函数实现,如 ... -
Oracle 等待事件
2011-07-16 09:46 953将自己遇到的Oracle 等待事件记录下来,待以后可以查录: ... -
ocp考证简要须知及报名流程
2011-06-27 13:45 2883转自:http://warehouse.itpub ... -
Ocp证书的价值以及拥有它的意义
2011-06-27 13:19 1795Ocp证书的价值以及拥有它的意义 常在pub上看到一些无聊的 ... -
[Windows ] Oracle数据库服务消失了
2011-04-01 13:59 5058数据库服务器环境: Windows 2003 S ... -
[老实系列] 常用数据结构
2011-04-01 10:27 815数组 (Array) 在程 ... -
迁移 Oracle 数据库的几种方式
2011-03-26 19:26 0待完成中..... -
RMAN学习 -- 使用RMAN将数据库从文件系统迁移至ASM
2011-03-26 19:23 0待完成中。。。。 -
ASM学习 -- ASM常见管理
2011-03-26 19:20 0待完成中...... -
ASM学习 -- ASM环境搭建
2011-03-26 19:18 0待完成中...... -
ASM学习 -- ASM技术简介
2011-03-26 19:14 1640ASM 概述 众所周知 ...
相关推荐
Oracle数据库中的动态性能(V$)视图是数据库管理员和开发人员获取实时数据库状态信息的重要工具。这些视图提供了丰富的信息,涵盖了从SQL执行情况、系统资源使用到数据库等待事件等各个方面,极大地帮助了性能调优...
### Oracle 10g 视图详解 #### 引言 在Oracle 10g数据库系统中,视图(View)是一种重要的数据抽象工具,它不仅简化了数据查询过程,还提高了系统的安全性与灵活性。Oracle 10g通过提供丰富的视图集,使数据库管理...
Oracle 数据库提供了大量的动态性能视图(Dynamic Performance Views),其中 `V$SESSION` 和 `V$SESSION_WAIT` 是两个非常重要的视图,它们能够帮助数据库管理员深入了解当前会话的状态以及等待事件的信息。...
Oracle10g是其第十个主要版本,重点提升了性能、可用性和可管理性。在PPT中,这部分可能会涵盖Oracle的体系结构,包括数据库实例、进程、数据文件、控制文件、重做日志文件等基本概念。 二、安装与配置 安装Oracle...
`v$`开头的动态性能视图** 这些视图提供运行时数据库的状态信息: - **v$database**: 显示当前数据库的基本信息。 - **v$datafile**: 数据文件的实时状态。 - **v$controlfile**: 控制文件的详细信息。 - **v$log...
V$GLOBAL_TRANSACTION 是 Oracle 10g Database Views 中的一个视图,提供了全局事务的信息。 V$SGA_DYNAMIC_FREE_MEMORY 是 Oracle 10g Database Views 中的一个视图,提供了 SGA 动态自由内存的信息。 V$...
### Oracle主要的系统表和系统视图 Oracle数据库作为一款广泛使用的数据库管理系统,在其内部维护了大量的系统表和系统视图来记录与管理数据库的各种状态信息。对于DBA(数据库管理员)来说,熟悉并掌握这些系统表...
这个查询连接了几个动态性能视图,包括`v$lock`(查看锁信息),`v$session`(获取会话信息),`v$rollname`(回滚段名)和`v$transaction`(查看事务信息)。通过匹配相应的会话SID、锁类型、事务地址等条件,我们...
通过利用 Oracle 10g 中的 V$SESSION_LONGOPS 视图,数据库管理员可以更有效地监控和管理回滚操作,预测系统资源的使用,以及优化数据库性能。这种改进的监控能力对于处理大规模事务处理或复杂业务逻辑的数据库环境...
### Oracle 10g 视图详解 #### 高可用性和恢复能力 Oracle 10g 的高可用性与恢复功能对于确保数据安全至关重要。以下列出的视图提供了关于备份、归档和恢复过程的关键信息。 1. **V$ARCHIVE**: 展示了归档日志的...
### Oracle 10g 英文试题解析 #### 考试概述 Oracle 10g DBA(数据库管理员)认证考试是Oracle公司为验证个人在管理Oracle 10g数据库方面的能力而设立的一项专业考试。该考试主要涵盖Oracle 10g的新特性及其在...
│ oracle10g的系统视图(sys、system).txt │ oracle10g系统管理之UNDO表空间 - lvhuiqing的专栏 - CSDN博客.mht │ oracle10g系统管理之序列 - lvhuiqing的专栏 - CSDN博客.mht │ oracle10g系统管理之序列 - ...
6. **SQL优化**:Oracle 10g的优化器引入了Cost-Based Optimizer(CBO)的增强,包括统计信息的自动收集、动态采样和高级索引使用策略,以提升SQL查询性能。 7. **物化视图**:Oracle 10g提供了物化视图,可以预先...
在Oracle数据库管理工作中,熟练掌握并利用系统提供的数据字典表和动态性能视图(Dynamic Performance Views)对于提高数据库管理效率、确保数据库健康运行至关重要。以下是对给定文件中列出的一些常用表和视图的...
8. **Oracle的高级特性**:例如,Oracle 10g支持物化视图、分区表、索引组织表等特性,这些都可以通过Java程序进行操作和管理,优化查询性能。 9. **异常处理**:在Java中,需正确处理SQLException和其他可能抛出的...
10. **安全增强**:Oracle 10g提供了更强大的安全性特性,如细粒度审计(Fine-Grained Auditing)、数据屏蔽(Data Masking)和动态数据加密(Transparent Data Encryption, TDE),确保敏感数据的安全。 11. **...
Oracle 11g是Oracle公司推出的数据库管理系统的一个重要版本,主要针对企业级应用提供高性能、高可用性和安全性。Oracle Certified Professional (OCP) 认证是Oracle为验证专业人士在Oracle数据库管理方面技能和知识...
6. **SQL优化**:Oracle10g改进了查询优化器,引入了统计信息的动态采样、成本基础优化器(CBO)以及SQL Profile等,以提高查询性能。 7. ** flashback技术**:Flashback Query允许用户查看过去某个时间点的数据库...
Oracle 10g数据库是Oracle公司推出的一款关系型数据库管理系统,尤其适合大型企业级应用。在本基础教程中,我们主要关注的是通过脚本进行数据库操作,这将帮助初学者快速掌握Oracle 10g的基本功能和管理技巧。 1. *...
oracle官方的学习资料,中英文对照 目录如下: 第一部分 何为 Oracle? Chapter 1, Introduction to the Oracle Database 第 1 章,Oracle 数据库简介 Part II Oracle Database Architecture 第二部分 Oracle ...