Oracle Network Products Troubleshooting Guide
What Is Tracing?
The trace facility allows a network or database administrator to obtain more information on the internal operations of the components of an Oracle application network than is provided in a log file. Tracing an operation produces a detailed sequence of statements that describe the events as they are executed. All trace output is directed to trace output files that can be evaluated to identify the events that led to an error. The user or administrator typically invokes the trace utility during or after the occurrence of an abnormal condition, when the log file does not provide a clear indication of the cause.
Attention: The trace facility uses a large amount of disk space and may have a significant impact upon system performance. Therefore, you are cautioned to turn the trace facility on only as part of a diagnostic procedure and to turn it off promptly when it is no longer necessary.
Components that can be traced using the trace facility are:
- SQL*Net version 2 components
- MultiProtocol Interchange components
- the Connection Manager and pumps
The trace facility can be used to identify the following types of problems:
- difficulties in establishing connections
- abnormal termination of established connections
- fatal errors occurring during the operation of transparent network substrate (TNS) network components
For detailed information about using the trace facility, see Chapter 3, "Tracing".