Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question.

Asked: March 21, 2017 - 4:36 pm UTC

Last updated: April 06, 2020 - 12:22 am UTC

Version: 11g R2

Viewed 1000+ times

You Asked

what is different between SQLNET.EXPIRE_TIME and SQLNET.INBOUND_CONNECT_TIMEOUT in easy meaning?
if How can I simulate above both parameter?

and Connor said...

EXPIRE_TIME is for a connection that has been established, and the database wants to know if that connection is still valid, ie, the client that established it is still present and capable of making requests to the database. When set, the database occasionally contacts the client over the network to ensure that it is still responding.

INBOUND_CONNECT_TIMEOUT is a connection parameter. When a client initiates a connection request, if something goes wrong during the connection to-and-fro between client and server, the INBOUND_CONNECT_TIMEOUT decides when we will abandon the connection attempt.


Rating

  (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

A reader, April 28, 2017 - 4:04 pm UTC

When to use INBOUND_CONNECT_TIMEOUT_LISTENER and INBOUND_CONNECT_TIMEOUT?

What's major difference both of them?
Connor McDonald
April 28, 2017 - 11:02 pm UTC

They are the similar but at different points in the flow of a connection.

INBOUND_CONNECT_TIMEOUT_LISTENER
- where the client is communicating with the *listener*

SQLNET.INBOUND_CONNECT_TIMEOUT
- where the client is now communicating with the *database*

So you could have a rule which is:

"You have 2 seconds to complete your communication with listener, and 5 seconds in order for the entire connection process to be completed"

Godwin, April 04, 2020 - 1:53 pm UTC

Thanks for the clarifications.
Want to know if the two parameters SQLNET.EXPIRE_TIME and SQLNET.INBOUND_CONNECT_TIMEOUT
should be set both the database server and the Oracle client server

or just at the database side.
Connor McDonald
April 06, 2020 - 12:22 am UTC

I generally dont set them unless I have to, but I do need to, I'll set them both sides, but that might just be my paranoia :-)