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

  • From: dd yakkali <dd.yakkali@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 28 Oct 2009 13:24:57 -0400

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@xxxxxxxxxxxxxx> 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
>
>
>
>
>
>
>
>
>
--
//www.freelists.org/webpage/oracle-l


Other related posts: