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