Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Deadlock on different tables

oradba11Feb 18 2013 — edited Feb 18 2013
Hi,

I am working on 11g and AIX...We got deadlock recently and we need to investgate why it happen and resolution, so it will not happen in future..
When we saw deadlock trace file ,it shows 2 sqls queries on different tables..and lock is execlusive lock.

----- Information for the OTHER waiting sessions -----

SELECT 1 FROM HOS_DTL WHERE ( HOS_LCN_DTL.HOS_LCN_DTL_ID = :1 ) FOR UPDATE WAIT 180

and

----- Current SQL Statement for this session ------

DELETE FROM EI_INV WHERE ( EI_INV.EI_INV_ID = :1 )


But these two tables not related at all 'HOS_DTL' and 'EI_INV' .
Can deadlock happen if sqls queries fired on those table are not related at all and deadlock
trace file can show those two sqls ..?

Any idea....
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 18 2013
Added on Feb 18 2013
7 comments
524 views