Home » SQL & PL/SQL » Client Tools » session times out every 10 minutes (toad 9.0.1.8)
session times out every 10 minutes [message #422356] Tue, 15 September 2009 14:17 Go to next message
miroconnect@yahoo.com
Messages: 199
Registered: April 2006
Senior Member
I am using toad 9.0.1.8 , every 10 minutes toad is idle it losses connection and I have to click on test connection to get back connection , please tell me how to solve this?
Re: session times out every 10 minutes [message #422358 is a reply to message #422356] Tue, 15 September 2009 14:44 Go to previous messageGo to next message
Littlefoot
Messages: 19526
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Does the same happen in SQL*Plus too?
Re: session times out every 10 minutes [message #422464 is a reply to message #422356] Wed, 16 September 2009 12:20 Go to previous messageGo to next message
miroconnect@yahoo.com
Messages: 199
Registered: April 2006
Senior Member
yes.
Re: session times out every 10 minutes [message #422465 is a reply to message #422464] Wed, 16 September 2009 12:23 Go to previous messageGo to next message
Michel Cadot
Messages: 58938
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Ask your DBA to change your profile but maybe he estimates that if you don't do anything during 10 minutes it is not worth to keep your session.

Regards
Michel
Re: session times out every 10 minutes [message #422466 is a reply to message #422465] Wed, 16 September 2009 12:52 Go to previous messageGo to next message
miroconnect@yahoo.com
Messages: 199
Registered: April 2006
Senior Member
is there any setting in toad or any script which runs at frequent intervals so that my session is not timed out ?
Re: session times out every 10 minutes [message #422467 is a reply to message #422356] Wed, 16 September 2009 13:01 Go to previous messageGo to next message
miroconnect@yahoo.com
Messages: 199
Registered: April 2006
Senior Member
I mean is there any hack which can prevent this session time out ?
Re: session times out every 10 minutes [message #422474 is a reply to message #422467] Wed, 16 September 2009 13:42 Go to previous messageGo to next message
Michel Cadot
Messages: 58938
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If it is in your profile, no.
Just click every 5 minuyes.

Regards
Michel
Re: session times out every 10 minutes [message #422480 is a reply to message #422474] Wed, 16 September 2009 14:22 Go to previous messageGo to next message
miroconnect@yahoo.com
Messages: 199
Registered: April 2006
Senior Member
this will not help me I mean some thing automatic , like a script which is refreshed every 5 minutes ?
Re: session times out every 10 minutes [message #422481 is a reply to message #422480] Wed, 16 September 2009 14:38 Go to previous message
Michel Cadot
Messages: 58938
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just execute dbms_lock.sleep when you do nothing but it is better to ask your DBA to change your profile instead of trying to find a silly workaround.

Regards
Michel

[Updated on: Wed, 16 September 2009 14:40]

Report message to a moderator

Previous Topic: sql worksheet script running
Next Topic: Scheduling an query to run at a particular time
Goto Forum:
  


Current Time: Sun Aug 31 05:49:37 CDT 2014

Total time taken to generate the page: 0.08360 seconds