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

Thread: How to kill the session idle for last 30 minutes

  1. #1
    Join Date
    Sep 2006
    Posts
    114

    How to kill the session idle for last 30 minutes

    I want to kill all the sessions idle for last 1/2 hr
    How could i achieve this?
    can anybody help me in this regard?

    thanx in advance

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    use profiles

  3. #3
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    Use profiles or resource manager
    1) Create profile
    2) Limit session idle time to 30 min
    3) assign the profile to the users as needed
    See here
    http://download-uk.oracle.com/docs/c...htm#sthref2740

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