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
 
Search WWH ::




Custom Search