Hello,
I'm looking for a column in a v$-view to determine the last activity moment for a session. I want to locate "sleeping" session and optionally kill them.
In DBA Studio an item "Last Activity on [date]" is visible when you double click a session. That's the value I'm looking for.
Can you guys help me?
Thanks in advance.
This is what I have sofar:
Code:select username,sid,serial#,logon_time,status from v$session where status<>'ACTIVE' and logon_time < trunc(sysdate) order by logon_time