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.
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