SELECT distinct 'ALTER SYSTEM KILL SESSION '''||sid||','|| serial#||''';' from ( SELECT s.sid, s.serial#, s.username, s.schemaname, s.osuser, s.process, s.machine, s.terminal, s.logon_time, l.type FROM v$session s, v$lock l,v$locked_object a, dba_objects b WHERE s.SID = l.si...