----用这个可以查:
select b.sid,b.serial#,a.sql_text,b.sid,b.MACHINE,b.PROGRAM
from v$sqlarea a,v$session b,v$locked_object c
where a.address = b.sql_address and b.sid = c.SESSION_ID;
--select a.sid,a.serial#,a.machine,a.program,b.sql_text from
--v$session a,v$sqltext b,v$lock c where a.sid=c.sid and a.sql_address=b.address;
--connect system/manager@oracle;
--alter system kill session 'session.id,serial#';
select s.sid,s.machine,o.object_name,l.oracle_username,l.locked_mode,
'ALTER SYSTEM KILL SESSION '''||s.sid||', '||s.serial#||''';' Command
from v$locked_object l,v$session s,all_objects o
where l.session_id=s.sid and l.object_id=o.object_id