Expire_time Sqlnet.ora 19c [updated] Jun 2026

Add the following line to your sqlnet.ora file (located in $ORACLE_HOME/network/admin or the TNS_ADMIN directory):

SELECT username, osuser, machine, program, sqlnet_expire_time FROM v$session WHERE username = 'YOUR_APP_USER'; expire_time sqlnet.ora 19c

The expire_time parameter is a useful configuration option in the sqlnet.ora file for Oracle 19c, allowing administrators to manage idle connections and prevent resource leaks. However, its configuration requires careful consideration of application requirements and performance metrics to avoid unintended consequences. Add the following line to your sqlnet

lsnrctl reload

SQLNET.EXPIRE_TIME = 10 (minutes)