automated kill Inactive session script
I want schedule the inactive session kill script to windows box?
any one knows how can implement the script and works as automatically.
I have bleow script but how can implement for Windows
set time on
set lines 100
set pages 50
column userinfo heading "ORACLE/OS User" format a21
column terminal heading "Term" format a12
column process heading "Parent|Process ID" format a10
column spid heading "Shadow|Process ID" format a10
column seq# heading "Wait|Sequence" format 99999990
select s.username||' '||s.osuser userinfo, s.terminal, s.sid, s.serial#,
p.spid,s.process,s.logon_time
from v$session s, v$process p,v$session_wait w
where p.addr = s.paddr
and s.sid = w.sid
and w.event = 'SQL*Net message from client'
and s.status = 'INACTIVE'
order by s.osuser, s.terminal;