User Inactive for How Long????
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: User Inactive for How Long????

Hybrid View

  1. #1
    Join Date
    Sep 2000
    Posts
    362
    Hi,
    Is there any way I can find for how long the user has been inactive for.

    Thanks
    Anurag
    Share on Google+

  2. #2
    Join Date
    Feb 2001
    Posts
    389
    The only which i can think of is to ge t its Unix process id
    and do ps -ef to check the for how much time that session is sitting idle.
    Share on Google+

  3. #3
    Join Date
    Feb 2000
    Location
    New York,U.S.A.
    Posts
    245
    Try the following:

    col sid format 999
    col username format a10 truncated
    col status format a1 truncated
    col logon format a17
    col idle format a9
    col program format a30 truncated

    select
    sid,username,status,
    to_char(logon_time,'dd-mm-yy hh:mi:ss') "LOGON",
    floor(last_call_et/3600)||':'||
    floor(mod(last_call_et,3600)/60)||':'||
    mod(mod(last_call_et,3600),60) "IDLE",
    program
    from
    v$session
    where
    type='USER'
    order by last_call_et;


    Dragon
    Share on Google+

  4. #4
    Join Date
    Sep 2000
    Posts
    362
    Thanks a lot For ur help.
    It worked.

    Anurag
    Share on Google+

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