Tag Archives: Oracle Client

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