INACTIVE sessions
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: INACTIVE sessions

  1. #1
    Join Date
    Nov 2005
    Location
    Brazil
    Posts
    22

    INACTIVE sessions

    When I query V$SESSION, I get the list connect users, there are two status: ACTIVE and INACTIVE. Question :
    Does the INACTIVE sessions use any part of the SGA memory ?

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    no, sessions never use SGA anyway (unless they are shared server connections)

  3. #3
    Join Date
    Nov 2005
    Location
    Brazil
    Posts
    22
    thanks a lot.

  4. #4
    Join Date
    Sep 2005
    Location
    Delhi
    Posts
    78
    Quote Originally Posted by davey23uk
    no, sessions never use SGA anyway (unless they are shared server connections)
    Ok. Does INACTIVE Sessions occupy any other memory like (PGA).
    IS it good to kill inactive sessions. if they r inactive for more than 5 hours.
    ~KD.DBA~

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    well define inactive?

    And generally no, they arent doing anything so arent consuming any resources.

    It may be part of a pool though so dont go around killing sessions just because you think they are inactive

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