dump datafile

hwqhx

请问用alter system dump datafile 出来的trace中怎么看到是那个object?

Maclean Liu(刘相兵

SQL> select header_block ,header_file from dba_segments where segment_name='MACLEAN';

HEADER_BLOCK HEADER_FILE
------------ -----------
          12          27

SQL>  alter system dump datafile 27 block 13;

System altered.

SQL>  select object_id,data_object_id from dba_objects where object_name='MACLEAN';

OBJECT_ID DATA_OBJECT_ID
---------- --------------
     54461          54461




到trace 文件中去找 block header dump


Block header dump:  0x06c0000d
Object id on Block? Y
seg/obj: 0xd4bd  csc: 0x00.ceb6eb  itc: 3  flg: E  typ: 1 - DATA
     brn: 0  bdba: 0x6c00009 ver: 0x01 opc: 0
     inc: 0  exflg: 0

Itl           Xid                  Uba         Flag  Lck        Scn/Fsc
0x01   0x0001.02b.000009ce  0x00000000.0000.00  C---    0  scn 0x0000.00ceb039
0x02   0x0000.000.00000000  0x00000000.0000.00  ----    0  fsc 0x0000.00000000
0x03   0x0000.000.00000000  0x00000000.0000.00  ----    0  fsc 0x0000.00000000

data_block_dump,data header at 0x7d7a27c
===============
tsiz: 0x1f80
hsiz: 0xc8
pbl: 0x07d7a27c
bdba: 0x06c0000d
     76543210
flag=--------
ntab=1
nrow=91
frre=-1
fsbo=0xc8
fseo=0x399
avsp=0x36a
tosp=0x36a
0xe:pti[0]      nrow=91 offs=0
0x12:pri[0]     offs=0x399


seg/obj: 0xd4bd =>54461