Home » SQL & PL/SQL » SQL & PL/SQL » Session killing automatically
Session killing automatically [message #20838] Tue, 25 June 2002 04:31 Go to next message
bharath
Messages: 30
Registered: November 2000
Member
hai,
how can i kill a session automatically which is not performing any operation for more than 5 minutes.
thanks
bharath
Re: Session killing automatically [message #20845 is a reply to message #20838] Tue, 25 June 2002 09:08 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Look in the documentation under "profile". You can create a profile with an idle time of 5 minutes and then assign this profile to users.

create profile limit_idle_time
 limit idle_time 5;
Previous Topic: URGENT !!! drop a user ???
Next Topic: help in simple select statement (regarding chr(10) or line break usage)
Goto Forum:
  


Current Time: Tue Apr 16 13:52:15 CDT 2024