Originally posted by miritika

Please try using v$locked_object table.

Hope this helps u.
This only displays which session has a lock on which table, you can't get the information *which row* is locked by which session. There is no way to find out which row is locked by which session, unless you do a database block dump read it from there. But I don't think this is a very usefull way to get this info....