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