Trace slow network connections

To trace the slow connections:

1. Add the following parameters in the sqlnet.ora file on the CLIENT workstation:

TRACE_LEVEL_CLIENT=16
TRACE_DIRECTORY_CLIENT=
TRACE_FILE_CLIENT=client
TRACE_UNIQUE_CLIENT=ON
TRACE_TIMESTAMP_CLIENT=ON

If you need to restrict the amount of disk space used by the long-term traces then you can also set the following:

TRACE_FILELEN_CLIENT=
TRACE_FILENO_CLIENT=

2. Add the following parameters in the sqlnet.ora file on the SERVER:

TRACE_LEVEL_SERVER=16
TRACE_DIRECTORY_SERVER=
TRACE_FILE_SERVER=server
TRACE_TIMESTAMP_SERVER=ON

If you need to restrict the amount of disk space used by the long-term traces then you can also set the following:

TRACE_FILELEN_SERVER=
TRACE_FILENO_SERVER=

3. Try to reproduce the issue.

No comments:

Post a Comment