一.Memory Dumps

(1)Global area

alter session set events 'immediate trace name global_area level n';---包含sga,pga,uga,indirect memory信息

(2)Library cache

alter session set events 'immediate trace name library_cache level n';---包含library cache,hash table histogram,object handle,object结构信息。

(3)Row cache

alter session set events 'immediate trace name row_cache level n';---包含rowcache,hash table histgram,object结构信息

(4)Buffers

alter session set events 'immediate trace name buffers level n';---包含buffer header,block header(contents,hash chain,users/waiters)

(5)Heap

alter session set events 'immediate trace name heap level n';---pga,sga,uga的内容摘要,cga,uga,lga内容摘要

(6)Process state

alter session set events 'immediate trace name process_state level n';

(7)System state

alter session set events 'immediate trace name system_state level n';

(8)Error state

alter session set events 'immediate trace name errorstat level n';

(9)Hang analysis

alter session set events 'immediate trace name hang_analysis level n';

(10)Work area

alter session set events 'immediate trace name work_area level n';

(11)Latches

alter session set events 'immediate trace name latches level n';

(12)Events

alter sesion set events 'immediate trace name events level n';---包含session,process,system信息

(13)Locks

alter session set events 'immediate trace name locks level n';

(14)Shared server process

alter session set events 'immediate trace name shared_server_state level n';

(15)Backgroud process

alter session set events 'immediate trace name backgroud_process level n';

二.File dump

(1)Block

alter session set events 'immediate trace name block level n';

alter system dump datafile file# block block#;

alter system dump datefile file# blcok min mininum_block# block max maxninum_block#;

(2)Tree dump

alter session set events 'immediate trace name tree_dump level n';

(3)Undo segment header

alter system dump undo_segment 'undo_segment_name';

(4)Undo for a transaction

alter system dump undo block 'segment_name XID xxxxx';

(5)File header

alter session set events 'immediate trace name file_header level n';

(6)Control file

alter session set events 'immediate trace name controlfile level n';

(7)Redo log header

alter session set events 'immediate trace name redohdr level n';

(8)Redo log

alter system dump logfile 'filename';

(9)Loghist

alter session set events 'immediate trace name loghist level n';

三.trace文件使用

设置alter system set sql_trace=false关闭产生.trc文件

(1)使用autotrace

set autotrace on|on statistics|on explain|traceonly|traceonly explain

(2)trace别的session

exec dbms_support.start_trace_in_session(sid=>xxx,serial=>xxx,wait=>true,binds=>true);

exec dbms_system.set_en(sid,serial#,10046,trace_level,'username');

摘自网络学习使用，如有侵权第一时间删除

ITPub博客

Oracle中的dump命令

最新文章