????select p.spid??c.object_name??b.session_id??b.oracle_username??b.os_user_name from v$process p??v$session a?? v$locked_object b??all_objects c where p.addr=a.paddr and a.process=b.process and c.object_id=b.object_id
????????????????????
????SELECT s.username??l.OBJECT_ID??l.SESSION_ID??s.SERIAL#??
????l.ORACLE_USERNAME??l.OS_USER_NAME??l.PROCESS
????FROM V$LOCKED_OBJECT l??V$SESSION S WHERE l.SESSION_ID=S.SID;
???????????????session_id?? serial#
????alter system kill session 'sid??serial#'; ??????sid=l.session_id??
????????????????