Thanks for the reply..

Is it also possible to get the row # or ROWID which is locked..
This is the scenario..

There is a table Fred has a primary key emp_no,
I try to lock the row emp_no = 20 to update by doing 'select for update nowait' but it turned out it is locked I want to know this row is locked by which user inorder to display information to the user..

How can I do that?