Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

automated kill Inactive session script

User356375Jan 6 2011 — edited Feb 28 2011
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;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 28 2011
Added on Jan 6 2011
10 comments
11,811 views