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.