chao_ping,
Read MetaLink Doc Id 166924.1. It offer some insights into this kind of
"Self Deadlocks". Here is an excerpt.
1. Self Deadlocks
It occur when one session tries to get a lock on a resource that he already
has in some way. Normally, the Oracle engine should detect those situations
and
hi, friends:
>>>select count(*) into :b0 from USERCONFIRMINFO where USER_ID=:b1
>>>The following deadlock is not an ORACLE error. It is a
>>>deadlock due to user error in the design of an application
>>>or from issuing incorrect ad-hoc SQL. The following
>>>information may aid in d