SELECT s.username,l.SESSION_ID,s.SERIAL#,oa.object_name,S.MACHINE,S.PROGRAM,a.sql_text,
l.OS_USER_NAME,l.PROCESS,'alter system kill session '''||l.SESSION_ID||','||s.SERIAL#||''';'
FROM V$LOCKED_OBJECT l,V$SESSION S ,dba_objects oa ,v$sqlarea a
WHERE l.SESSION_ID=S.SID and oa.object_id = l.object_id and s.prev_sql_addr = a.address ;
锁表语句解锁sql
如果有数据执行最后一列的alter语句即可