Home » RDBMS Server » Networking and Gateways » Idle session killed (Oracle DB Release 9.2.0.5.0,Windows 2003 R2)
icon4.gif  Idle session killed [message #534537] Wed, 07 December 2011 02:39 Go to next message
Sami_Younis
Messages: 49
Registered: February 2008
Location: Egypt
Member

Hi everybody
could anyone help me to solve this issue ....

Application users(i.e toad or whatever the client software) disconnected from oracle and need to relogin
after being idle for sometime.
I am working on the default profile and idle_time is set to unlimited
also, i tried to set sqlnet_expire_time in sqlnet.ora
but no way.

Thanks in advance,
Sami
Re: Idle session killed [message #534538 is a reply to message #534537] Wed, 07 December 2011 02:42 Go to previous messageGo to next message
Michel Cadot
Messages: 67884
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is not clear if you want the sessions to be killed after idle time or if the sessions are actually killed.

Quote:
also, i tried to set sqlnet_expire_time in sqlnet.ora

What does this mean? What did you try? To achieve what?

Regards
Michel
Re: Idle session killed [message #534539 is a reply to message #534538] Wed, 07 December 2011 02:48 Go to previous messageGo to next message
Sami_Younis
Messages: 49
Registered: February 2008
Location: Egypt
Member

-- I know that this parameter detect the time after which oracle check the clinet and disconnect the session if there is no activity
Am i wrong?
thanks,
Sami
Re: Idle session killed [message #534543 is a reply to message #534539] Wed, 07 December 2011 02:58 Go to previous messageGo to next message
Michel Cadot
Messages: 67884
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, you are wrong.
It does not check session activity but network connection availability.
And you didn't answer my questions.

Regards
Michel
Re: Idle session killed [message #534547 is a reply to message #534539] Wed, 07 December 2011 03:19 Go to previous messageGo to next message
John Watson
Messages: 8560
Registered: January 2010
Location: Global Village
Senior Member
If you look sqlnet.expire_time in the docs, you will find it does not do what you think.

But it can sometimes help, for a very different reason. If your users are conencting through a fiewall or over a VPN, the firewall/VPN may be configured to break idle sessions. You need to talk to your network administrators about this. Sometimes setting the sqlent.expire_time can prevent this, because it will send a message avery few seconds which may force the firewall/VPN to keep the session open. No guarantee, though.
Re: Idle session killed [message #534564 is a reply to message #534547] Wed, 07 December 2011 05:38 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Or write a shell script to kill idle sessions and make it as a cron job.
You should be very careful in this ...

Sriram
Re: Idle session killed [message #534566 is a reply to message #534564] Wed, 07 December 2011 05:47 Go to previous messageGo to next message
Michel Cadot
Messages: 67884
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I'm not sure he wants to kill the sessions, maybe the sessions are killed and he wants to prevent this. So my first and still unanswered question.

Quote:
Application users(i.e toad or whatever the client software) disconnected from oracle and need to relogin after being idle for sometime.

Is this a statement or a requirement?

Regards
Michel

[Updated on: Wed, 07 December 2011 06:12]

Report message to a moderator

Re: Idle session killed [message #534567 is a reply to message #534566] Wed, 07 December 2011 06:03 Go to previous message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Yes ! you are correct !

Sriram
Previous Topic: one listener or more listener?
Next Topic: changing listerner.ora name
Goto Forum:
  


Current Time: Fri Jun 18 07:42:47 CDT 2021