deadlock problem

From: <h.jalalipoor_at_gmail.com>
Date: 21 Nov 2006 22:34:16 -0800
Message-ID: <1164177256.919656.49280@m7g2000cwm.googlegroups.com>

I have oracle 9.2.0.3 on HP9000 PA-RISC 64Bit (12GB RAM and 6 CPU). database size is about 100GB and active users is about 200 user. when a deadlock detected, my database hang for a few minutes, no body can`t do any thing even dba. I want to connect as sysdba from SQL*Plus but i can`t and SQL*Plus wait until deadlock detection resolved by oracle.
my question is what happen on database when a deadlock detected? is it a bug or it is normal?

best regards. Received on Wed Nov 22 2006 - 00:34:16 CST