When does an INACTIVE session disappear from V$SESSION?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: When does an INACTIVE session disappear from V$SESSION?

  1. #1
    Join Date
    Apr 2001
    Posts
    257

    When does an INACTIVE session disappear from V$SESSION?

    I have a front end Java application server (Resin) running which connects to my Oracle DB 8.1.7.3. I notice when I query V$SESSION, the number of INACTIVE sessions is growing. Their TADDR entry is Null so no locks are placed on objects for the inactive sessions. My question is:

    When does an INACTIVE session disappear from V$SESSION?

    Thanks,

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    INACTIVE does not indicate the session is terminated. It means the user is not performing any operation at this moment.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  3. #3
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796

    Re: When does an INACTIVE session disappear from V$SESSION?

    Originally posted by a128
    When does an INACTIVE session disappear from V$SESSION?
    When the session is closed.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

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