一、select a.owner,
a.object_name,
a.subobject_name,
a.object_type,
l.session_id,
l.oracle_username,
l.os_user_name,
se.SID,
se.SERIAL#
from all_objects a, v$locked_object l,V$session se
where a.object_id = l.object_id
and se.OSUSER = l.os_user_name
and l.oracle_username = 'RD_USERPROFILE';
二、alter system kill session 'sid,serial#';--sid及serial#为第一步查出来的数据。