Results 1 to 4 of 4
  1. #1
    Join Date
    May 2011
    Posts
    19

    Unanswered: Performance_Locks_DML

    Hi,
    I got this error ORA-00054: resource busy and acquire with NOWAIT specified when trying to create a new table in Toad for Oracle 10.5. Therefore I was trying to find out the sessions that were blocking each other by using this code:

    select 'SID ' || l1.sid ||' is blocking ' || l2.sid blocking
    from v$lock l1, v$lock l2
    where l1.block =1 and l2.request > 0
    and l1.id1=l2.id1
    and l1.id2=l2.id2
    /

    and my problem is I don't know where to run this code so that it will show me the blocked sessions.

    Thank you in advance:

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    as you are using Oracle, it may be better to ask this question in the Oracle forum. however as that looks like SQL I'd expect the answer to be to execute the query in what ever query browser tool you have access to, whether thats an Oracle propriatory tool or a generic one such as HeidiSQL
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Quote Originally Posted by Delisha View Post
    and my problem is I don't know where to run this code so that it will show me the blocked sessions.
    You run that in the SQL client of your choice

  4. #4
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    Quote Originally Posted by Delisha View Post
    Therefore I was trying to find out the sessions that were blocking each other
    Your DDL is blocked by another user session. This is somehow strange, as you are trying a CREATE TABLE. Anyway, see here some notes on ORA-00054: Locks and ORA-00054 error
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •