Hanganalyze ,system state dump,v$wait_chains in Oracle

Many times Oracle database get hangs due to locks or latching issue and Nobody can login to the system. It becomes critical and  And Usually we do shutdown abort to immediately resolve the issue. But  it is good to take system state dump/hanganalyze  at 1 min interval to analyze the locking or latching  issue afterwards …

Hanganalyze ,system state dump,v$wait_chains in Oracle Read More »