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

Thread: High Inactive sessions generate in few minutes

  1. #1
    Join Date
    May 2023
    Posts
    1

    High Inactive sessions generate in few minutes

    Suddenly high inactive sessions generate in database (10g). Can I clean those inactive sessions automatically from database end by changing some settings ? ...Please help !!!!

  2. #2
    Join Date
    Sep 2022
    Posts
    3
    Quote Originally Posted by PrasunKarar View Post
    Suddenly high inactive sessions generate in database (10g). Can I clean those inactive sessions automatically from database end by changing some settings ? ...Please help !!!!
    Why would you want kill inactive sessions? Inactive session means that someone is logged in but not executing SQL right at that instant. It is a normal state.
    Otherwise you can use a job/stored procedure that kill inactive sessions when last_call_et >= x minutes.

  3. #3
    Join Date
    Aug 2023
    Posts
    3
    Quote Originally Posted by dba_senior View Post
    Why would you want kill inactive sessions? Inactive session means that someone is logged in but not executing SQL right at that instant. It is a normal state.
    How to take phentermine 37.5 for best results?
    Otherwise you can use a job/stored procedure that kill inactive sessions when last_call_et >= x minutes.
    Agreed with you. You are right!
    Last edited by MartinGood; 08-22-2023 at 07:16 AM.

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