The following INIT.ORA parameters have an impact on the trace file produced by the SQL Trace facility:
Establishes the maximum size of the generated trace file. The values are in operating system blocks. The default value for Oracle7 is 500; the default for Oracle8 is 10000.
When set to TRUE, turns the SQL Trace facility on for all sessions. The effect is to generate a separate trace file for each session. The output will be large, so set SQL_TRACE to TRUE only in extreme conditions. A value of FALSE still allows you to turn on SQL Trace for specific sessions, as shown in the next section.
When set to TRUE, tells Oracle to collect information about how long the parse, execute, and fetch calls take. This output is in addition to the automatically generated execution plan. Enabling this parameter forces Oracle to make several additional internal calls when processing each statement; thus, it will have some minor impact on performance.
Specifies the directory in which the trace files are generated.