一次性kill -9

select f.PROGRAM, f.SID, f.STATUS, f.USERNAME, '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 = 'JDBC Thin Client'