sqlreport

NAME
SYNOPSIS
OPTIONS
EXAMPLE
COPYRIGHT
SEE ALSO

NAME

sqlreport.rwl − Create a complete sql report

SYNOPSIS

rwloadsim [options] -u -l u/p@c sqlreport.rwl sqlid

For the provided sqlid, the sqlreport.rwl utility creates sql a full report by calling dbms_sql_tune.report_sql_detail, using all default options except report_level which is set to ’ALL’. The output is written to a file named with the sqlid and a suffix of .html unless the --output-file option is provided. The file is created in your current directory unless the --output-directory option is provided.

OPTIONS

-u

Compulsory option to find the sqlreport.rwl script in the public directory.

-l u/p

-l u/p@c

Compulsory option to provide the username, password, and potentially connect string for a database connection that provides access to a login with access to various gv$ and dba_ views. If you omit /p, rwloadsim will prompt for the password.

--output-file=<filename>

By default, the output is written to a file named as the sqlid with a suffix of .html. Use this option to specify a different filename.

--output-directory=<directory>

By default, the output is written in your current directory. Use this option to specify a different directory.

sqlid

Exactly one sqlid must be provided.

EXAMPLE

rwloadsim -ul system/{password} sqlreport.rwl 07rw9znc8g7aj

will create a file named 07rw9znc8g7aj.html containing the output from calling dbms_sqltune.report_sql_detail(sql_id=>’07rw9znc8g7aj’, type=>’active’, report_level=>’ALL’)