How to find the user name who locked the specific record
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: How to find the user name who locked the specific record

Hybrid View

  1. #1
    Join Date
    Dec 2006
    Posts
    1

    How to find the user name who locked the specific record

    I need to findout who(SID,USERNAME) locked the same
    ROW (not table).
    There are many users who are locking different rows of the
    same table at the same time.
    I need to find the one who locked my row.
    I don't want to lock my session as waitting session.
    While issuing select statement with for update nowait

    It returns with error:
    ORA-00054 Resource busy acquire with nowait specified

    I can able to find out whether the particular row is locked by another user
    I need to find the one who locked my row.


    Example :

    user 1:

    update emp set sal = sal * 10 where empno = 100


    user 2:

    update emp set sal = sal * 10 where empno = 101

    user 3:

    If user 3 isues update for the emp no 100 then it will goes to waitting session.
    But i need to know the user name who locked the empno 100 without locking my session;

    Thanks,
    Abdeen.

  2. #2
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    dba_waiters
    dba_blockers
    Assistance is Futile...

Posting Permissions

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


Click Here to Expand Forum to Full Width