To kill the inactive forms and sessions

SELECT p.spid,s.process,s.status,s.machine,

to_char(s.logon_time,'mm-dd-yy hh24:mi:ss') Logon_Time,

s.last_call_et/3600 Last_Call_ET,

s.action,s.module,s.sid,s.serial#

FROM

V$SESSION s, V$PROCESS p

WHERE

s.paddr = p.addr

AND s.username IS NOT NULL

AND s.username = 'APPS'

AND s.osuser = 'applprod'

AND s.last_call_et/3600 > 1

and s.action like 'FRM%'

and s.status='INACTIVE' order by logon_time;

          database

Select

'alter system kill session '''||s.sid||','||s.serial#||''';',s.action

FROM

V$SESSION s, V$PROCESS p

WHERE

s.paddr = p.addr

AND s.username IS NOT NULL

AND s.username = 'APPS'

AND s.osuser = 'applprod'

AND s.last_call_et/3600 > 1

and s.action like 'FRM%'

and s.status='INACTIVE';

          Forms

             

SELECT

' '||s.machine||' kill -9 '||s.process, s.action

FROM

V$SESSION s, V$PROCESS p

WHERE

s.paddr = p.addr

AND s.username IS NOT NULL

AND s.username = 'APPS'

AND s.osuser = 'applprod'

AND s.last_call_et/3600 > 1

and s.action like 'FRM%'

and s.status='INACTIVE';