sqlnet.ora

This file can be stored on client computers or the server. The file is searched in the following order:

The directory pointed at with the TNS_ADMIN enviornment variable
The ORACLE_BASE_HOME/network/admin directory
The ORACLE_HOME/network/admin

Enable client tracing at support level:

TRACE_LEVEL_CLIENT      = 16
TRACE_FILE_CLIENT       = CLIENT
TRACE_DIRECTORY_CLIENT  = C:\Users\rene\oratrace
TRACE_TIMESTAMP_CLIENT  = ON
TRACE_UNIQUE_CLIENT     = ON
DIAG_ADR_ENABLED        = OFF
TRACE_FILEAGE_CLIENT    = 1440

TRACE_LEVEL_CLIENT can be set to

0 or off
4 or user
10 or admin
16 or support

TRACE_FILE_CLIENT specifies the names of the trace files.

TRACE_TIMESTAMP_CLIENT = ON adds a timestamp in the terrible format dd-mmm-yyyy hh:mm:ss:mil to the *.trc files.

TRACE_FILEAGE_CLIENT specifies the maximum age of trace files in minutes.

TODO

TRACE_LEVEL_CLIENT = ADMIN

SQLNET.EXPIRE_TIME specifies how often, in minutes, to verify that client and server connections are alive (see Dead Connection Detection).

It might be necessary to combine setting sqlnet.expire_time with specifying enable=broken in the TNS connect string.

SQLNET.COMPRESSION, SQLNET.COMPRESSION_ACCELERATION, SQLNET.COMPRESSION_LEVELS