16.7.5 Using the Trace Assistant to Examine Trace Files

Oracle Net Services provides a tool called the Trace Assistant to help understand the information provided in trace files by converting existing lines of trace file text into a more readable paragraph. The Trace Assistant works only with level 16 (support) Oracle Net Services trace files.

Note:

The Trace Assistant can only be used when the DIAG_ADR_ENABLED parameter is set to off. See "Understanding Automatic Diagnostic Repository".

• Trace Assistant Syntax
  To run the Trace Assistant, enter the trcasst command at the command line.
• Packet Examples
  Trace Assistant enables you to view data packets from both the Oracle Net and TTC communication layers.
• Two-Task Common (TTC) Packet Examples
  TTC handles requests, such as open cursor, select rows, and update rows that are directed to the database server.
• Connection Example
  These are the sample outputs using the trcasst -la and -li options.
• Statistics Example