Hello Ronni,

Set the connect_time parameter using the following statement
Alter profile profile_name limit connect_time time.

You can also change the parameters of a default profile of a user.
But that will be applicable to all the connections which will use that
particular user.
Assign the profile to the user you want to have a limited time access.
This might help you.

Thanks and regards,
Nancy
-----Original Message-----
From: Godfrey Ronni
[mailto:oracledba-ezmlmshield-x85913136.[Email address protected]
Sent: Thursday, September 29, 2005 3:31 PM
To: LazyDBA Discussion
Subject: timeout

Hi

How to set server timeout? The purpose is to stop query in the server if
it doesn't return in the defined time.

Ronni



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page