kill

--kill
SELECT 'alter system kill session '''||to_char(t.SID)||','||to_char(t.SERIAL#)||''''||';' ||'/*'||t.USERNAME
||
  case
  when T.SECONDS_IN_WAIT > 96400 then
       ' Dias:'|| trunc( T.SECONDS_IN_WAIT /60/60/24)  
  when T.SECONDS_IN_WAIT > 3600 then
       ' Horas:'|| trunc( T.SECONDS_IN_WAIT /60/60)
  when T.SECONDS_IN_WAIT > 60 then
       ' Minutos:'|| trunc( T.SECONDS_IN_WAIT /60)
  else
       ' Seg:'||  T.SECONDS_IN_WAIT
  end
||' '||t.OSUSER
||' '||t.MACHINE
||' '||t.TERMINAL
||' '||t.USERNAME
||' '||t.PROGRAM
||' '||t.MODULE
||' '||t.CLIENT_INFO
||'*/' cmd
FROM v$session t
WHERE --t.USERNAME = 'PEDRO' AND
      T.STATUS = 'INACTIVE'
AND   T.SECONDS_IN_WAIT > 900
and t.USERNAME is not null
order by T.SECONDS_IN_WAIT desc;