Re: Database hanging/crashing repeatedly
From: Sidney Chen <huanshengchen_at_gmail.com>
Date: Thu, 6 Oct 2011 21:00:39 +0800
Message-ID: <CAM_ddu8XS=z2fyUii6uhYAeK3df5zcPuROfmyA26y+HZrjg5nQ_at_mail.gmail.com>
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 analysis
sqlplus -prelim /nolog
SQL> conn / as sysdba
Prelim connection established
SQL> oradebug setmypid
Statement processed.
SQL> oradebug dump systemstate 1;
Statement processed.
Date: Thu, 6 Oct 2011 21:00:39 +0800
Message-ID: <CAM_ddu8XS=z2fyUii6uhYAeK3df5zcPuROfmyA26y+HZrjg5nQ_at_mail.gmail.com>
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 analysis
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
--
Regards
Sidney Chen
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Oct 06 2011 - 08:00:39 CDT