ALTER SYSTEM SET timed_statistics = true;
execute dbms_system.set_sql_trace_in_session(106, 4245, true);
execute dbms_system.set_sql_trace_in_session(106, 4245, false);
sql trace and oradebug
http://www.juliandyke.com/Diagnostics/Trace/NetTrace.html
$ telnet
SQLNET.ORA : Default trace in $ORACLE_HOME/network/trace/CLI.TRC or sqlnet.trc on server
------------------------------------------------------------------
TRACE_UNIQUE_CLIENT = on
TRACE_LEVEL_CLIENT = SUPPORT
TRACE_DIRECTORY_CLIENT = C:\TEMP
TRACE_FILE_CLIENT = CLIENT
TRACE_TIMESTAMP_CLIENT = ON
log_file_client = cli
log_directory_client = c:\trace\log
TRACE_LEVEL_SERVER = SUPPORT
TRACE_DIRECTORY_SERVER = C:\TEMP
TRACE_FILE_SERVER = SERVER
The LISTENER.ORA will now have the following lines
--------------------------------------------------
TRACE_LEVEL_LISTENER = SUPPORT
TRACE_FILE_LISTENER = LISTENER.TRC
TRACE_DIRECTORY_LISTENER = C:\TEMP
Enabling Dynamic Listener Tracing :
----------------------------------
LSNRCTL> set trc_level 16
LSNRCTL> set trc_directory /tmpdata/list_trace
Cyclic Tracing :
-----------------
TRACE_FILELEN_LISTENER=10240
TRACE_FILENO_LISTENER=10
