EXPIRE TIME Parameter in SQLNET file of Oracle

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

Advertisements

Leave a Reply

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

WordPress.com Logo

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

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s

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