Connection TimeOut

[rshivagami]

How do I set the connection timeout on server? I want the client sessions to be indefinitely open without the server terminating them .

Thanks.

[Horace]

To prevent sql net timeouts through a firewall (for instance) put this in the sqlnet.ora file on the database server.


SQLNET.EXPIRE_TIME = 10

This forces the server to send an ip packet every 10 minutes to each client to see if it is still there. This ip packet keeps the session open

[marist89]

Originally posted by rshivagami
How do I set the connection timeout on server? I want the client sessions to be indefinitely open without the server terminating them .

Thanks.

That's the default behaviour in a typical client server situation. Are you going through a firewall?

[DaPi]

Make sure too that resource management hasn't a max idle time set.