ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Oracle中的dump命令

Oracle中的dump命令

原创 Linux操作系统 作者:jhondom 时间:2013-05-02 14:45:24 0 删除 编辑
一.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博客 ” ,链接:http://blog.itpub.net/20523441/viewspace-772682/,如需转载,请注明出处,否则将追究法律责任。

上一篇: Oracle RMAN命令
请登录后发表评论 登录
全部评论

注册时间:2013-04-21

  • 博文量
    15
  • 访问量
    23124