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 »