How to find out last activity time of a session
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How to find out last activity time of a session

  1. #1
    Join Date
    Feb 2004
    Posts
    35

    How to find out last activity time of a session

    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.

  2. #2
    Join Date
    Feb 2004
    Posts
    35
    nv mind...i think i got it...
    If there is any better way than the following, pls, let me know:

    select username, to_char(logon_time,'dd-mon hh24:mi'), status, last_call_et from v$session;

  3. #3
    Join Date
    Feb 2004
    Posts
    50
    Why do you want to identify inactive sessions?
    Is it because you want to kill them off?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width