EXPIRE TIME Parameter in SQLNET file of Oracle

Leave a reply

SQLNET.EXPIRE_TIME Parameter in SQLNET file of Oracle

Expire time parameter is used to limit the time of inactive connection between Server/Client connectivity. If connection is ideal for that particular time then it will disconnect by oracle with help of this parameter.
Default value of this parameter is 0 means unlimited and specify the value of time limit in this parameter is in minutes. If you specify value as 10 then its 10 minutes.
Oracle Net Services automatically uses the enhanced detection model and tunes the TCP keepalive parameters.

Note: It is client file so use this in Client side.

Default value

SQLNET.EXPIRE_TIME=0

Recommended

SQLNET.EXPIRE_TIME=10

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.