ksudps() prints processtate, it might be worth to start with this one if
your system is hung and proceed from there.
Those three functions are the only three which ever should be called
directly and only in very extreme circumstances when even connect as sysdba
doesn't work. And before resorting to that, a direct attach sga program,
dumping v$session_wait should be done before (if not using 10gR2's EM direct
attach mode). Several versions of such program are available from internet.
Tanel.
Update: Actually, calling ksudss from adb did produce a trace file. Unfortunately, adb never returned control to the shadow process and consequently generated a 16gb trace file (only completed because I bounced the database). That was interesting. I was positive hanganalyze dumps were not that big. =)You are right, hanganalyze dumps are not that big. Actually, when you call ksudss(), it produces systemstate dump. If you want hanganalyze trace, you need to call ksdhng() instead.
-- Egor http://www.oracledba.ru -- //www.freelists.org/webpage/oracle-l
-- //www.freelists.org/webpage/oracle-l