WEB开发网
开发学院数据库Oracle append 与 Highwater 测试 阅读

append 与 Highwater 测试

 2008-06-03 12:43:08 来源:WEB开发网   
核心提示: SQL> alter system dump datafile 11 block 193;系统已更改。SQL> select p.value||''||i.instance_name||'_ora_'||p.spid||'.trc'

  SQL> alter system dump datafile 11 block 193;
  系统已更改。
  SQL> select p.value||''||i.instance_name||'_ora_'||p.spid||'.trc' trace_path
 2 from v$process p, v$instance i, v$parameter p
 3 where p.addr = (
 4 select paddr from v$session
 5 where sid = ( select sid from v$mystat where rownum = 1)
 6 )
 7 and p.name='user_dump_dest';
  TRACE_PATH
-------------------------------------------------------------------
D:oracleadminoraudumporasid_ora_3376.trc

我们看看193块中的信息:

  *** 2008-05-30 11:24:07.000
Start dump data blocks tsn: 11 file#: 11 minblk 193 maxblk 193
buffer tsn: 11 rdba: 0x02c000c1 (11/193)
scn: 0x0000.1bf3af2f seq: 0x01 flg: 0x00 tail: 0xaf2f1001
frmt: 0x02 chkval: 0x0000 type: 0x10=DATA SEGMENT HEADER - UNLIMITED
 Extent Control Header
 -----------------------------------------------------------------
 Extent Header:: spare1: 0   spare2: 0   #extents: 1   #blocks: 7  
         last map 0x00000000 #maps: 0   offset: 4128 
   Highwater:: 0x02c000c3 ext#: 0   blk#: 1   ext size: 7  
 #blocks in seg. hdr's freelists: 1  
 #blocks below: 1  
 mapblk 0x00000000 offset: 0  
          Unlocked
   Map Header:: next 0x00000000 #extents: 1  obj#: 31997 flag: 0x40000000
 Extent Map
 -----------------------------------------------------------------
  0x02c000c2 length: 7  
 
 nfl = 1, nfb = 1 typ = 1 nxf = 0 ccnt = 1
 SEG LST:: flg: USED  lhd: 0x02c000c2 ltl: 0x02c000c2
End dump data blocks tsn: 11 file#: 11 minblk 193 maxblk 193

上一页  1 2 3 4 5 6 7  下一页

Tags:append Highwater

编辑录入:爽爽 [复制链接] [打 印]
赞助商链接