oracle 常用的dump 命令

1、dump数据文件块，转储数据文件n的块m
alter system dump datafile n block m

oradebug dump datafile n block m
2、dump日志文件
alter system dump logfile logfilename;

oradebug dump logfile 3
3、dump控制文件的内容
alter session set events 'immediate trace name CONTROLF level 10'

oradebug dump CONTROLF 10
4、dump所有数据文件头
alter session set events 'immediate trace name FILE_HDRS level 10'

oradebug dump FILE_HDRS 10
5、dump日志文件头
alter session set events 'immediate trace name REDOHDR level 10'

oradebug dump REDOHDR 10

6、dump系统状态

alter session set events 'immediate trace name SYSTEMSTATE level 10'

oradebug dump SYSTEMSTATE 10

7、dump进程状态

alter session set events 'immediate trace name PROCESSSTATE level 10'

oradebug dump PROCESSSTATE 10

8、dump Library Cache
alter session set events 'immediate trace name library_cache level 10'

oradebug dump library_cache 10

[@more@]

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

转载于:http://blog.itpub.net/36779/viewspace-888488/