Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to use hanganalyze". Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Now let the editor take you to learn how to use hanganalyze.

Hanganalyze and systemstate are still different, hanganalyze will have a clear waiting chain, waiting time, callstack, etc., relatively lightweight. Systemstate has more information than hanganalyze, there will be a lot of information about proces and session, and there will be information about shared pool, but it is difficult to look at the waiting chain.

1. Command

(1) single instance SQL > oradebug setmypid SQL > oradebug unlimit SQL > oradebug hanganalyze 3 1 minute 2 minute SQL > oradebug hanganalyze 3 1 minute 2 minute SQL > oradebug hanganalyze 3 (2). RACSQL > oradebug setmypid SQL > oradebug unlimit SQL > oradebug-g all hanganalyze 3 1 minute 2 minute SQL > oradebug-g all hanganalyze 3 1 minute 2 minute SQL > oradebug-g all hanganalyze 3

two。 Interpretation of trace files

(1) State of nodes

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

[894] / 0/895/60406/0xba362838/17792/NLEAF/261/264/ [908] / 1004

[908] / 0/909/3031/0xba3754c8/16376/LEAF/262/263//894

[1004] / 0/1005/23626/0xba3f61c8/18465/NLEAF/405/406/ [894] [908] / none

Nodenum: define the serial number of each session

Sid of sid:session

Serial# of sess_srno:session

Process ID of ospid:OS

Status of state:node

Adjlist: indicates blocker node

Predecessor: indicates waiter node

State has the following states:

(1) IN_HANG: if Session is in this state, it means that Session encounters deadlock or is in hung state.

(2) LEAF/LEAF_NW: these Session are usually "blocker" or "slow" node waiting for some resources, and these node can be easily identified by the field "predecessor".

(3) NLEAF: these Session are often thought of as "stuck" sessions, meaning that these Session are waiting for some Session resources. The blocker of the process can be easily defined through the field "adjlist".

(4) IGN/IGN_DMP: these Session are usually IDLE Session.

(5) SINGLE_NODE and SINGLE_NODE_NW is the same as leaf and leaf_nw, except that they do not depend on their processes

Based on the above information, it can be concluded that:

[1004] block [894] [908]

[894] block [908]

(2) process dependencies between CYCLES sessions in deadlock state

Cycle 1::-

(3) .Found blocker session, usually 1 session block a lot of session will be shown in this section

Found 21 objects waiting for Found 12 objects waiting for

(4). Chain waits for the session involved in the chain A wait chain means that one session is blocking one or more other sessions.

Open chains found:Chain 1::-

(5). Other chains found is not a process blocked by the chain of Open chains

Chain 2:: Chain 3:: Chain 4:: Chain 5:: Chain 6:: Chain 7:: at this point, I believe you have a deeper understanding of "how to use hanganalyze". You might as well do it in practice! Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.