Oracle10g 动态功能视图系列—V$TRANSACTIONITeye - 众发娱乐

Oracle10g 动态功能视图系列—V$TRANSACTIONITeye

2019-01-10 13:24:43 | 作者: 运良 | 标签: 动态,功能,视图 | 浏览: 1718

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. hdrs 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

















版权声明
本文来源于网络,版权归原作者所有,其内容与观点不代表众发娱乐立场。转载文章仅为传播更有价值的信息,如采编人员采编有误或者版权原因,请与我们联系,我们核实后立即修改或删除。

猜您喜欢的文章

阅读排行

  • 1

    (转)sshdITeye

    运用,设定,这个
  • 2

    几种监控用守时使命ITeye

    监控,网络连接,进程
  • 3

    Ubuntu下装置php扩展ITeye

    装置,扩展,办法
  • 4
  • 5
  • 6
  • 7

    浅谈https\ssl\数字证书(2)ITeye

    证书,数字证书,客户端
  • 8
  • 9
  • 10