-
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.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|