Re: ORA-00054: resource busy and acquire with NOWAIT specified

From: dd yakkali <dd.yakkali_at_gmail.com>
Date: Wed, 28 Oct 2009 13:24:57 -0400
Message-ID: <1c8f76b90910281024me2ecdefm97d5e4280bbc5128_at_mail.gmail.com>

THanks for the all the replies and explanation. I was more hung up on number of rows that are deleted rather than the process of deletion.

Thanks again for the explanation.
-Deen

On Wed, Oct 28, 2009 at 12:12 PM, Hemant K Chitale <hkchital_at_singnet.com.sg> wrote:
>
> The transaction is "defined" when the DML starts.  It doesn't matter if it
> ends up deleting 1million rows  or 0rows.  It is still a transaction holding
> a Transaction Lock.  This prevents DDL on the table.
>
> Hemant K Chitale
>
> At 05:09 AM Wednesday, you wrote:
>>
>> Hello gurus,
>>
>> When session1 deleted 0 records, it should not be placing any locks on
>> the table correct? I do not understand why I got the error. Am I
>> missing some basic concept?
>>
>> When I did a rollback on the session1 then session2 was able to
>> truncate the table.
>>
>> Thanks
>> Deen
>
>
>
>
>
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Oct 28 2009 - 12:24:57 CDT