Re: how can I know who has acquired an user lock?

Try this:

select ao.object_name,

vl.os_user_name, ao.owner,
vm.SESSION_ID,
vn.ORACLE_USERNAME from all_objects ao, v$locked_object vl where

   vl.object_id = ao.object_id;

This will give you the object_name as well.

~Bill

--
Posted via dBforums
http://dbforums.com