Re: Database hanging/crashing repeatedly

what's the server loading during the issue, CPU usage and run queue length,
 you can use sar to review. and is any top process found by ps/top, heavy
paging/swap during the issue?
next time see if you can login with prelim and do a system dump to help
sqlplus -prelim /nolog
SQL> conn / as sysdba
Prelim connection established
SQL> oradebug setmypid
Statement processed.
SQL> oradebug dump systemstate 1;
Statement processed.

you can use the os tool truss to trace sqlplus process, to see what's
waiting on, see note 760968.1
truss -o connect.out -f sqlplus / as sysdba

Sidney Chen


Other related posts: