Initialization parameters
The following INIT.ORA parameters have an impact on the trace file produced by the SQL Trace facility:
- MAX_DUMP_FILE_SIZE
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.
- SQL_TRACE
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.
- TIMED_STATISTICS
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.
- USER_DUMP_DEST
Specifies the directory in which the trace files are generated.
Get Oracle Database Administration: The Essential Refe now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
