怎么看到 dump的不对啊，还不懂

create table test01(id int,name int);

create bitmap index bm1 on test01(id);

insert into test01 values(1,11);

insert into test01 values(1,12);

insert into test01 values(1,13);

insert into test01 values(1,14);

insert into test01 values(1,15);

insert into test01 values(1,16);

insert into test01 values(1,17);

insert into test01 values(1,18);

insert into test01 values(1,19);

\orcl_ora_9848.trc

select owner,segment_name,tablespace_name,extent_id,block_id,file_id,blocks from dba_extents where wner='HT' and segment_name='BM1' and segment_type='INDEX';

select owner,segment_name,tablespace_name,extent_id,block_id,file_id,blocks from dba_extents where wner='SCOTT' and segment_name='BM1' and segment_type='INDEX';

alter system dump datafile 8 block min 336208 block max 336216;

d:\oralce11\diag\rdbms\orcl\orcl\trace\orcl_ora_34972.trc

select a.value || b.symbol || c.instance_name || '_ora_' || d.spid ||

               '.trc' trace_file

    from (select value from v$parameter where name = 'user_dump_dest') a,

               (select substr(value, -6, 1) symbol

                    from v$parameter

                  where name = 'user_dump_dest') b,

               (select instance_name from v$instance) c,

             (select spid

                     from v$session s, v$process p, v$mystat m

                   where s.paddr = p.addr

                      and s.sid = m.sid

                     and m.statistic# = 0) d

                     

                     d:\oralce11\diag\rdbms\orcl\orcl\trace\orcl_ora_32652.trc

直接打开trc文件，查看

tkprof     d:\oralce11\diag\rdbms\orcl\orcl\trace\orcl_ora_32652.trc D:\oralce11\222.txt

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28743704/viewspace-765605/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28743704/viewspace-765605/