Oracle DB verion: 19c
OS : RHEL 7.9
I am trying to explain to a developer what SQLNET.EXPIRE_TIME setting in sqlnet.ora file does.
19c documentation says :
SQLNET.EXPIRE_TIME specifies a time interval, in minutes, to send a check to verify that client/server connections are active.
The documentation goes on to say
Setting a value greater than 0 ensures that connections are not left open indefinitely, due to an abnormal client termination. If the system supports TCP keepalive tuning, then Oracle Net Services automatically uses the enhanced detection model, and tunes the TCP keepalive parameters
If the probe finds a terminated connection, or a connection that is no longer in use, then it returns an error, causing the server process to exit.
https://docs.oracle.com/en/database/oracle/oracle-database/19/netrf/parameters-for-the-sqlnet.ora.html#GUID-2041545B-58D4-48DC-986F-DCC9D0DEC642
Can I interpret the above documentation as the following ? Or my below interpretation is wrong ?
If SQLNET.EXPIRE_TIME=4, then the DB will ping the client every 4 minutes and if it does not detect any activity, then that session will be terminated.