Troubleshooting Oracle Hangs



TODO list:
  1. Simple hangs (single session is stuck)
  2. Complex hangs (lots of sessions or the whole instance or database is hung)
  3. How to read HANGANALYZE output?
  4. How to read PROCESS STATE / SYSTEMSTATE dump output?