timeout setting for connections

[a128]

Hi,

Can someone tell me what parameter controls when to time out a SQL*Net connection?

Unlike what most people ask here, I am looking for a way NOT to time out connections to my DB because as part of a debugging process I need to keep a couple of DB connections indefinitely. I looked up CONNECT_TIMEOUT_ and TIMEOUT but don't think these two are the one.

I am running dedeicated server mode on Win2k.

Thanks,

[slimdave]

msybe you need to set expire_time=0. not sure though

[julian]

Originally posted by slimdave
msybe you need to set expire_time=0. not sure though

This parameter is used in SQLNET.ORA to detect dead connections. (S)he is asking on how to set a maximum or indefine time for session.

Here is how I do this:

CREATE PROFILE some_name_here
LIMIT SESSIONS_PER_USER 1
CONNECT_TIME 480
IDLE_TIME 60
FAILED_LOGIN_ATTEMPTS 3
PASSWORD_LIFE_TIME 31
PASSWORD_REUSE_TIME 365
PASSWORD_REUSE_MAX UNLIMITED;

Then grant this profile to the user.

The defaults are BTW UNLIMITED.

See that in this example the connect time is 480', i.e., 8 hours.

[slimdave]

i must have read the wrong documentation