Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2016
    Posts
    20

    Unanswered: query to find out the idle time of a user session .

    Hello All ,

    Can anybody to help/share me to find out the idle time of user session .

    Thanks

    Prashant

  2. #2
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    394
    Provided Answers: 1
    Hi Prashant,


    I would try something like this
    Code:
    select sid,username,current-dbinfo("utc_to_datetime",last_run_time) as ide_time
    from systcblst t,sysrstcb r
    where t.tid = r.tid
    the idle is given in an INTERVAL type, you can cast it to INTEGER if necessary

Posting Permissions

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