Home » RDBMS Server » Server Administration » Timeouts
Timeouts [message #61886] Tue, 08 June 2004 17:54 Go to next message
IA
Messages: 91
Registered: March 2004
Member
Hi,

 

I am running Oracle 9i on a Sun Solaris platform.

 

I would like to control maximum idle time allowed for each session. If exceeded, I want to disconnect these users from the database.

 

How can I do that?

 

Thanks ... IA
Re: Timeouts [message #61888 is a reply to message #61886] Tue, 08 June 2004 20:01 Go to previous messageGo to next message
Deepak Panda
Messages: 24
Registered: May 2004
Junior Member
Use profiles
Re: Timeouts [message #61894 is a reply to message #61886] Tue, 08 June 2004 23:34 Go to previous message
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
Senior Member
Hi,

Well along with the profile option you can also use timeout parameter in ur sqlnet file. after setting this server will try to contact the client after the amount of time set by this parameter and if client doesn't respond than server will kill its session.

Daljit Singh.
Previous Topic: Listener problem - oracle 9.2.0.1.0 on AIX 5.2
Next Topic: Facts on cluster indexing in Oracle
Goto Forum:
  


Current Time: Wed Jan 22 23:08:46 CST 2025