select f.LAST_CALL_ET,f.sql_id,f.USERNAME,f.status,f.PROGRAM,f.machine,f.CLIENT_INFO, f.SID,f.BLOCKING_SESSION, 'kill -9 ' || t.SPID
from v$process t, v$session f
where t.addr = f.PADDR
and f.sid in (SELECT sid
FROM v$lock t
WHERE (id1, id2, TYPE) IN
(SELECT id1, id2, TYPE FROM v$lock WHERE request > 0)
and t.REQUEST = 0)
and f.PROGRAM in ( 'JDBC Thin Client',
'm_RM.exe',
'plsqldev.exe'
)
order by 1 desc
from v$process t, v$session f
where t.addr = f.PADDR
and f.sid in (SELECT sid
FROM v$lock t
WHERE (id1, id2, TYPE) IN
(SELECT id1, id2, TYPE FROM v$lock WHERE request > 0)
and t.REQUEST = 0)
and f.PROGRAM in ( 'JDBC Thin Client',
'm_RM.exe',
'plsqldev.exe'
)
order by 1 desc