Re: Autonomous transactions and deadlocks
Date: Mon, 25 Mar 2013 13:13:14 +0000
Message-ID: 160825890-1364217195-cardhu_decombobulator_blackberry.rim.net-1147895951-_at_b28.c12.bise7.blackberry>
Version 10g R2..
AT when working with bitmap index..
Thanks
Sent on my BlackBerry®
-----Original Message-----
From: Hans Forbrich <fuzzy.graybeard_at_gmail.com>
Sender: oracle-l-bounce_at_freelists.org
Date: Mon, 25 Mar 2013 06:43:14
To: <oracle-l_at_freelists.org>
Reply-To: fuzzy.graybeard_at_gmail.com
Subject: Re: Autonomous transactions and deadlocks
On 25/03/2013 1:56 AM, rajugaru.vij_at_gmail.com wrote:
> 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?
I assume you are trying to avoid the mutating table problem while trying
to update the same table twice from different transactions. If so, you
might describe the requirement in detail to get a reasonable alternative.
Depending on he exact problem, you may be tripping over locks on the supporting structures such as constraints or indexes, rather than just locks on the table.
Which version of Oracle Server? New versions have techniques to get around the issue.in triggers.
/Hans
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Mon Mar 25 2013 - 14:13:14 CET