Autonomous transactions and deadlocks

From: <rajugaru.vij_at_gmail.com>
Date: Mon, 25 Mar 2013 07:56:37 +0000
Message-ID: 2026440400-1364198193-cardhu_decombobulator_blackberry.rim.net-1244592215-_at_b28.c12.bise7.blackberry>

Hi,
Can someone explain me, why does AT cause deadlocks.

Eg: I updated a table x in session 1 and want to update same from session 2 but with AT. It goes into deadlock. But normal update works fine. I am not quite understanding the locking mechanism. Gone through docs, but not clear, or unable to understand. Can some one help please?

Thanks
Sent on my BlackBerry®--
http://www.freelists.org/webpage/oracle-l Received on Mon Mar 25 2013 - 08:56:37 CET