首页 > 数据库 > Oracle > HANGANALYZE


原创 Oracle 作者:zhyuh 时间:2007-12-06 15:01:46 0 删除 编辑

When a database has severe performance problems, the cause of the problem may be a HANG. Using trace files produced by HANGANALYZE, you will be able to quickly determine if two or more processes are deadlocked and how many other processes may be affected. By using HANGANALYZE, you may also determine if a performance analysis will be required to diagnose the real problem when a HANG is taking place.


Steps to generate HANGANALYZE trace files -- Metalink 175006.1

Interpreting HANGANALYZE trace files to diagnose hanging and performance problems -- Metalink 215858.1

来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

下一篇: min(), max()和index
请登录后发表评论 登录
  • 博文量
  • 访问量