oracle trace查看,怎么看oracle hang trace

主要关注CYCLES、BLOCKER SESSIONS、CHAINS等，每个trace文件都有可能不一样，需要具体分析。

以下摘自Interpreting HANGANALYZE Trace Files to Diagnose Hanging and Performance Problems for 9i and 10g. (Doc ID 215858.1)

The following example shows how to interpret each of the sections of a HANGANALYZE trace file:

*** 2002-05-13 17:02:30.937

==============

HANG ANALYSIS:

==============

CYCLES: This section reports the process dependencies between sessions that are in a deadlock condition. Cycles are considered “true” hangs.

Cycle 1 : :

<980/3887/0xe4214964/24065/latch free>

-- <2518/352/0xe4216560/24574/latch free>

-- <55/10/0xe41236a8/13751/latch free>

BLOCKER OF MANY SESSIONS: This section is found when a process is blocking a lot of other sessions. Usually when a process is blocking more that 10 sessions this section will appear in the trace file.

Found 21 objects waiting for

<55/10/0xe41236a8/13751/latch free>

Found 12 objects waiting for

<2098/2280/0xe42870d0/3022/db file scattered read>

Found 12 objects waiting for

<1941/1783/0xe41ac9e0/462/No Wait>

Found 12 objects waiting for

<980/3887/0xe4214964/24065/latch free>

OPEN CHAINS: This section reports sessions involved on a wait chain. A wait chains means that one session is blocking one or more other sessions.

Open chains found:

Chain 1 : :

<2/1/0xe411b0f4/12280/db file parallel write>

Chain 2 : :

<3/1/0xe411b410/12282/No Wait>

Chain 6 : :

<18/1631/0xe4243cf8/25457/db file scattered read>

-- <229/1568/0xe422b84c/8460/buffer busy waits>

Chain 17 : :

<56/11/0xe4123ce0/13755/latch free>

-- <2384/599/0xe41890dc/22488/latch free>

-- <32/2703/0xe41fa284/25693/latch free>

OTHER CHAINS: It refers to chains of blockers and waiters related to other sessions identified under “open chains”, but not blocked directly by the process reported on the "open chain".

Other chains found:

Chain 676 : :

<20/93/0xe411d644/13597/latch free>

Chain 677 : :

<27/1201/0xe41d3188/15809/latch free>

Chain 678 : :

<36/1532/0xe428be8c/4232/latch free>

-- <706/1216/0xe4121aac/23317/latch free>

Chain 679 : :

<43/12/0xe4122d54/13745/latch free>

Chain 680 : :

<80/2/0xe41290d4/13811/library cache pin>

-- <1919/1134/0xe421fdbc/3343/enqueue>

Additional DUMP detail: HANGANALYZE generates errorstack dumps for individual processes based on: the LEVEL used when the command is issued, and the STATE of the session. This part of the HANGANALYZE trace indicates which processes will be dumped if higher levels are used. It also indicates how many nodes will be dumped so you can measure the impact to the system (if too many errorstack dumps occur simultaneously, the disks serving the trace destination may become saturated). The “STATE DESCRIPTION” section of this document further explains the meaning of the states.

Extra information that will be dumped at higher levels:

[level 4] : 23 node dumps -- [LEAF] [LEAF_NW] [IGN_DMP]

[level 5] : 36 node dumps -- [NLEAF]

[level 10] : 130 node dumps -- [IGN]

STATE OF NODES: This section might be considered as the main section of the report. It shows all the sessions connected when the HANGANALYZE trace file was generated. This section essentially describes a dependency graph between nodes(known as an “adjacency list”), where each session is considered a node, and each node may have an “adjacent” node or a “predecessor” node related to it. Depending on the state of the node it may be a blocker, a waiter or a hung node. The “STATE DESCRIPTION” section of this document explains further the meaning of the states.

State of nodes

([nodenum]/sid/sess_srno/session/state/start/finish/[adjlist]/predecessor):

[0]/1/1/0xa6f8b0/IGN/1/2//none

[1]/2/1/0xa70230/IGN/3/4//none

[3]/4/1/0xa71530/IGN/5/6//none

[4]/5/1/0xa71eb0/IGN/7/8//none

[5]/6/1/0xa72830/IGN/9/10//none

[6]/7/1/0xa731b0/IGN/11/12//none

[7]/8/1/0xa73b30/IGN/13/14//none

[8]/9/1/0xa744b0/IGN_DMP/15/18/[130]/none

[9]/10/1/0xa74e30/IGN/19/20//none

[10]/11/4202/0xa757b0/IGN/21/22/[130]/none

[11]/12/1196/0xa76130/NLEAF/23/28/[49]/none

[12]/13/1/0xa76ab0/IGN/29/30/[130]/none

[37]/38/37/0xa85830/NLEAF/73/76/[50]/46

[46]/47/15/0xa8adb0/NLEAF/91/92/[37][50]/none

====================

END OF HANG ANALYSIS

====================