Hi,

Are there any general tips on how to troubleshoot Oracle DB hanging or appear to be hanging? I have two DB on the same server, one appeared to be hanging while the other one is OK. For the hanging one, there is no unusual entries in the ALERT log, nor trace files. Listener.log file shows it is accepting connections to the hung DB. The sympton is that whenever a connection is made to the hung DB, it never returns anything...just stay as is. It was fixed by restarting it. I turned on ARCHIVELOG mode and started auto archiving last weekend but the ALERT log shows it's quite normal except there was nothing after 22:31 (unless I misread it):

---------
...
Mon Dec 09 20:33:18 2002
Thread 1 advanced to log sequence 2384
Mon Dec 09 20:33:18 2002
Current log# 5 seq# 2384 mem# 0: C:\ORACLE\ORADATA\SILICON1\REDO5A.LOG
Current log# 5 seq# 2384 mem# 1: C:\ORACLE\ORADATA\SILICON1\REDO5B.LOG
Mon Dec 09 20:33:19 2002
ARC1: Beginning to archive log# 4 seq# 2383
Mon Dec 09 20:33:20 2002
ARC1: Completed archiving log# 4 seq# 2383
Mon Dec 09 22:31:38 2002
ARC1: Beginning to archive log# 5 seq# 2384
Mon Dec 09 22:31:38 2002
Thread 1 advanced to log sequence 2385
Mon Dec 09 22:31:38 2002
Current log# 6 seq# 2385 mem# 0: C:\ORACLE\ORADATA\SILICON1\REDO6A.LOG
Current log# 6 seq# 2385 mem# 1: C:\ORACLE\ORADATA\SILICON1\REDO6B.LOG
Mon Dec 09 22:31:39 2002
ARC1: Completed archiving log# 5 seq# 2384
------ END OF ALERT LOG ------------

Does anybody have tips on what I can do to find out the possible source of problem?

Appreciated!