OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » Idle session killed (Oracle DB Release 9.2.0.5.0,Windows 2003 R2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Idle session killed [message #534537]

Wed, 07 December 2011 02:39

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

Report message to a moderator

Re: Idle session killed [message #534538 is a reply to message #534537]

Wed, 07 December 2011 02:42

Michel Cadot
Messages: 68734
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Idle session killed [message #534539 is a reply to message #534538]

Wed, 07 December 2011 02:48

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

Report message to a moderator

Re: Idle session killed [message #534543 is a reply to message #534539]

Wed, 07 December 2011 02:58

Michel Cadot
Messages: 68734
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Idle session killed [message #534547 is a reply to message #534539]

Wed, 07 December 2011 03:19

John Watson
Messages: 8964
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.

Report message to a moderator

Re: Idle session killed [message #534564 is a reply to message #534547]

Wed, 07 December 2011 05:38

ramoradba
Messages: 2457
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

Report message to a moderator

Re: Idle session killed [message #534566 is a reply to message #534564]

Wed, 07 December 2011 05:47

Michel Cadot
Messages: 68734
Registered: March 2007
Location: Saint-Maur, France, https...

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

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Yes ! you are correct !

Sriram

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 12 08:57:10 CST 2025