OraFAQ Forum: SQL & PL/SQL » sql query timeout for remote DB

Home » SQL & PL/SQL » SQL & PL/SQL » sql query timeout for remote DB

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

sql query timeout for remote DB [message #20259]

Thu, 09 May 2002 04:46

Deepak
Messages: 111
Registered: December 1999

Senior Member

Hi,

How can i set timeout while querying on remote DB.

Report message to a moderator

Re: sql query timeout for remote DB [message #20261 is a reply to message #20259]

Thu, 09 May 2002 09:40

Su
Messages: 154
Registered: April 2002

Senior Member

You can set it up thru Net8 Assistant also. Go to profile set up in the Net8 Configuration Assistant and set the timeout value you want it to. Try it out.
Hope it resolves your problem.

Good luck :)

Report message to a moderator

Re: sql query timeout for remote DB [message #20265 is a reply to message #20259]

Thu, 09 May 2002 11:02

andrew again
Messages: 2577
Registered: March 2000

Senior Member

You can control it at the server level through "profiles". Be careul though - you don't want to set a limit which will be hit for normal queries when the server is busy, else the user will probably just submit the query again.
http://oradoc.photo.net/ora817/DOC/server.817/a76956/users.htm#1160

Report message to a moderator

Previous Topic:	Re: create sql extention on notepad
Next Topic:	Using PL/SQL to generate an xls file at specified time intervals

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 22:19:27 CDT 2024