Inactive Form Sessions

Inactive Form Sessions

set heading on

set line 9999

set pages 9999

col status for a8

col prog for a10

col username for a8

col module for a15

select p.sid,p.serial#, p.status,p.username,p.action,p.module,p.logon_time

from

(select distinct b.sid,b.serial# ,b.status,b.program,b.username,b.action,b.module,

to_char( b.logon_time, 'dd-MON-yyyy hh24:mi:ss' ) logon_time,

trunc( sysdate-b.logon_time ) "Dy",

trunc( mod( (sysdate-b.logon_time)*24, 24 ) )  "Hr",

trunc( mod( (sysdate-b.logon_time)*24*60, 60 ) )  "Mi",

trunc( mod( (sysdate-b.logon_time)*24*60*60, 60 ) ) "Sec"

from V$access a,v$session b, v$process c

where a.sid=b.sid

and b.paddr=c.addr

and b.status='INACTIVE'

and (b.action like '%FRM%' or b.action like '%frm%' or b.program like '%TOAD%' or b.program like '%toad%' or b.program like

'SQL%' or b.program like '%sql%' or b.program like '%FRM%'

or b.program like '%frm%' or b.action like 'SQL%' or b.action like 'sql%' or b.action like 'TOAD%' or b.action like 'toad%')

and (trunc( mod( (sysdate-b.logon_time)*24,24)) >=12 or trunc( sysdate-b.logon_time )>=1)) p order by p.logon_time;