select * from all_objects ao,v$session vs,v$locked_object vlo,
v&process vp where ao.object_id = vlo.object_id
and vlo.session_id=vs.sid
and vp.addr=vs.paddr
解锁
alter system kill session 'sid,serial#'
v&process vp where ao.object_id = vlo.object_id
and vlo.session_id=vs.sid
and vp.addr=vs.paddr
解锁
alter system kill session 'sid,serial#'