«  
  »

Interpreting HANGANALYZE trace files to diagnose hanging and performance problems

作者: Maclean Liu , post on April 27th, 2008 , English Version
【本站文章除注明转载外，均为本站原创编译】
转载请注明：文章转载自: Oracle Clinic – Maclean Liu的个人技术博客 [http://www.oracledatabase12g.com/]
本文标题: Interpreting HANGANALYZE trace files to diagnose hanging and performance problems
本文永久地址: http://www.oracledatabase12g.com/archives/interpreting-hanganalyze-trace-files-to-diagnose-hanging-and-performance-problems.html

© 2008 – 2011, www.oracledatabase12g.com. 版权所有.文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.

相关文章 | Related posts:

  1. Case Study: Analyzing 10053 Trace Files
  2. EVENT 10051:”trace OPI calls”
  3. Getting a Stack Trace from a Oracle CORE file
  4. Setting an Oracle event:The structure of the trace syntax
  5. EVENT:10228 trace application of redo by kcocbk
  6. Cheat Sheet for UNDO/Rollback problems
  7. "hcheck.sql" script to check for known problems in Oracle8i, Oracle9i, Oracle10g and Oracle 11g
  8. Mount Options for Oracle files when used NFS with NAS devices
  9. EVENT:10226 trace CR applications of undo for data
Oracle, Oracle故障分析Troubleshooting   , , , ,  
«  
  »

1 comment to Interpreting HANGANALYZE trace files to diagnose hanging and performance problems

  • maclean
    August 27, 2011 at 11:39 PM · Reply

    [Hang Analyze Status]
    NO_SESSION there is no active session for this slot
    NOT_INWAIT chain ends in leaf node that is not in wait
    VOL_WAIT voluntary wait
    INVOL_WAIT involuntary wait with no callback specified
    UNDEFINED state is yet undetermined
    KSDNOD_INHANG this node is involved in a cycle
    PHANG_LEAF leaf node of a chain, no callback
    PHANG_NLEAF non-leaf in chain, no callback for leaf
    PHANG_LEAF_NW leaf node of a chain, not in wait
    HEUR_IGN ignored by employing heuristics
    HEUR_IGN_D dump one of many ignored by heuristics
    REMOTE_WAIT session also waiting for remote resources

Leave a Reply

  

  

  

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

«  
  »