sqlmonitor

NAME
SYNOPSIS
OPTIONS
EXAMPLE
COPYRIGHT
SEE ALSO

NAME

sqlmonitor − Create sql monitor from gv$sql views

SYNOPSIS

sqlmonitor [options] -l u/p@c sqlid

For the provided sqlid, the sqlmonitor utility creates a sql monitor from the shared pool of the database using dbms_sql_monitor.report_sql_monitor. The output is written to a file named with the sqlid and a suffix of .html unless the --output-file option is provided. Use --output-directory to write the output in a different directory than the current.

The dbms_sql_monitor.report_sql_monitor has several ways to provide information about which of potentially many sql monitors to output and some of these are available as options to sqlmonitor.

OPTIONS

-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 gv$sql and dba_hist_sqltext. 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.

--sql-plan-hash-value=value

Provide a value for the sql_plan_hash_value argument to dbms_sql_monitor.report_sql_monitor.

--sql-exec-id=value

Provide a value for the sql_exec_id argument to dbms_sql_monitor.report_sql_monitor.

--sql-exec-start=value

Provide a value which must be a date in the exact format YYYY.MM.DDTHH24:MI:SS with a literal T to separate the date part from the time part for the sql_exec_start argument to dbms_sql_monitor.report_sql_monitor.

--con-name=value

Provide a value for the con_name argument to dbms_sql_monitor.report_sql_monitor.

sqlid

Exactly one sqlid must be provided.

EXAMPLE

sqlmonitor -l system/{password} 07rw9znc8g7aj

will create a file named 07rw9znc8g7aj.html containing the sql monitor of the sql with sqlid 07rw9znc8g7aj.