您现在的位置:速学网教学教育考试频道计算机考试ORACLE/CIW认证Oracle的回滚段存储内容分析(1)» 正文

Oracle的回滚段存储内容分析(1)

[01-23 15:53:55]   来源:http://www.suxue6.com  ORACLE/CIW认证   阅读:8494

概要:xtype: XA bdba: 0x00401ec2 hdba: 0x00401ec1 itli: 1 ispac: 0 maxfr: 4863 tabn: 0 slot: 0 to: 0 *- * Rec #0x34 slt: 0x24 objn: 92108(0x000167cc) objd: 92108 tblspc: 11(0x0000000b) * 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: 0x0e000c46.0054.32 ctl max scn: 0x0001.85697df0 prv tx scn: 0x0001.85697df3 KDO undo record: KTB Redo op: 0x03 ver: 0x01 op: Z KDO Op code: URP row dependenci...
Oracle的回滚段存储内容分析(1),标签:ciw认证考试,oracle认证,http://www.suxue6.com
  xtype: XA bdba: 0x00401ec2 hdba: 0x00401ec1
  itli: 1 ispac: 0 maxfr: 4863
  tabn: 0 slot: 0 to: 0
  *-----------------------------
  * Rec #0x34 slt: 0x24 objn: 92108(0x000167cc) objd: 92108 tblspc: 11(0x0000000b)
  * 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: 0x0e000c46.0054.32 ctl max scn: 0x0001.85697df0 prv tx scn: 0x0001.85697df3
  KDO undo record:
  KTB Redo
  op: 0x03 ver: 0x01
  op: Z
  KDO Op code: URP row dependencies Disabled
  xtype: XA bdba: 0x03801d0d hdba: 0x03801d0b
  itli: 2 ispac: 0 maxfr: 4858
  tabn: 0 slot: 0(0x0) flag: 0x2c lock: 0 ckix: 88
  ncol: 3 nnew: 1 size: 0
  col 1: [20] 6e 61 6d 65 31 30 31 30 31 30 31 30 31 30 31 30 31 30 31 30
  *-----------------------------
  * Rec #0x35 slt: 0x24 objn: 92108(0x000167cc) objd: 92108 tblspc: 11(0x0000000b)
  * Layer: 11 (Row) opc: 1 rci 0x34
  Undo type: Regular undo Last buffer split: No
  Temp Object: No
  Tablespace Undo: No
  rdba: 0x00000000
  *-----------------------------
  KDO undo record:
  KTB Redo
  op: 0x03 ver: 0x01
  op: Z
  KDO Op code: URP row dependencies Disabled
  xtype: XA bdba: 0x03809e2f hdba: 0x03801d0b
  itli: 2 ispac: 0 maxfr: 4858
  tabn: 0 slot: 1(0x1) flag: 0x2c lock: 0 ckix: 88
  ncol: 3 nnew: 1 size: 0
  col 1: [20] 6e 61 6d 65 32 30 32 30 32 30 32 30 32 30 32 30 32 30 32 30
  End dump data blocks tsn: 33 file#: 56 minblk 3142 maxblk 3142

上一页  [1] [2] 


Tag:ORACLE/CIW认证ciw认证考试,oracle认证考试频道 - 计算机考试 - ORACLE/CIW认证

Copyright 速学网 © 版权所有 All Rights Reserved.

1 2 3 4 5 6