Hello,
I am trying to identify the inactive sessions in one of my database. V$Session (status) is not very helpful as the status of any conenction becomes inactive as soon as results are fetched.
Is there a way to find out when a particular session was last active (time), or for how long the session is in inactive mode.
In OEM, it is possible to click on session and see "Last Activity On", but, i am looking for a command that i can use for group of sessions.

Thanks in advance.