DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: How long?

  1. #1
    Join Date
    Feb 2001
    Location
    Bangalore, India
    Posts
    109
    I have observed that there are many user sessions which are inactive .The logon time shows that they have been connected for a few days now. How can I find out for how long the session has been inactive?

    And also what is the difference between the status values of V$SESSION - Inactive and Snipe.

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    The time session has been idle can be determined from V$SESSION.LAST_CALL_ET. It shows the time (in seconds) since the session has isued its last call to the database.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Feb 2001
    Location
    Bangalore, India
    Posts
    109
    Thanks.

    When I saw the above columns data, it shows that the background processes never accessed the database from the startup.

    ????

  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Well, it is obvious that Oracle does not record background process's actions in this column. And why should it? It would be pure useless overhead. I belive recording of last calls of "normal" sessions in V$SESSION.LAST_CALL_ET was implemented primarily to support limiting session's idle times in profiles. And since background processes do not belong to any profile there is no need to record the time of their last calls.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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