`

Oracle10g 动态性能视图系列—V$TRANSACTION

 
阅读更多
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 动态性能(V$)视图

    Oracle数据库中的动态性能(V$)视图是数据库管理员和开发人员获取实时数据库状态信息的重要工具。这些视图提供了丰富的信息,涵盖了从SQL执行情况、系统资源使用到数据库等待事件等各个方面,极大地帮助了性能调优...

    Oracle10g_Views.pdf

    ### Oracle 10g 视图详解 #### 引言 在Oracle 10g数据库系统中,视图(View)是一种重要的数据抽象工具,它不仅简化了数据查询过程,还提高了系统的安全性与灵活性。Oracle 10g通过提供丰富的视图集,使数据库管理...

    oracle_v$session_v$session_wait用途详解

    Oracle 数据库提供了大量的动态性能视图(Dynamic Performance Views),其中 `V$SESSION` 和 `V$SESSION_WAIT` 是两个非常重要的视图,它们能够帮助数据库管理员深入了解当前会话的状态以及等待事件的信息。...

    Oracle10g DBA培训PPT

    Oracle10g是其第十个主要版本,重点提升了性能、可用性和可管理性。在PPT中,这部分可能会涵盖Oracle的体系结构,包括数据库实例、进程、数据文件、控制文件、重做日志文件等基本概念。 二、安装与配置 安装Oracle...

    oracle 常用表和视图

    `v$`开头的动态性能视图** 这些视图提供运行时数据库的状态信息: - **v$database**: 显示当前数据库的基本信息。 - **v$datafile**: 数据文件的实时状态。 - **v$controlfile**: 控制文件的详细信息。 - **v$log...

    Oracle10gDatabse-Views.docx

    V$GLOBAL_TRANSACTION 是 Oracle 10g Database Views 中的一个视图,提供了全局事务的信息。 V$SGA_DYNAMIC_FREE_MEMORY 是 Oracle 10g Database Views 中的一个视图,提供了 SGA 动态自由内存的信息。 V$...

    ORACLE主要的系统表和系统视图

    ### Oracle主要的系统表和系统视图 Oracle数据库作为一款广泛使用的数据库管理系统,在其内部维护了大量的系统表和系统视图来记录与管理数据库的各种状态信息。对于DBA(数据库管理员)来说,熟悉并掌握这些系统表...

    Oracle回滚段使用查询代码详解

    这个查询连接了几个动态性能视图,包括`v$lock`(查看锁信息),`v$session`(获取会话信息),`v$rollname`(回滚段名)和`v$transaction`(查看事务信息)。通过匹配相应的会话SID、锁类型、事务地址等条件,我们...

    Oracle10g对回滚操作时间的准确评估

    通过利用 Oracle 10g 中的 V$SESSION_LONGOPS 视图,数据库管理员可以更有效地监控和管理回滚操作,预测系统资源的使用,以及优化数据库性能。这种改进的监控能力对于处理大规模事务处理或复杂业务逻辑的数据库环境...

    oracle views 10g

    ### Oracle 10g 视图详解 #### 高可用性和恢复能力 Oracle 10g 的高可用性与恢复功能对于确保数据安全至关重要。以下列出的视图提供了关于备份、归档和恢复过程的关键信息。 1. **V$ARCHIVE**: 展示了归档日志的...

    oracle 10g 英文试题

    ### Oracle 10g 英文试题解析 #### 考试概述 Oracle 10g DBA(数据库管理员)认证考试是Oracle公司为验证个人在管理Oracle 10g数据库方面的能力而设立的一项专业考试。该考试主要涵盖Oracle 10g的新特性及其在...

    Oracle 10g 学习笔记

    │ oracle10g的系统视图(sys、system).txt │ oracle10g系统管理之UNDO表空间 - lvhuiqing的专栏 - CSDN博客.mht │ oracle10g系统管理之序列 - lvhuiqing的专栏 - CSDN博客.mht │ oracle10g系统管理之序列 - ...

    oracle 10g ppt课件

    6. **SQL优化**:Oracle 10g的优化器引入了Cost-Based Optimizer(CBO)的增强,包括统计信息的自动收集、动态采样和高级索引使用策略,以提升SQL查询性能。 7. **物化视图**:Oracle 10g提供了物化视图,可以预先...

    Oracle数据库管理员经常使用的表和视图

    在Oracle数据库管理工作中,熟练掌握并利用系统提供的数据字典表和动态性能视图(Dynamic Performance Views)对于提高数据库管理效率、确保数据库健康运行至关重要。以下是对给定文件中列出的一些常用表和视图的...

    oracle 10g数据库java开发

    8. **Oracle的高级特性**:例如,Oracle 10g支持物化视图、分区表、索引组织表等特性,这些都可以通过Java程序进行操作和管理,优化查询性能。 9. **异常处理**:在Java中,需正确处理SQLException和其他可能抛出的...

    oracle10g 概念 中文版

    10. **安全增强**:Oracle 10g提供了更强大的安全性特性,如细粒度审计(Fine-Grained Auditing)、数据屏蔽(Data Masking)和动态数据加密(Transparent Data Encryption, TDE),确保敏感数据的安全。 11. **...

    Oracle11g 考试

    Oracle 11g是Oracle公司推出的数据库管理系统的一个重要版本,主要针对企业级应用提供高性能、高可用性和安全性。Oracle Certified Professional (OCP) 认证是Oracle为验证专业人士在Oracle数据库管理方面技能和知识...

    Oracle10g数据库管理与应用系统开发光盘

    6. **SQL优化**:Oracle10g改进了查询优化器,引入了统计信息的动态采样、成本基础优化器(CBO)以及SQL Profile等,以提高查询性能。 7. ** flashback技术**:Flashback Query允许用户查看过去某个时间点的数据库...

    Oracle 10g数据库基础教程数据库脚本

    Oracle 10g数据库是Oracle公司推出的一款关系型数据库管理系统,尤其适合大型企业级应用。在本基础教程中,我们主要关注的是通过脚本进行数据库操作,这将帮助初学者快速掌握Oracle 10g的基本功能和管理技巧。 1. *...

    Oracle 10g Concepts 中文版

    oracle官方的学习资料,中英文对照 目录如下: 第一部分 何为 Oracle? Chapter 1, Introduction to the Oracle Database 第 1 章,Oracle 数据库简介 Part II Oracle Database Architecture 第二部分 Oracle ...

Global site tag (gtag.js) - Google Analytics