Search notes:

hangdiag.sql

This script dumps data required to diagnose hangs:

ASH dump
Systemstate dump with short callstacks
Hang analysis results (x$ksdhng_chains)

See also

oradebug hanganalyze

hangdiag.sql makes extensive use of oradebug direct_access