How to enable sql*net client side tracing?
PERFORMING A CLIENT-SIDE SQL*NET TRACE (1) Open the SQLNET.ORA file typically found in the following location: ORACLE_BASE\ORACLE_HOME\Network\Admin (7.3.x, 8.1.x or later) ORACLE_BASE\ORACLE_HOME\Net80\Admin (8.0.x) (2) Add the following parameters at the end of the file: #CLIENT-SIDE SQL*NET TRACE PARAMETERS #==================================== TRACE_UNIQUE_CLIENT = ON TRACE_LEVEL_CLIENT = 16 TRACE_DIRECTORY_CLIENT = C:\temp TRACE_FILE_CLIENT = SQLNetTrace TRACE_TIMESTAMP_CLIENT = ON #TRACE_FILELEN_CLIENT = 2048 #TRACE_FILENO_CLIENT = 2 Parameters prefixed with a “#” are interpreted as comments and will not affect tracing. If you want to change the location where the trace file will be saved modify the following two parameters: (a) TRACE_DIRECTORY_CLIENT Set this parameter to the folder where you want the trace file to be saved. WARNING: Do not end the path with a “\”. This is not necessary and may prevent the trace file from being generated. (b) TRACE_FILE_CLIENT Set this parameter
