如何使用oracle的dump方式 – 数据库 – 前端

Oracle 11g的Trace文件存放路径：oracle\diag\rdbms\**\**\trace

1、DUMP出控制文件

alter system (session) set events ‘immediate trace name controlf level 10’

—————————————————————————————

2、DUMP出日志文件分析

alter system dump logfile logfilename;

—————————————————————————————

3、DUMP出日志文件头分析

alter session set events ‘immediate trace name REDOHDR level 10’

———————————————————————————

4、DUMP出LIBRARY CACHE

alter system (session) set events ‘immediate trace name library_cache level 10’

—————————————————————————————

5、 DUMP出share_pool

alter system (session) set events ‘immediate trace name heapdump level 10’

———————————————————————————

6、DUMP出所有数据文件头

alter system (session) set events ‘immediate trace name file_hdrs level 10’;

———————————————————————————

7、DUMP出数据文件（只能是alter system）

alter system dump datafile n block m

如

select file_id,block_id,blocks from dba_extents where segment_name=’EMPLOYEES’

FILE_ID BLOCK_ID BLOCKS