| Inactive Form Session [message #430497] |
Tue, 10 November 2009 13:30 |
ma1234
Messages: 1
Registered: November 2009
|
Junior Member |
|
|
I am trying to capture inactive form sessions and kill those.
BUT I don't see 'FRM:%' under V$SESSION.ACTION field using the following query. Instead ACTION field show form name.
Any idea.
SELECT machine,sid,serial#, SUBSTR(program,1,20) program, action,status,
TO_CHAR(logon_time,'DD-MON-YY HH24:SS') Login_Time,
TO_CHAR(SYSDATE-last_call_et/86400,'DD-MON-YY HH24:SS')
Last_Activity,
process pid
FROM v$session
WHERE action LIKE 'FRM%';
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
