Re: Database hanging/crashing repeatedly

  • From: Sidney Chen <huanshengchen@xxxxxxxxx>
  • To: ashoke.k.mandal@xxxxxxxxxxxxx
  • Date: Thu, 6 Oct 2011 21:00:39 +0800

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: