Here, we will have a look on the tracing on the server/client side.
To enable tracing on the server side, find or create the sqlnet.ora file in the $ORACLE_HOME/network/admin directory.
Add following lines:
TRACE_TIMESTAMP_SERVER=ON
TRACE_LEVEL_SERVER=16
TRACE_UNIQUE_SERVER=ON
TRACE_DIRECTORY=$ORACLE_HOME/network/trace
To enable cleint tracing, add following lines to your sqlnwt.ora on the client side:
TRACE_TIMESTAMP_CLIENT=ON
TRACE_LEVEL_CLIENT=16
TRACE_UNIQUE_CLIENT=ON
TRACE_DIRECTORY=$ORACLE_HOME/network/trace
DIAG_ADR_ENABLED=off
Add following lines:
TRACE_TIMESTAMP_SERVER=ON
TRACE_LEVEL_SERVER=16
TRACE_UNIQUE_SERVER=ON
TRACE_DIRECTORY=$ORACLE_HOME/network/trace
To enable cleint tracing, add following lines to your sqlnwt.ora on the client side:
TRACE_TIMESTAMP_CLIENT=ON
TRACE_LEVEL_CLIENT=16
TRACE_UNIQUE_CLIENT=ON
TRACE_DIRECTORY=$ORACLE_HOME/network/trace
DIAG_ADR_ENABLED=off