Database Reference
In-Depth Information
-c,--cleanup remove temporary XML file (no|yes)
-f,--feedback display progress every x lines (integer number >= 0, no
progress = 0)
-h,--help display this help information and exit
-i,--input input trace file name (valid extensions: trc|gz|zip)
-l,--limit limit the size of lists (e.g. number of statements) in
the output file (integer number >= 0, unlimited = 0)
-o,--output output file name (a temporary XML file with the same
name but with the extension xml is also created)
-r,--release major release of the database engine that generated the
input trace file (7|8|9|10|11|12)
-s,--sys report information about SYS recursive statements
(no|yes)
-t,--template name of the XSL template used to generate the output
file (html|text)
-v,--version print product version and exit
-w,--wait report detailed information about wait events (no|yes)
-x,--logging logging level (severe|warning|info|fine|finer)
The function of each argument is as follows:
•
input
specifies the name of the input file. The input file must be either a trace file (extension
.trc
) or a compressed file (extension
.gz
or
.zip
) that contains one or several trace files.
Note, however, that only a single trace file is extracted from
.zip
files.
•
output
specifies the name of the output file. During processing, a temporary XML file is
created with the same name as the output file but with the extension
.xml
. Be careful, if
another file with the same name as the output file exists, it will be overwritten.
•
cleanup
specifies whether the temporary XML file generated during processing is removed
at the end. Generally, it should be set to
yes
. This argument is important only during the
development phase to check intermediate results.
•
feedback
specifies whether progress information is displayed. It's useful during the processing
of very large trace files to know the current status of the analysis. The argument specifies the
interval (number of lines) at which a new message will be generated. If it's set to 0, no progress
information is displayed.
•
help
specifies whether to display help information. It can't be used along with other
arguments.
•
limit
sets the maximum number of elements present in lists (for example, the lists used for
SQL statements, waits, and bind variables) available in the output file. If it's set to 0, there's
no limit.
•
release
specifies the major version number (that is, 7, 8, 9, 10, 11, or 12) of Oracle Database
that generated the input trace file.
•
sys
specifies whether information about recursive SQL statements that are executed by the
sys
user is available in the output file. It's commonly set to
no
.
•
template
specifies the name of the XSL template used to generate the output file. By default,
two templates are available:
html.xsl
and
text.xsl
. The former generates an HTML output