OraFAQ Forum: Client Tools » session times out every 10 minutes

Home » SQL & PL/SQL » Client Tools » session times out every 10 minutes (toad 9.0.1.8)

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

session times out every 10 minutes [message #422356]

Tue, 15 September 2009 14:17

miroconnect@yahoo.com
Messages: 196
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?

Report message to a moderator

Re: session times out every 10 minutes [message #422358 is a reply to message #422356]

Tue, 15 September 2009 14:44

Littlefoot
Messages: 17258
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Does the same happen in SQL*Plus too?

Report message to a moderator

Re: session times out every 10 minutes [message #422464 is a reply to message #422356]

Wed, 16 September 2009 12:20

miroconnect@yahoo.com
Messages: 196
Registered: April 2006

Senior Member

yes.

Report message to a moderator

Re: session times out every 10 minutes [message #422465 is a reply to message #422464]

Wed, 16 September 2009 12:23

Michel Cadot
Messages: 54719
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

Report message to a moderator

Re: session times out every 10 minutes [message #422466 is a reply to message #422465]

Wed, 16 September 2009 12:52

miroconnect@yahoo.com
Messages: 196
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 ?

Report message to a moderator

Re: session times out every 10 minutes [message #422467 is a reply to message #422356]

Wed, 16 September 2009 13:01

miroconnect@yahoo.com
Messages: 196
Registered: April 2006

Senior Member

I mean is there any hack which can prevent this session time out ?

Report message to a moderator

Re: session times out every 10 minutes [message #422474 is a reply to message #422467]

Wed, 16 September 2009 13:42

Michel Cadot
Messages: 54719
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

Report message to a moderator

Re: session times out every 10 minutes [message #422480 is a reply to message #422474]

Wed, 16 September 2009 14:22

miroconnect@yahoo.com
Messages: 196
Registered: April 2006

Senior Member

this will not help me I mean some thing automatic , like a script which is refreshed every 5 minutes ?

Report message to a moderator

Re: session times out every 10 minutes [message #422481 is a reply to message #422480]

Wed, 16 September 2009 14:38

Michel Cadot
Messages: 54719
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 20 05:58:35 CDT 2013

Total time taken to generate the page: 0.16833 seconds