Problems / Issues :
USE_NL hint and performs better without the hint or with a USE_HASH or USE_MERGE hint.
Database Hang or Slowdown : If required check Oracle Performance Diagnostic Guide
One or more session hanging : Gather 10046 trace
RDA(4.2) : Install RDA(4.2) , set the ORACLE_SID
./rda.sh -vX RDA::Remote setup_cluster
./rda.sh -v -e REMOTE_TRACE=1
For node comparison : ./rda.pl -T diff:A:myset,1
OEM 12c Real-Time ADDM : Performance --> Real time
System Profiler : To check bottle neck outside Oracle
LTOM : Real time monitoring / diagnostic
Automatic Session Tracing and Automatic Hang Detection
OSWatcher(OSW) : tar xvf osw.tar
Trace Analyzer : TRCANLZR Analyze sql traces with binds or waits
PL / SQL Profiler : Lin es of code taking longer
SQLTXPLAIN.SQL : sqcreate.sql : Options Xplain , Xtract and Xecute
Error Stack : connect sys/sys as sysdba
oradebug setospid <SPID>
oradebug unlimit
oradebug dump errorstack 3
oradebug dump errorstack 3
oradebug dump errorstack 3
RACdiag : $ORAC_CRS_HOME/bin/diagcollection.pl -- collect --all
AWR : AWR from each node
oradebug
hanganalyze :
Database Hang or Slowdown : If required check Oracle Performance Diagnostic Guide
One or more session hanging : Gather 10046 trace
RDA(4.2) : Install RDA(4.2) , set the ORACLE_SID
./rda.sh -vX RDA::Remote setup_cluster
./rda.sh -v -e REMOTE_TRACE=1
For node comparison : ./rda.pl -T diff:A:myset,1
OEM 12c Real-Time ADDM : Performance --> Real time
System Profiler : To check bottle neck outside Oracle
LTOM : Real time monitoring / diagnostic
Automatic Session Tracing and Automatic Hang Detection
OSWatcher(OSW) : tar xvf osw.tar
Trace Analyzer : TRCANLZR Analyze sql traces with binds or waits
PL / SQL Profiler : Lin es of code taking longer
SQLTXPLAIN.SQL : sqcreate.sql : Options Xplain , Xtract and Xecute
Error Stack : connect sys/sys as sysdba
oradebug setospid <SPID>
oradebug unlimit
oradebug dump errorstack 3
oradebug dump errorstack 3
oradebug dump errorstack 3
RACdiag : $ORAC_CRS_HOME/bin/diagcollection.pl -- collect --all
AWR : AWR from each node
oradebug
hanganalyze :