reports 5 top enqueues from the 
AWR repository as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default : S,
gr_yrange_enq_stat - y-range in the following
                       format: <number>:<number>

 reports 5 top non-idle wait events from the 
AWR repository as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default : S,
gr_yrange_wait_event - y-range in the following
                       format: <number>:<number>

 reports 5 top data files for the average
duration of one physical read from the 
AWR repository as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default : S,
gr_yrange_file_stat - y-range in the following
                       format: <number>:<number>

 reports 5 top latches from the 
AWR repository as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default : S,
gr_yrange_latch_stat - y-range in the following
                       format: <number>:<number>

 reports 5 top segments for physical reads 
from the AWR repository as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default : S,
gr_yrange_seg_stat - y-range in the following
                       format: <number>:<number>

 reports 5 top shared pool statistics 
from the AWR repository as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default : S,
gr_yrange_sga_stat - y-range for the sga
                   statistics in the following
                   format: <number>:<number>

 reports all system cpu statistics and the 
number of processes  from the AWR 
repository as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default : S,
gr_yrange_sys_stat - y-range in the following
                     format: <number>:<number>,
gr_yrange_sys_curr_stat - y-range for the number
                   of processes in the following
                   format: <number>:<number>

 reports cpu os statistics from the AWR 
repository as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default : S,
gr_yrange_os_stat - y-range in the following
                     format: <number>:<number>,
gr_yrange_os_curr_stat - y-range in the following
                     format: <number>:<number>

 reports io wait events and statistics  
from the AWR repository as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default : S,
gr_yrange_wait_event - y-range in the following
                       format: <number>:<number>,
gr_yrange_sys_stat - y-range in the following
                       format: <number>:<number>

 reports dblink wait events and statistics  
from the AWR repository as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default : S,
gr_yrange_wait_event - y-range in the following
                       format: <number>:<number>,
gr_yrange_sys_stat - y-range in the following
                       format: <number>:<number>

 reports logons statistics from the AWR 
repository as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default : S,
gr_yrange_sys_stat - y-range for the cumulative
                     logons in the following
                     format: <number>:<number>,
gr_yrange_sys_curr_stat - y-range for the current
                   logons in the following
                   format: <number>:<number>

 reports paging os statistics from the AWR 
repository as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default : S,
gr_yrange_os_stat - y-range in the following
                     format: <number>:<number>

 reports downgrade statistics for parallel 
operations from the AWR repository as a 
graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default : S,
gr_yrange_sys_stat - y-range in the following
                     format: <number>:<number>

 reports system statistics for parallel 
operations from the AWR repository as a 
graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default : S,
gr_yrange_sys_stat - y-range in the following
                     format: <number>:<number>

 reports total waits for non-idle 
events and cpu statistics from the AWR
repository as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default : S,
gr_yrange_sum_waits - 
            y-range in the following format: 
            <number>:<number>,
gr_yrange_sys_stat - 
            y-range in the following format:
            <number>:<number>

 reports enqueue statistics from the 
AWR repository as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default: S,
gr_title - graphics title,
enq_stat_name - statistics to select
	    (TOTAL_REQ#, TOTAL_WAIT#,
             SUCC_REQ#, FAILED_REQ#,
             CUM_WAIT_TIME),
            default : CUM_WAIT_TIME,
gr_abs_or_rel_enq_stat - 
   (abs - absolute values will be 
          presented on the graphics,
    rel - values per sec. will be
          presented on the graphics,
    default : rel),
gr_y_or_y2_enq_stat -
    (y - y-axis will be used,
     y2 - y2-axis will be used,
     default : y),
gr_yrange_enq_stat - y-range in the following
                       format: <number>:<number>,
gr_top_enq_stat - number of top enqueues,
                   default : 0,
gr_stat_name_N - name of an enqueue in the
                 following format:
                 <type> - <req. reason>, for ex.
                  TX - contention,
                 default : no name 

 reports data file statistics from the 
AWR repository as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default: S,
gr_title - graphics title,
file_stat_name - statistics to select
            (READTIM,WRITETIM,PHYRDS, 
             PHYWRTS, PHYBLKRD, 
             PHYBLKWRT, READTIM/PHYRDS),
            default : READTIM/PHYRDS,
gr_abs_or_rel_file_stat - 
   (abs - absolute values will be 
          presented on the graphics,
    rel - values per sec. will be
          presented on the graphics,
    default : rel),
gr_y_or_y2_file_stat -
    (y - y-axis will be used,
     y2 - y2-axis will be used,
     default : y),
gr_yrange_file_stat - y-range in the following
                       format: <number>:<number>,
gr_top_file_stat - number of top data files,
                   default : 0,
gr_stat_name_N - name of a data file,
                 default : no name 

 reports latch statistics from the 
AWR repository as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default: S,
gr_title - graphics title,
latch_stat_name - statistics to select
            (GETS,MISSES,SLEEPS, 
             IMMEDIATE_GETS, 
             IMMEDIATE_MISSES, 
             SPIN_GETS,WAIT_TIME),
            default : SLEEPS,
gr_abs_or_rel_latch_stat - 
   (abs - absolute values will be 
          presented on the graphics,
    rel - values per sec. will be
          presented on the graphics,
    default : rel),
gr_y_or_y2_latch_stat -
    (y - y-axis will be used,
     y2 - y2-axis will be used,
     default : y),
gr_yrange_latch_stat - y-range in the following
                       format: <number>:<number>,
gr_top_latch_stat - number of top latches,
                   default : 0,
gr_stat_name_N - name of a latch,
                 default : no name 

 reports current (not cumulative) os 
statistics from the AWR repository 
as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default : S
gr_title - graphics title,
gr_y_or_y2_os_curr_stat -
    (y - y-axis will be used,
     y2 - y2-axis will be used,
     default : y),
gr_yrange_os_curr_stat - y-range in 
      he following format: <number>:<number>,
gr_stat_name_N - name of a system statistics,
                 default : no name   

 reports os statistics from the AWR
repository as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default : S
gr_title - graphics title,
gr_abs_or_rel_os_stat - 
   (abs - absolute values will be 
          presented on the graphics,
    rel - values per sec. will be
          presented on the graphics,
    default : rel),
gr_y_or_y2_os_stat -
    (y - y-axis will be used,
     y2 - y2-axis will be used,
     default : y),
gr_yrange_os_stat - y-range in the following
                       format: <number>:<number>,
gr_stat_name_N - name of a system statistics,
                 default : no name   

 reports segment statistics from the 
AWR repository as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default: S,
gr_title - graphics title,
seg_stat_name - statistics to select
  (LOGICAL_READS, BUFFER_BUSY_WAITS,
   DB_BLOCK_CHANGES, PHYSICAL_READS,
   PHYSICAL_WRITES, ITL_WAITS,
   PHYSICAL_READS_DIRECT,
   PHYSICAL_WRITES_DIRECT,
   GC_CR_BLOCKS_RECEIVED,
   GC_CURRENT_BLOCKS_RECEIVED,
   GC_BUFFER_BUSY, ROW_LOCK_WAITS,
   GLOBAL_CACHE_CR_BLOCKS_SERVED,
   GLOBAL_CACHE_CU_BLOCKS_SERVED)
  default : PHYSICAL_READS,
object_type - object type 
  (TABLE, INDEX,
   TABLE PARTITION, INDEX PARTITION,
   LOB, etc.),
  default: all,
gr_abs_or_rel_seg_stat - 
   (abs - absolute values will be 
          presented on the graphics,
    rel - values per sec. will be
          presented on the graphics,
    default : rel),
gr_y_or_y2_seg_stat -
    (y - y-axis will be used,
     y2 - y2-axis will be used,
     default : y),
gr_yrange_seg_stat - y-range in the following
                   format: <number>:<number>,
gr_top_seg_stat - number of top segments,
                   default : 0,
gr_stat_name_N - name of a segment as
          <owner>.<obj_name>[.<subobj_name>],
                 default : no name 

 reports current sga statistics from 
the AWR repository as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default : S
gr_title - graphics title,
gr_y_or_y2_sga_stat -
    (y - y-axis will be used,
     y2 - y2-axis will be used,
     default : y),
gr_yrange_sga_stat - y-range in 
      the following format: <number>:<number>,
pool_name - pool name, default: no name,
gr_stat_name_N - name of a sga statistics in
                 the following form:
                 <pool>:<stat_name>, for ex.
                 shared pool:free memory,
                 default : no name   

 reports total waits for non-idle events
from the AWR repository as a graphics
input parameters: 
begin_time - start time, 
              (format - dd.mm.yyyy hh24:mi:ss),
             default : sysdate - 1,
end_time   - end time, 
              (format - dd.mm.yyyy hh24:mi:ss),
             default : sysdate,
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default : S,
gr_title - graphics title,
gr_abs_or_rel_sum_waits - 
   (abs - absolute wait times will be 
          presented on the graphics,
    rel - wait times per sec. will be
          presented on the graphics,
    default : rel),
gr_y_or_y2_sum_waits -
    (y - y-axis will be used for wait times,
     y2 - y2-axis will be used for wait times,
     default : y),
gr_yrange_sum_waits - 
            y-range in the following format:
            <number>:<number>

 reports current (not cumulative) system 
statistics from the AWR repository 
as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default : S
gr_title - graphics title,
gr_y_or_y2_sys_curr_stat -
    (y - y-axis will be used,
     y2 - y2-axis will be used,
     default : y),
gr_yrange_sys_curr_stat - y-range in 
      he following format: <number>:<number>,
gr_stat_name_N - name of a system statistics,
                 default : no name   

 reports system statistics from the AWR
repository as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default : S
gr_title - graphics title,
gr_abs_or_rel_sys_stat - 
   (abs - absolute values will be 
          presented on the graphics,
    rel - values per sec. will be
          presented on the graphics,
    default : rel),
gr_y_or_y2_sys_stat -
    (y - y-axis will be used,
     y2 - y2-axis will be used,
     default : y),
gr_yrange_sys_stat - y-range in the following
                       format: <number>:<number>,
gr_stat_name_N - name of a system statistics,
                 default : no name   

 reports wait statistics from the AWR
repository as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default : S
only_non_idle_events - 
   (Y - only non idle events in the output,
    N - all events,
    default : Y)
gr_title - graphics title,
gr_abs_or_rel_wait_event - 
   (abs - absolute wait times will be 
          presented on the graphics,
    rel - wait times per sec. will be
          presented on the graphics,
    default : rel),
gr_y_or_y2_wait_event -
    (y - y-axis will be used for wait times,
     y2 - y2-axis will be used for wait times,
     default : y),
gr_yrange_wait_event - y-range in the following
                       format: <number>:<number>,
gr_top_wait_event - number of top wait events,
                    default : 0,
gr_stat_name_N - name of a wait event,
                 default : no name   

 produces standard active session
history report,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss) 

 reports blocking sessions 
for an event from AWR,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),

event_name_like - default: all events 

 Shows the control parameters for AWR

 top SQL statements for one object from 
the AWR repository are reported,
input parameters: 
begin_time - start time (default : sysdate - 1),
end_time   - end time (default : sysdate),
(format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default: don't group data,
num_stmt - number of top statements, default 5,
with_sqltext - with SQL text in the output:
          ( Y - yes, N - no, default: Y),
trunc_sqltext_to - truncate SQL texts to N characters,
	           default - do not truncate,
with_exec_plan - with execution plans in the output:
	         (Y - yes, N - no, default: Y),
object_owner - object owner (default: all owners),
object_name - object name (default: all names),
object_type - object type (default: all types), 
criteria - the criteria for top SQL statements:
 STATS [ E ], where STATS in
 (DR - disk reads, BG - buffer gets,
  CT - CPU time, ET - elapsed time,
  PL - PL/SQL execution time, 
  JA - JAVA execution time,
  WT - wait time, EX - executions,
  RP - rows processed, PC - parse calls,
  DW - direct writes, AP - application wait time,
  CO - concurrency wait time, CL - cluster wait time,
  IO - user io wait time),
  E - per execution. Combination EXE isn't allowed.
  Default : DR

 reports initialization parameters from the
AWR repository,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
param_like - parameter name
              (default : all parameters),
not_default - not default ? (TRUE, FALSE)
              (default : TRUE)
not_autom_sized - not automatically sized
                  parameters ? (TRUE, FALSE),
                  (default : TRUE)

 produces standard AWR report,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss) 

 shows names of os statistics,
input parameter : 
stat_name_like - statistics name,
                 (default : all) 

 overviews the snapshots from the AWR
repository,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss)

 top SQL statements from the AWR
repository are reported,
input parameters: 
begin_time - start time (default : sysdate - 1),
end_time   - end time (default : sysdate),
(format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default: don't group data,
num_stmt - number of top statements, default 5,
with_sqltext - with SQL text in the output:
          ( Y - yes, N - no, default: Y),
trunc_sqltext_to - truncate SQL texts to N characters,
	           default - do not truncate,
with_exec_plan - with execution plans in the output:
	         (Y - yes, N - no, default: Y),
sql_id - sql id of the statement,
             default - all statemens,
signature - force matching signature of the
            statement, default - all statements,
criteria - the criteria for top SQL statements:
 STATS [ E ], where STATS in
 (DR - disk reads, BG - buffer gets,
  CT - CPU time, ET - elapsed time,
  PL - PL/SQL execution time, 
  JA - JAVA execution time,
  WT - wait time, EX - executions,
  RP - rows processed, PC - parse calls,
  DW - direct writes, AP - application wait time,
  CO - concurrency wait time, CL - cluster wait time,
  IO - user io wait time),
  E - per execution. Combination EXE isn't allowed.
  Default : DR

 reports instance startup times from the 
AWR repository,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss) 

 shows session details from AWR,
input parameters: 
   begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
   end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
   sid,
   serial (default: all serials)
 

 shows an execution plan for one SQL statement 
from AWR,
input parameter: SQL Id,
                 plan_hash_value
                 (default: all)

 accepts a tuning task recommended
by Advisor (sql profile),
input parameters:
profile_name, 
   default: TUTOOL_SQL_PROFILE,
task_owner,
   default: current user,
task_name,
   default: TUTOOL_TUNING_TASK,
sqltune_category, 
   default: 'DEFAULT',
force_match - if TRUE this causes 
   SQL profiles to target all SQL 
   statements which have the same
   text after normalizing all literal
   values into bind variables,
   default: FALSE

 alters a sql profile 
input parameters:
   profile_name,
      default: TUTOOL_SQL_PROFILE, 
   attr_name (STATUS, 
              NAME, CATEGORY),
   attr_value - STATUS can be set 
        to "ENABLED" or "DISABLED"

 creates a file with formatted sqltext from sql profile
input parameter: sql_profile_name

 creates tuning task for a sql
defined via sqltext,
input parameters:
   user_name - the username for who 
        the statement will be tuned,
        default: current user,
   task_name, 
        default: TUTOOL_TUNING_TASK,
   time_limit (in sec.),
        default: 900

 creates tuning task for a sql
defined via sqlid,
input parameters:
   task_name, 
        default: TUTOOL_TUNING_TASK,
   sql_id,
   time_limit (in sec.),
        default: 900

 creates tuning task for a sql
from the AWR defined via sqlid,
input parameters:
begin_time - start time,
     default : sysdate - 1,
     (format - dd.mm.yyyy hh24:mi:ss),
end_time - end time,
     default : sysdate,
     (format - dd.mm.yyyy hh24:mi:ss),
task_name, 
     default: TUTOOL_TUNING_TASK,
sql_id,
time_limit (in sec.),
     default: 900

 shows sql profile(s),
input parameters:sql_profile_name, default: all,
                 category, default: all,
                 description_like, default: all,
                 signature, default: all

 shows sqltune task(s),
input parameters: owner, default: all,
                  task_name, default: all,
                  and/or task_id, default: all,
                  description_like, default: all

 drops a sql profile 
input parameter: profile_name,
      default: TUTOOL_SQL_PROFILE

 dropes all sql profiles of one category,
input parameters: 
  sqltune_category - sqltune category

 drops a tuning task 
input parameters:
   task_name, 
        default: TUTOOL_TUNING_TASK

 executes a tuning task 
input parameters:
   task_name, 
        default: TUTOOL_TUNING_TASK

 reports a tuning task 
input parameters:
   task_owner,
        default: current user,
   task_name, 
        default: TUTOOL_TUNING_TASK,
   level - ALL, ADVANCED,
        default: ALL

 generates a command to enable
sqltune category in a session,
input parameter: sqltune category,
          default: DEFAULT

 creates sql profile to fix with optimizer
hints an execution plan from AWR,
input parameters:
      sql_id,
      plan_hash_value,
      sql_profile - name of sql profile
                    (default: TUTOOL_SQL_PROFILE),
      sqltune_category . default: DEFAULT,
      force_match - true, false 
                    (default: false)

 creates sql profile to fix with optimizer
hints an execution plan from explain plan,
input parameters:
      sql_profile - name of sql profile
                    (default: TUTOOL_SQL_PROFILE),
      sqltune_category . default: DEFAULT,
      force_match - true, false 
                    (default: false)

 creates sql profile to fix with optimizer
hints an execution plan from sqlarea,
input parameters:
      sql_id,
      plan_hash_value,
      sql_profile - name of sql profile
                    (default: TUTOOL_SQL_PROFILE),
      sqltune_category . default: DEFAULT,
      force_match - true, false 
                    (default: false)

 creates sql profile to fix with optimizer
hints an execution plan from sql profile,
input parameters:
      sql_profile - name of sql profile
                (default: TUTOOL_SQL_PROFILE),
      sqltune_category . default: DEFAULT,
      task_owner - task owner
                (default: current user),
      task_name - name of task     
                (default: TUTOOL_TUNING_TASK),
      force_match - true, false 
                (default: false)

 shows signature for a sql
from sqlarea (for selects 
from dba_sql_profiles, etc),
input parameters: sql_id

 generates signature for a sql
defined via sqltext (for selects 
from dba_sql_profiles, etc),
input parameter: force_match (TRUE, FALSE),
              default: FALSE

 shows a signature for a sql
defined via sqltext (for selects 
from dba_sql_profiles, etc),

You do not need TP licence to run this script!

 reports the buffer hitratio for each buffer pool

 reports the block classes and data files affected
by buffer busy waits.
Pior to release 8.1.6 run first the script 
$ORACLE_HOME/rdbms/admin/catperf.sql to
create the view V$BUFFER_POOL_STATISTICS

 monitors buffer busy wait statistics,
input parameter:
sleep_interval_sec - sleep interval in sec.
                     (default: 30),
requirement : TIMED_STATISTICS=TRUE 

 monitors buffer waits for datafiles,
input parameters:
sleep_interval_sec - sleep interval in sec.
                      (default: 30),
num_top_data_files - number of top datafiles
                      (default: all), 
requirement : TIMED_STATISTICS=TRUE 

 reports object blocks in the buffer cache,
input parameters:
        object_owner (default: all) 
        object_name (default: all)

 reports the objects for top
hot blocks in the buffer cache,
input parameter: 
     num_top_blocks - number of top
                      hot blocks
                     (default : 20)

 reports the segments for top
hot blocks in the buffer cache,
input parameter: 
     num_top_blocks - number of top
                      hot blocks
                     (default : 5 )

 shows the summary buffer cache hitratio 

 monitoring of blocking sessions
for an event,
input parameters: event_name_like,
      (default: all events),
                  sleep interval (sec.),
      (default: 60)

 monitors buffer busy wait statistics,
input parameter:
sleep_interval_sec - sleep interval in sec.
                     (default: 30),
requirement : TIMED_STATISTICS=TRUE 

 monitors wait events,
input parameters:
sleep_interval_sec - sleep interval in sec.
                     (default: 30),
num_top_events - number of top events
                     (default: all), 
requirement : TIMED_STATISTICS=TRUE 

 monitors buffer waits for datafiles,
input parameters:
sleep_interval_sec - sleep interval in sec.
                      (default: 30),
num_top_data_files - number of top datafiles
                      (default: all), 
requirement : TIMED_STATISTICS=TRUE 

 monitors physical reads for datafiles,
input parameters:
sleep_interval_sec - sleep interval in sec.
                      (default: 30),
num_top_data_files - number of top datafiles
                      (default: all) 

 monitors physical reads time for datafiles,
input parameters:
sleep_interval_sec - sleep interval in sec.
                      (default: 30),
num_top_data_files - number of top datafiles
                      (default: all), 
requirement : TIMED_STATISTICS=TRUE 

 monitors physical writes for datafiles,
input parameters:
sleep_interval_sec - sleep interval in sec.
                      (default: 30),
num_top_data_files - number of top datafiles
                      (default: all) 

 monitors physical writes time for datafiles,
input parameters:
sleep_interval_sec - sleep interval in sec.
                      (default: 30),
num_top_data_files - number of top datafiles
                      (default: all), 
requirement : TIMED_STATISTICS=TRUE 

 monitors latch waits holding a latch,
input parameters:
sleep_interval_sec - sleep interval in sec.
                      (default: 30),
num_top_latches - number of top latches
                      (default: all) 

 monitors immediate latch misses,
input parameters:
sleep_interval_sec - sleep interval in sec.
                      (default: 30),
num_top_latches - number of top latches
                      (default: all) 

 monitors latch sleeps,
input parameters:
sleep_interval_sec - sleep interval in sec.
                      (default: 30),
num_top_latches - number of top latches
                      (default: all) 

 monitors latch waits time,
input parameters:
sleep_interval_sec - sleep interval in sec.
                      (default: 30),
num_top_latches - number of top latches
                      (default: all), 
requirement : TIMED_STATISTICS=TRUE

 monitors non-idle wait events,
input parameter : sleep interval (sec.),
                  (default : 60),
requirement : TIMED_STATISTICS=TRUE

 monitors os statistics,
input parameter:
stat_name_like - statistics name 
                 (default: AVG%TIME),
sleep_interval_sec - sleep interval (sec.)
                 (default: 30)

 monitors wait events for one session,
input parameters:
sid - SID of the session,
like_event_name - event name
                (default: all events),
sleep_interval_sec - sleep interval in sec.
                (default: 30),
num_top_events - number of top events. 
                (default: all),
requirement : TIMED_STATISTICS=TRUE 

 monitors system statistics for one session,
input parameters:
sid - SID of the session,
like_stat_name - statistics name 
                (default: all),
sleep_interval_sec - sleep interval in sec.
                (default: 30)

 monitors one wait event for all sessions,
input parameters:
event_name - event name
                (default: "latch free"),
sleep_interval_sec - sleep interval in sec.
                (default: 30),
num_top_sessions - number of top sessions. 
                (default: 10),
requirement : TIMED_STATISTICS=TRUE 

 monitors one statistics for all sessions,
input parameters:
statistics_name - statistics name
            (default: "CPU used by this session"),
sleep_interval_sec - sleep interval in sec.
            (default: 30),
num_top_sessions - number of top sessions. 
            (default: 10), 
requirement : TIMED_STATISTICS=TRUE 

 monitors SGA statistics,
input parameter : sleep interval (sec.)
                  (default : 60)

 shows names of system statistics,
input parameter : 
stat_name_like - statistics name,
                 (default : all) 

 monitors system statistics,
input parameter:
stat_name_like - statistics name 
                 (default: physical%),
sleep_interval_sec - sleep interval (sec.)
                 (default: 30),
requirement : TIMED_STATISTICS=TRUE

 monitors free space in tablespaces,
input parameters : 
thresh_pct_free - threshold of percent free 
                   (default : all tablespaces),
sleep_interval_sec - sleep interval in sec.
                   (default : 30)

 finds a complete table name in the data dictionary,
input parameter : 
table_name_like - table name

 generates a create script for a function,
input parameters: owner (default: current user),
                  function name

 generates a create script for a package header,
input parameters: owner (default: current user),
                  package name

 generates a create script for a package body,
input parameters: owner (default: current user),
                  package name

 generates a create script for a stored procedure,
input parameters: owner (default: current user),
                  procedure name

 generates a create script for a view,
input parameters: owner (default: current user),
                  view name

 generates create script for an object,
input parameters: owner (default: null),
                  object name,
                  object typ (default: TABLE)

 reports invalid objects

 shows errors for a stored object,
input parameters: owner (default: current user),
                  object name,
                  object type (default: all)

 gives object information,
input parameter : object name and/or
                  object id and/or
                  data object id

 shows database configuration 

 overviews instance performance 

 shows complete (also hidden) system 
optimizer environment,
input parameter: 
    IsDefault - Default?  (Y, N),
    (default : all parameters)

 reports initialization parameters from the
AWR repository,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
param_like - parameter name
              (default : all parameters),
not_default - not default ? (TRUE, FALSE)
              (default : TRUE)
not_autom_sized - not automatically sized
                  parameters ? (TRUE, FALSE),
                  (default : TRUE)

 shows initialization parameters,
input parameters : 
parameter_like - parameter name
            (default : all parameters),
IsDefault - Default?  (TRUE, FALSE),
            (default : all parameters)

 shows differencies in 2 session 
optimizer environments,
input parameter: 
    sid1,
    sid2 

 shows differencies in 2 sql 
optimizer environments,
input parameter: 
    sql_id,
    child_nr1
    child_nr2 

 shows resource limits
from the view sys.v_$resource_limit 

 shows modified parameters in a session 
by turning on tracing, 
input parameter: SID

ATTENTION: a directory and an external table 
will be created and finally droped 

 shows session optimizer environment,
input parameter: 
    sid,
    IsDefault - Default?  (Y, N),
    (default : all parameters)

 reports initialization parameters from the
STATSPACK repository,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
param_like - parameter name
              (default : all parameters),
not_default - not default ? (TRUE, FALSE)
              (default : TRUE)
not_autom_sized - not automatically sized
                  parameters ? (TRUE, FALSE),
                  (default : TRUE)

 shows the impact of the parameter statistics_level

 shows system optimizer environment,
input parameter: 
    IsDefault - Default?  (Y, N),
    (default : all parameters)

 shows a current SQL of the sessions
waiting for an enqueue,
input parameter: enqueue type,
                 (for ex. TX) 

 reports blocking sessions 
for enqueues

 shows sessions waiting for an enqueue and
their blockers,
requirement: run first the script
catblock.sql to create the necessary
views in the schema SYS

 finds all locks causing the waits,
requirement: run first the script
catblock.sql to create the necessary
views in the schema SYS.

 provides enqueue statistics 

 provides fully DECODED information regarding 
the locks currently held in the database,
input parameter: instance Id 
                 (default: all instances),
                 SID (default: all sessions)

 checks for foreign key constraints 
which are not supported by any index 

 finds objects which are blocked by enqueues,
requirement: run first the script
catblock.sql to create the necessary 
views in the schema SYS

 reports sessions waiting for enqueues,
input parameter : sid
       (default : all sessions)

 checks the contents of the temporary 
tablespaces in use 

 reports top lock holders,
input parameter: number of top sessions
                 (default: 10),
requirement: run first the script catblock.sql
to create the necessary views in the schema SYS

 generates a create script for the X_$ views,
input parameters: 
table_name_like - fixed table name 
           (default: for all fixed tables),
grant - user to grant select privileges on
        the X_$ views
           (default: public)

 finds a complete fixed table name, 
input parameter : 
table_name_like - table name

 gives indexes for fixed tables,
input parameter: 
table_name_like - fixed table name
                  (default : all)

 shows a view text of V$ views,
input parameter: 
view_name_like - view name
       (default: all views)

 estimates and reports normal indexes that should be rebuilt,
input parameters : 
        index owner, default: all,
        index name, default: all,
        only_without_stats, (Y;N), default: Y,
        sample_percent, 0 - 100, default 10,
        density in %, default: 75.
Attention: a temporary table will be created and 
           finally droped,
           this script can be very expensive!

 monitors physical reads for datafiles,
input parameters:
sleep_interval_sec - sleep interval in sec.
                      (default: 30),
num_top_data_files - number of top datafiles
                      (default: all) 

 monitors physical reads time for datafiles,
input parameters:
sleep_interval_sec - sleep interval in sec.
                      (default: 30),
num_top_data_files - number of top datafiles
                      (default: all), 
requirement : TIMED_STATISTICS=TRUE 

 monitors physical writes for datafiles,
input parameters:
sleep_interval_sec - sleep interval in sec.
                      (default: 30),
num_top_data_files - number of top datafiles
                      (default: all) 

 monitors physical writes time for datafiles,
input parameters:
sleep_interval_sec - sleep interval in sec.
                      (default: 30),
num_top_data_files - number of top datafiles
                      (default: all), 
requirement : TIMED_STATISTICS=TRUE 

 reports bitmap indexes that should be rebuilt,
input parameter : density in %
        default : 10,
requirement : accurate optimizer statistics

 reports normal indexes that should be rebuilt,
input parameter : density in %
        default : 75,
requirement : accurate optimizer statistics

 shows a curent SQL of the sessions
waiting for a latch,
input parameter: latch name

 shows the number of waiting sessions per latch

 reports addresses of the "cache buffers chains" 
latches having the highest number of sleeps,
input parameter : threshold of sleep number
                    (default: 1000)

 reports objects from the x$bh for 
an address of "cache buffers chains" latch,
input parameter : latch address 
               (the output of the 
            cache_buff_chain_latch_addr)

 reports segments from the x$bh for 
an address of "cache buffers chains" latch,
input parameter : latch address 
               (the output of the 
            cache_buff_chain_latch_addr)

 reports latch blockers 

 shows latch get statistics

 monitors latch waits holding a latch,
input parameters:
sleep_interval_sec - sleep interval in sec.
                      (default: 30),
num_top_latches - number of top latches
                      (default: all) 

 monitors immediate latch misses,
input parameters:
sleep_interval_sec - sleep interval in sec.
                      (default: 30),
num_top_latches - number of top latches
                      (default: all) 

 shows latch levels 

 reports latch sleeps 

 monitors latch sleeps,
input parameters:
sleep_interval_sec - sleep interval in sec.
                      (default: 30),
num_top_latches - number of top latches
                      (default: all) 

 reports latch waits time, 
requirement : TIMED_STATISTICS=TRUE

 monitors latch waits time,
input parameters:
sleep_interval_sec - sleep interval in sec.
                      (default: 30),
num_top_latches - number of top latches
                      (default: all), 
requirement : TIMED_STATISTICS=TRUE

 shows the distribution of latch sleeps
by code locations

 reports sessions waiting for latches,
input parameter: sid
       (default: all sessions)

 reports dba features in use 

 finds out a segment via DBA,
input parameter : dba (data block address)

 shows segments, which couldn't be extended

 finds a current SQL of the QC (query coordinator)
through a current SQL of a running PQ (parallel query) 
slave.
input parameter: SQL address of a PQ slave
                 and / or
                 SQL hash value of a PQ slave

 shows current SQL addresses of running PQ 
(parallel queries)

 converts SCN to timestamp,
input parameter : scn as decimal or as
		  <scn wrap>.<scn base>,
		  where scn wrap and base
		  are hexadecimal

 shows segment types in tablespaces,
input parameter : tablespace name
       (default : all tablespaces)

 shows the number of extents for segments,
input parameter : tablespace name
       (default : all tablespaces)

 reports the number of segment
free blocks in a free list,
input parameters :
     segment owner (default: current user),
     segment name,
     segment type (default: TABLE),
     partition name (default: none),
     free list group Id (default 0)

 reports a HWM (highwater mark) for a segment,
input parameters :
     segment owner (default: current user),
     segment name,
     segment type (default: TABLE),
     partition name (default: none)

 shows segments having extents in the datafile,
input parameters: 
             file_id - file Id and/or 
             file_name_like - file name

 reports a space usage for segments in ASSM 
("automatic segment space management") tablespaces,
input parameters :
    segment owner (default: current user),
    segment name,
    segment type (default : TABLE)

 reports top segments in dictionary managed 
tablespaces having many extents,
input parameter : threshold of the 
                  number of the extents
                  (default : 1000)

 shows free space in tablespaces 

 reports granted object privileges for a given user
or for a given role,
input parameter : name - user name or role

 reports granted roles for a given user
or for a given role,
input parameter : name - user name or role

 reports granted system privileges for a given user
or for a given role,
input parameter : name - user name or role

 writes a string into alert.log,
input parameter: text

 shows RMAN backup history 
for the last 15 days,
input parameter: backup type
(F - full backup,
 A - archived redologs,
 I - incremental backup,
 default: full backup)

 shows redo log statistics

 to see how much of the current log 
file has been used,
attention: checkpoint will be done !

 shows redo log switch history
for the last 30 days

 reports the errors in the alert.log, 
input parameters:
begin_date - begin date, default: sysdate - 1,
             (format: dd.mm.yyyy),
end_date   - end date, default: sysdate,
             (format: dd.mm.yyyy),
ATTENTION: a directory and an external table 
will be created and finally droped

 reports the last N lines of the alert.log, 
input parameters:
n_last_lines - n last lines of the alert.log
               or
               FULL - the entire alert.log,
               default: 1000,
ATTENTION: a directory and an external table 
will be created and finally droped

 reports the time section of the alert.log, 
input parameters:
begin_date - begin date, default: sysdate - 1,
             (format: dd.mm.yyyy),
end_date   - end date, default: sysdate,
             (format: dd.mm.yyyy),
ATTENTION: a directory and an external table 
will be created and finally droped

 reports the first N lines of an arbitrary trace
file from an arbitrary destination,
input parameters:
destination - directory with a trace file,
trace_name - the name of trace file,
n_first_lines - n first lines of the trace
                or
                FULL - the entire trace,
                default: 1000,
ATTENTION: a directory and an external table 
will be created and finally droped

 reports the first N lines of the background
trace file from the background dump destination,
input parameters:
trace_name - the name of background trace file,
n_first_lines - n first lines of the trace
                or
                FULL - the entire trace,
                default: 1000,
ATTENTION: a directory and an external table 
will be created and finally droped

 drops all tools external tables
and directories

 shows modified parameters in a session 
by turning on tracing, 
input parameter: SID

ATTENTION: a directory and an external table 
will be created and finally droped 

 turns on sql tracing for some minutes in 
a session, transfers the trace file to the 
client site, starts tkprof utility, 
input parameters: 
SID,
trace level: 
  1 - without bind variables and wait stats,
  4 - with bind variables and without wait stats,
  8 - without bind variables and with wait stats, 
 12 - with bind variables and with wait stats,
 default: 1,
duration_min - duration of tracing in min.,
  default: 5
tkprof_explain - 
  y - with connection to the database,
  n - without connection to the database,
  default: n,
tkprof_sort - sort criteria for tkprof,
  default: prsela exeela fchela (elapsed time).
ATTENTION: a directory and an external table 
will be created and finally droped           
 

 generates a script to turn on/off the sql
tracing for a session,
input parameters: SID,
                  trace level: 
1 - without bind variables and wait stats,
4 - with bind variables and without wait stats,
8 - without bind variables and with wait stats, 
12 - with bind variables and with wait stats,
default: 1

 transfers trace file to the client site,
starts tkprof utility,
input parameters: 
trace_name - name of the trace file,
tkprof_explain - 
  y - with connection to the database,
  n - without connection to the database,
  default: n,
tkprof_sort - sort criteria for tkprof,
  default: prsela exeela fchela (elapsed time).
ATTENTION: a directory and an external table 
will be created and finally droped 
 

 reports the first N lines of the user trace
file from the user dump destination,
input parameters:
trace_name - the name of user trace file,
n_first_lines - n first lines of the trace
                or
                FULL - the entire trace,
                default: 1000,
ATTENTION: a directory and an external table 
will be created and finally droped

 to check the number of rollback segments

 reports rollback segments contention 

 reports rollback segments status 

 finds a rollback segment for a session,
input parameter: sid, 
                (default: all sessions)

 reports undo statistics,
input parameters : 
      start_time in the format
          'dd.mm.yyyy hh24:mi:ss',
          (default : sysdate - 1),
      end_time in the format
          'dd.mm.yyyy hh24:mi:ss',
          (default : sysdate),
      group - grouping:
          D - day, H - hour, M - minute
          (default : M)

 top SQL statements for one object from 
the AWR repository are reported,
input parameters: 
begin_time - start time (default : sysdate - 1),
end_time   - end time (default : sysdate),
(format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default: don't group data,
num_stmt - number of top statements, default 5,
with_sqltext - with SQL text in the output:
          ( Y - yes, N - no, default: Y),
trunc_sqltext_to - truncate SQL texts to N characters,
	           default - do not truncate,
with_exec_plan - with execution plans in the output:
	         (Y - yes, N - no, default: Y),
object_owner - object owner (default: all owners),
object_name - object name (default: all names),
object_type - object type (default: all types), 
criteria - the criteria for top SQL statements:
 STATS [ E ], where STATS in
 (DR - disk reads, BG - buffer gets,
  CT - CPU time, ET - elapsed time,
  PL - PL/SQL execution time, 
  JA - JAVA execution time,
  WT - wait time, EX - executions,
  RP - rows processed, PC - parse calls,
  DW - direct writes, AP - application wait time,
  CO - concurrency wait time, CL - cluster wait time,
  IO - user io wait time),
  E - per execution. Combination EXE isn't allowed.
  Default : DR

 top SQL statements from the AWR
repository are reported,
input parameters: 
begin_time - start time (default : sysdate - 1),
end_time   - end time (default : sysdate),
(format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default: don't group data,
num_stmt - number of top statements, default 5,
with_sqltext - with SQL text in the output:
          ( Y - yes, N - no, default: Y),
trunc_sqltext_to - truncate SQL texts to N characters,
	           default - do not truncate,
with_exec_plan - with execution plans in the output:
	         (Y - yes, N - no, default: Y),
sql_id - sql id of the statement,
             default - all statemens,
signature - force matching signature of the
            statement, default - all statements,
criteria - the criteria for top SQL statements:
 STATS [ E ], where STATS in
 (DR - disk reads, BG - buffer gets,
  CT - CPU time, ET - elapsed time,
  PL - PL/SQL execution time, 
  JA - JAVA execution time,
  WT - wait time, EX - executions,
  RP - rows processed, PC - parse calls,
  DW - direct writes, AP - application wait time,
  CO - concurrency wait time, CL - cluster wait time,
  IO - user io wait time),
  E - per execution. Combination EXE isn't allowed.
  Default : DR

 creates a file with formatted sqltext from AWR,
input parameter: sql_id

 creates a file with formatted sqltext from outline
input parameter: outln_name

 creates a file with formatted sqltext from sqlarea
input parameter: sql_id

 creates a file with formatted sqltext from 
statspack repository,
input parameters: old_hash_value

 creates a file with formatted sqltext from sql profile
input parameter: sql_profile_name

 shows differencies in 2 sql 
optimizer environments,
input parameter: 
    sql_id,
    child_nr1
    child_nr2 

 executes one sql defined via sqltext,
shows execution plan with runtime statistics
(you can set bind variables in prescript)

 selects an explain plan from SYS.PLAN_TABLE,
requirement: table PLAN_TABLE 
               in the schema SYS

 shows index statistics,
input parameter: table_owner (default: all),
                 table_name (default: all),
                 index_owner (defailt: all),
		 index_name (default: all)

 shows an execution plan for one SQL statement 
from the sqlarea,
input parameters: 
   SQL hash value and/or
   SQL Id and/or
   signature (exact or force matching_signature),
   SQL child number (default: all children),
   without_pred_info - without predicate information ?
                       (Y,N), default Y,
   truncate_other_to - truncate "OTHER" from
                       v$sql_plan to N 
                       characters,
                       (default : don't truncate)

 shows an execution plan for one SQL statement 
from AWR,
input parameter: SQL Id,
                 plan_hash_value
                 (default: all)

 shows an execution plan for one SQL statement 
from the sqlarea,
input parameter: SQL Id,
                 Child Number,
                 (default : 0)

 finds a current SQL of the QC (query coordinator)
through a current SQL of a running PQ (parallel query) 
slave.
input parameter: SQL address of a PQ slave
                 and / or
                 SQL hash value of a PQ slave

 shows current SQL addresses of running PQ 
(parallel queries)

 restores optimizer statistics for one table,
input parameters:
owner - table owner,
table_name - table name,
restore_time - restore time 
     (stats_update_time - 
      from stored stats for the table,
      (not for partition !))
  in 'DD-MON-YY HH.MI.SS.FF6 AM TZH:TZM' format. 
     Do not set this parameter, if you want only
     to see the history of stats modifications,
display_ind_stats - display index statistics
    (default: n),
force - restore statistis even if the table 
        statistics are locked (Y, N),
        default: N.

If optimizer stats were generated separately for
the table and for the indexes, then there is 
no common solution for clear restoring!  

Be careful with this script on the productive system ! 

 reports sessions having an open cursor
for a SQL statement,
input parameters: hash value and/or
                  sql_id
                  of the SQL statement

 turns on sql tracing for some minutes in 
a session, transfers the trace file to the 
client site, starts tkprof utility, 
input parameters: 
SID,
trace level: 
  1 - without bind variables and wait stats,
  4 - with bind variables and without wait stats,
  8 - without bind variables and with wait stats, 
 12 - with bind variables and with wait stats,
 default: 1,
duration_min - duration of tracing in min.,
  default: 5
tkprof_explain - 
  y - with connection to the database,
  n - without connection to the database,
  default: n,
tkprof_sort - sort criteria for tkprof,
  default: prsela exeela fchela (elapsed time).
ATTENTION: a directory and an external table 
will be created and finally droped           
 

 generates a script to turn on/off the sql
tracing for a session,
input parameters: SID,
                  trace level: 
1 - without bind variables and wait stats,
4 - with bind variables and without wait stats,
8 - without bind variables and with wait stats, 
12 - with bind variables and with wait stats,
default: 1

 top SQL statements from the STATSPACK
repository are reported,
input parameters: 
begin_time - start time (default : sysdate - 1),
end_time   - end time (default : sysdate),
(format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default: don't group data,
num_stmt - number of top statements, default 5,
with_sqltext - with SQL text in the output:
          ( Y - yes, N - no, default: Y),
trunc_sqltext_to - truncate SQL texts to N characters,
	           default - do not truncate,
with_exec_plan - with execution plans in the output:
	         (Y - yes, N - no, default: Y),
object_owner - object owner (default: all owners),
object_name - object name (default: all names),
object_type - object type (default: all types), 
command_type - one of the following SQL types:
CREATE TABLE,CREATE INDEX,ALTER INDEX,
SELECT,DELETE,INSERT,UPDATE,MERGE,
	 default : all commands types,
criteria - the criteria for top SQL statements:
 STATS [ E ], where STATS in
 (DR - disk reads, BG - buffer gets,
  CT - CPU time, ET - elapsed time,
  PL - PL/SQL execution time, 
  JA - JAVA execution time,
  WT - wait time, EX - executions,
  RP - rows processed, PC - parse calls,
  DW - direct writes, AP - application wait time,
  CO - concurrency wait time, CL - cluster wait time,
  IO - user io wait time),
  E - per execution. Combination EXE isn't allowed.
  Default : DR

 top SQL statements from the STATSPACK
repository are reported,
input parameters: 
begin_time - start time (default : sysdate - 1),
end_time   - end time (default : sysdate),
(format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default: don't group data,
num_stmt - number of top statements, default 5,
with_sqltext - with SQL text in the output:
          ( Y - yes, N - no, default: Y),
trunc_sqltext_to - truncate SQL texts to N characters,
	           default - do not truncate,
with_exec_plan - with execution plans in the output:
	         (Y - yes, N - no, default: Y),
program_id - object id,
             default - SQL's from all programs,
(hash_value - hash value of the statement
and/or
old_hash_value - old hash value of the statement,
             default - all statemens),
signature - exact or force matching signature of SQL,
            default - all statements,
command_type - one of the following SQL types:
CREATE TABLE,CREATE INDEX,ALTER INDEX,
SELECT,DELETE,INSERT,UPDATE,MERGE,
	 default : all commands types,
criteria - the criteria for top SQL statements:
 STATS [ E ], where STATS in
 (DR - disk reads, BG - buffer gets,
  CT - CPU time, ET - elapsed time,
  PL - PL/SQL execution time, 
  JA - JAVA execution time,
  WT - wait time, EX - executions,
  RP - rows processed, PC - parse calls,
  DW - direct writes, AP - application wait time,
  CO - concurrency wait time, CL - cluster wait time,
  IO - user io wait time),
  E - per execution. Combination EXE isn't allowed.
  Default : DR

 shows bind values for one SQL statement 
from the sqlarea,
input parameters: SQL Id,
                 Child Number,
                 (default : 0)

 searches sql_id in v$sql,
input parameters: 
       exact_signature, default: all,
       force_signature, default: all

 shows signature for a sql
from sqlarea (for selects 
from dba_sql_profiles, etc),
input parameters: sql_id

 generates signature for a sql
defined via sqltext (for selects 
from dba_sql_profiles, etc),
input parameter: force_match (TRUE, FALSE),
              default: FALSE

 shows a signature for a sql
defined via sqltext (for selects 
from dba_sql_profiles, etc),

You do not need TP licence to run this script!

 top SQL's from the sqlarea with
execution plans are reported,
input parameters:
what - the criteria for top SQL's:
[S|U|P] DR|BG|DW|CT|ET|WT|PL|JA|AP|CO|CL|IO [E]
      DR - disk reads,
      BG - block gets,
      DW - direct writes,
      CT - CPU time,
      ET - elapsed time,
      PL - PL/SQL execution time,
      JA - JAVA execution time,
      WT - wait time,
      AP - application wait time,
      CO - concurrency wait time,
      CL - cluster wait time,
      IO - user i/o wait time,
       E - per execution, 
       S - SQL's of one Session,
       U - SQL's of one user,
       P - SQL's of one Program,
num_stats - the number of the top SQL's,
par3 - [ <user name> | SID | Program (Object) Id ]
(defaults : what = DR, num_stats = 10, par3 = 1)

 reports indexes for a table,
input parameters: table owner 
                  (default: all),
                  table name.

 shows table statistics,
input parameter: owner (defailt: all),
		 table_name (default: all)

 transfers trace file to the client site,
starts tkprof utility,
input parameters: 
trace_name - name of the trace file,
tkprof_explain - 
  y - with connection to the database,
  n - without connection to the database,
  default: n,
tkprof_sort - sort criteria for tkprof,
  default: prsela exeela fchela (elapsed time).
ATTENTION: a directory and an external table 
will be created and finally droped 
 

 shows min. and max. of last analyzed dates
for user indexes,
input parameter: user name
                 (default: all users)

 shows min. and max. of last analyzed dates
for user tables,
input parameter: user name
                 (default: all users)

 selects an explain plan from
SYS.PLAN_TABLE via. DBMS_XPLAN.DISPLAY,
input parameter: format - ALL, ADVANCED,
                      default: ALL,
requirement: table PLAN_TABLE in the
             schema SYS

 shows a current SQL for a session,
input parameter: sid

 shows session details from AWR,
input parameters: 
   begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
   end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
   sid,
   serial (default: all serials)
 

 finds SID through ORAPID,
input parameter: orapid 

 finds SID through OS PID.
input parameter: pid 

 shows previous SQL for a session,
input parameter : sid

 shows system statistics for a session,
input parameters : 
   sid,
   stat_name_like - statistics name 
                    (default : all)

 shows sessions long operations,
input parameter : sid
       (default : all)

 shows system memory statistics
for running sessions,
input parameter: sid
      (default: all sessions)

 reports open cursors for a session,
input parameter: sid 

 shows pga memory 
for running processes

 shows PGA statistics for sessions, 
input parameter : sid
        (default: all sessions)

 finds a rollback segment for a session,
input parameter: sid, 
                (default: all sessions)

 reports sort usage of sessions,
input parameter : sid,
       (default : all sessions)

 shows time model statistics for one session,
input parameter: sid,
requirement: TIMED_STATISTICS=TRUE 

 reports sessions having an open cursor
for a SQL statement,
input parameters: hash value and/or
                  sql_id
                  of the SQL statement

 shows work area activity for 
sessions,
input parameter: sid
    (default : all Sessions) 

 shows session optimizer environment,
input parameter: 
    sid,
    IsDefault - Default?  (Y, N),
    (default : all parameters)

 finds ORAPID through SID,
input parameter: sid 

 finds OS PID through SID,
input parameter: sid

 shows session details,
input parameters:
  sid,
  serial (default: all serials)

 shows dictionary cache usage

 shows library cache usage

 shows a breakdown for the large pool

 creates a script to pin the objects in SGA

 shows allocations causing shared pool memory 
to be aged out

 shows space in reserved shared pool and ORA-4031

 shows SGA statistics 

 monitors SGA statistics,
input parameter : sleep interval (sec.)
                  (default : 60)

 shows a breakdown for the shared pool,
attention: this script may cause performance
           problems because it needs to hold
           shared pool latch

 shows free space in the shared pool,
attention: this script may cause performance
           problems because it needs to hold
           shared pool latch

 reports SQL's from the sqlarea
which have been executed only ones

 reports 5 top enqueues from the 
STATSPACK repository as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default : S,
gr_yrange_enq_stat - y-range in the following
                       format: <number>:<number>

 reports 5 top non-idle wait events from the 
STATSPACK repository as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default : S,
gr_yrange_wait_event - y-range in the following
                       format: <number>:<number>

 reports 5 top data files for the average
duration of one physical read from the 
STATSPACK repository as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default : S,
gr_yrange_file_stat - y-range in the following
                       format: <number>:<number>

 reports 5 top latches from the 
STATSPACK repository as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default : S,
gr_yrange_latch_stat - y-range in the following
                       format: <number>:<number>

 reports 5 top segments for physical reads 
from the STATSPACK repository as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default : S,
gr_yrange_seg_stat - y-range in the following
                       format: <number>:<number>

 reports 5 top shared pool statistics 
from the STATSPACK repository as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default : S,
gr_yrange_sga_stat - y-range for the sga
                   statistics in the following
                   format: <number>:<number>

 reports all system cpu statistics and the 
number of processes  from the STATSPACK 
repository as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default : S,
gr_yrange_sys_stat - y-range in the following
                     format: <number>:<number>,
gr_yrange_sys_curr_stat - y-range for the number
                   of processes in the following
                   format: <number>:<number>

 reports cpu os statistics from the STATSPACK 
repository as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default : S,
gr_yrange_os_stat - y-range in the following
                     format: <number>:<number>,
gr_yrange_os_curr_stat - y-range in the following
                     format: <number>:<number>

 reports io wait events and statistics  
from the STATSPACK repository as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default : S,
gr_yrange_wait_event - y-range in the following
                       format: <number>:<number>,
gr_yrange_sys_stat - y-range in the following
                       format: <number>:<number>

 reports dblink wait events and statistics  
from the STATSPACK repository as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default : S,
gr_yrange_wait_event - y-range in the following
                       format: <number>:<number>,
gr_yrange_sys_stat - y-range in the following
                       format: <number>:<number>

 reports logons statistics from the STATSPACK 
repository as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default : S,
gr_yrange_sys_stat - y-range for the cumulative
                     logons in the following
                     format: <number>:<number>,
gr_yrange_sys_curr_stat - y-range for the current
                   logons in the following
                   format: <number>:<number>

 reports paging os statistics from the STATSPACK 
repository as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default : S,
gr_yrange_os_stat - y-range in the following
                     format: <number>:<number>

 reports downgrade statistics for parallel 
operations from the STATSPACK repository as a 
graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default : S,
gr_yrange_sys_stat - y-range in the following
                     format: <number>:<number>

 reports system statistics for parallel 
operations from the STATSPACK repository as a 
graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default : S,
gr_yrange_sys_stat - y-range in the following
                     format: <number>:<number>

 reports total waits for non-idle 
events and cpu statistics from the STATSPACK
repository as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default : S,
gr_yrange_sum_waits - 
            y-range in the following format: 
            <number>:<number>,
gr_yrange_sys_stat - 
            y-range in the following format:
            <number>:<number>

 reports enqueue statistics from the 
STATSPACK repository as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default: S,
gr_title - graphics title,
enq_stat_name - statistics to select
            (TOTAL_REQ#, TOTAL_WAIT#,
             SUCC_REQ#, FAILED_REQ#,
             CUM_WAIT_TIME),
            default : CUM_WAIT_TIME,
gr_abs_or_rel_enq_stat - 
   (abs - absolute values will be 
          presented on the graphics,
    rel - values per sec. will be
          presented on the graphics,
    default : rel),
gr_y_or_y2_enq_stat -
    (y - y-axis will be used,
     y2 - y2-axis will be used,
     default : y),
gr_yrange_enq_stat - y-range in the following
                       format: <number>:<number>,
gr_top_enq_stat - number of top enqueues,
                   default : 0,
gr_stat_name_N - name of an enqueue in the
                 following format:
                 <type> - <req. reason>, for ex.
                  TX - contention,
                 default : no name 

 reports data file statistics from the 
STATSPACK repository as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default: S,
gr_title - graphics title,
file_stat_name - statistics to select
            (READTIM,WRITETIM,PHYRDS, 
             PHYWRTS, PHYBLKRD, 
             PHYBLKWRT, READTIM/PHYRDS),
            default : READTIM/PHYRDS,
gr_abs_or_rel_file_stat - 
   (abs - absolute values will be 
          presented on the graphics,
    rel - values per sec. will be
          presented on the graphics,
    default : rel),
gr_y_or_y2_file_stat -
    (y - y-axis will be used,
     y2 - y2-axis will be used,
     default : y),
gr_yrange_file_stat - y-range in the following
                       format: <number>:<number>,
gr_top_file_stat - number of top data files,
                   default : 0,
gr_stat_name_N - name of a data file,
                 default : no name 

 reports latch statistics from the 
STATSPACK repository as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default: S,
gr_title - graphics title,
latch_stat_name - statistics to select
            (GETS,MISSES,SLEEPS, 
             IMMEDIATE_GETS, 
             IMMEDIATE_MISSES, 
             SPIN_GETS,WAIT_TIME),
            default : SLEEPS,
gr_abs_or_rel_latch_stat - 
   (abs - absolute values will be 
          presented on the graphics,
    rel - values per sec. will be
          presented on the graphics,
    default : rel),
gr_y_or_y2_latch_stat -
    (y - y-axis will be used,
     y2 - y2-axis will be used,
     default : y),
gr_yrange_latch_stat - y-range in the following
                       format: <number>:<number>,
gr_top_latch_stat - number of top latches,
                   default : 0,
gr_stat_name_N - name of a latch,
                 default : no name 

 reports current (not cumulative) os 
statistics from the STATSPACK repository 
as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default : S
gr_title - graphics title,
gr_y_or_y2_os_curr_stat -
    (y - y-axis will be used,
     y2 - y2-axis will be used,
     default : y),
gr_yrange_os_curr_stat - y-range in 
      he following format: <number>:<number>,
gr_stat_name_N - name of a system statistics,
                 default : no name   

 reports os statistics from the STATSPACK
repository as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default : S
gr_title - graphics title,
gr_abs_or_rel_os_stat - 
   (abs - absolute values will be 
          presented on the graphics,
    rel - values per sec. will be
          presented on the graphics,
    default : rel),
gr_y_or_y2_os_stat -
    (y - y-axis will be used,
     y2 - y2-axis will be used,
     default : y),
gr_yrange_os_stat - y-range in the following
                       format: <number>:<number>,
gr_stat_name_N - name of a system statistics,
                 default : no name   

 reports segment statistics from the 
STATSPACK repository as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default: S,
gr_title - graphics title,
seg_stat_name - statistics to select
  (LOGICAL_READS, BUFFER_BUSY_WAITS,
   DB_BLOCK_CHANGES, PHYSICAL_READS,
   PHYSICAL_WRITES, ITL_WAITS,
   DIRECT_PHYSICAL_READS,
   DIRECT_PHYSICAL_WRITES,
   GC_CR_BLOCKS_RECEIVED,
   GC_CURRENT_BLOCKS_RECEIVED,
   GC_BUFFER_BUSY, ROW_LOCK_WAITS,
   GLOBAL_CACHE_CR_BLOCKS_SERVED,
   GLOBAL_CACHE_CU_BLOCKS_SERVED)
  default : PHYSICAL_READS,
object_type - object type 
  (TABLE, INDEX,
   TABLE PARTITION, INDEX PARTITION,
   LOB, etc.),
  default: all,
gr_abs_or_rel_seg_stat - 
   (abs - absolute values will be 
          presented on the graphics,
    rel - values per sec. will be
          presented on the graphics,
    default : rel),
gr_y_or_y2_seg_stat -
    (y - y-axis will be used,
     y2 - y2-axis will be used,
     default : y),
gr_yrange_seg_stat - y-range in the following
                   format: <number>:<number>,
gr_top_seg_stat - number of top segments,
                   default : 0,
gr_stat_name_N - name of a segment as
          <owner>.<obj_name>[.<subobj_name>],
                 default : no name 

 reports current sga statistics from 
the STATSPACK repository as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default: S,
        if group <> S, then average statistics 
        values will be calculated,
gr_title - graphics title,
gr_y_or_y2_sga_stat -
    (y - y-axis will be used,
     y2 - y2-axis will be used,
     default : y),
gr_yrange_sga_stat - y-range in the following
                       format: <number>:<number>,
pool_name - pool name, default: no name,
gr_stat_name_N - name of a sga statistics in
                 the following form:
                 <pool>:<stat_name>, for ex.
                 shared pool:free memory,
                 default : no name 

 reports total waits for non-idle events
from the STATSPACK repository as a graphics
input parameters: 
begin_time - start time, 
              (format - dd.mm.yyyy hh24:mi:ss),
             default : sysdate - 1,
end_time   - end time, 
              (format - dd.mm.yyyy hh24:mi:ss),
             default : sysdate,
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default : S,
gr_title - graphics title,
gr_abs_or_rel_sum_waits - 
   (abs - absolute wait times will be 
          presented on the graphics,
    rel - wait times per sec. will be
          presented on the graphics,
    default : rel),
gr_y_or_y2_sum_waits -
    (y - y-axis will be used for wait times,
     y2 - y2-axis will be used for wait times,
     default : y),
gr_yrange_sum_waits - 
            y-range in the following format:
            <number>:<number>

 reports current (not cumulative) system 
statistics from the STATSPACK repository as 
a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default: S,
        if group <> S, then average statistics 
        values will be calculated,
gr_title - graphics title,
gr_y_or_y2_sys_curr_stat -
    (y - y-axis will be used,
     y2 - y2-axis will be used,
     default : y),
gr_yrange_sys_curr_stat - y-range in the following
                       format: <number>:<number>,
gr_stat_name_N - name of a system statistics,
                 default : no name 

 reports system statistics from the 
STATSPACK repository as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default: S,
gr_title - graphics title,
gr_abs_or_rel_sys_stat - 
   (abs - absolute values will be 
          presented on the graphics,
    rel - values per sec. will be
          presented on the graphics,
    default : rel),
gr_y_or_y2_sys_stat -
    (y - y-axis will be used,
     y2 - y2-axis will be used,
     default : y),
gr_yrange_sys_stat - y-range in the following
                       format: <number>:<number>,
gr_stat_name_N - name of a system statistics,
                 default : no name 

 reports wait statistics from the STATSPACK
repository as a graphics,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default : S
only_non_idle_events - 
   (Y - only non idle events in the output,
    N - all events,
    default : Y)
gr_title - graphics title,
gr_abs_or_rel_wait_event - 
   (abs - absolute wait times will be 
          presented on the graphics,
    rel - wait times per sec. will be
          presented on the graphics,
    default : rel),
gr_y_or_y2_wait_event -
    (y - y-axis will be used for wait times,
     y2 - y2-axis will be used for wait times,
     default : y),
gr_yrange_wait_event - y-range in the following
                       format: <number>:<number>,
gr_top_wait_event - number of top wait events,
                    default : 0,
gr_stat_name_N - name of a wait event,
                 default : no name   

 top SQL statements from the STATSPACK
repository are reported,
input parameters: 
begin_time - start time (default : sysdate - 1),
end_time   - end time (default : sysdate),
(format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default: don't group data,
num_stmt - number of top statements, default 5,
with_sqltext - with SQL text in the output:
          ( Y - yes, N - no, default: Y),
trunc_sqltext_to - truncate SQL texts to N characters,
	           default - do not truncate,
with_exec_plan - with execution plans in the output:
	         (Y - yes, N - no, default: Y),
object_owner - object owner (default: all owners),
object_name - object name (default: all names),
object_type - object type (default: all types), 
command_type - one of the following SQL types:
CREATE TABLE,CREATE INDEX,ALTER INDEX,
SELECT,DELETE,INSERT,UPDATE,MERGE,
	 default : all commands types,
criteria - the criteria for top SQL statements:
 STATS [ E ], where STATS in
 (DR - disk reads, BG - buffer gets,
  CT - CPU time, ET - elapsed time,
  PL - PL/SQL execution time, 
  JA - JAVA execution time,
  WT - wait time, EX - executions,
  RP - rows processed, PC - parse calls,
  DW - direct writes, AP - application wait time,
  CO - concurrency wait time, CL - cluster wait time,
  IO - user io wait time),
  E - per execution. Combination EXE isn't allowed.
  Default : DR

 reports initialization parameters from the
STATSPACK repository,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),
param_like - parameter name
              (default : all parameters),
not_default - not default ? (TRUE, FALSE)
              (default : TRUE)
not_autom_sized - not automatically sized
                  parameters ? (TRUE, FALSE),
                  (default : TRUE)

 produces standard statspack report,
input parameters:
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss)

 overviews the snapshots from the STATSPACK
repository,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss)

 top SQL statements from the STATSPACK
repository are reported,
input parameters: 
begin_time - start time (default : sysdate - 1),
end_time   - end time (default : sysdate),
(format - dd.mm.yyyy hh24:mi:ss),
group - grouping criteria:
       ( D - day, H - hour, S - snap_id),
        default: don't group data,
num_stmt - number of top statements, default 5,
with_sqltext - with SQL text in the output:
          ( Y - yes, N - no, default: Y),
trunc_sqltext_to - truncate SQL texts to N characters,
	           default - do not truncate,
with_exec_plan - with execution plans in the output:
	         (Y - yes, N - no, default: Y),
program_id - object id,
             default - SQL's from all programs,
(hash_value - hash value of the statement
and/or
old_hash_value - old hash value of the statement,
             default - all statemens),
signature - exact or force matching signature of SQL,
            default - all statements,
command_type - one of the following SQL types:
CREATE TABLE,CREATE INDEX,ALTER INDEX,
SELECT,DELETE,INSERT,UPDATE,MERGE,
	 default : all commands types,
criteria - the criteria for top SQL statements:
 STATS [ E ], where STATS in
 (DR - disk reads, BG - buffer gets,
  CT - CPU time, ET - elapsed time,
  PL - PL/SQL execution time, 
  JA - JAVA execution time,
  WT - wait time, EX - executions,
  RP - rows processed, PC - parse calls,
  DW - direct writes, AP - application wait time,
  CO - concurrency wait time, CL - cluster wait time,
  IO - user io wait time),
  E - per execution. Combination EXE isn't allowed.
  Default : DR

 reports instance startup times from the 
STATSPACK repository,
input parameters: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss)

 changes outlines category,
input parameter: outline_name,
                 new category

 creates outline for one SQL
from sqlarea (sql_fulltext,v$sqlarea),
input parameters:
sql_id,
ouline_name (default: id_<sql_id>),
category (default: DEFAULT)
 

 creates outline for one SQL
from sqlarea (v$sqltext_with_newlines),
input parameters:
address and/or
hash_value,
outline_name (default: hv_<hash_value>_<sysdate>),
category (default: DEFAULT)

 creates outline for one SQL
defined via sqltext,
input parameters:
outline_name,
category (default: DEFAULT)
 

 creates a file with formatted sqltext from outline
input parameter: outln_name

 selects from dba_outlines,
input parameters: outline_name
                  (default : all),
                  category
                  (default : all),
                  signature
                  (default : all)

 drops an outline,
input parameter: outline_name

 drops outlines by category,
input parameter: category

 inserts hidden hints in stored outline
for a sql without hints from stored outline
for the same sql with hints,
input parameters: 
     originalsql_outln_name - name of stored
                              outline for sql
                              without hints,
     hintedsql_outln_name - name of stored 
                            outline for the
                            same sql with hints

 clear status "used" for outline,
input parameter: ouline_name

 generates a command to enable
outline category in a session,
input parameter: category,
          default: DEFAULT

 generates outline signature for a sql
from sqlarea (for selects from 
dba_outlines, etc) 
input parameter: sql_id

 generates outline signature for a sql
defined via sqltext (for selects 
from dba_outlines, etc)

 shows os statistics,
input parameter : 
stat_name_like - statistic name
                (default : all)

 monitors os statistics,
input parameter:
stat_name_like - statistics name 
                 (default: AVG%TIME),
sleep_interval_sec - sleep interval (sec.)
                 (default: 30)

 shows system statistics for a session,
input parameters : 
   sid,
   stat_name_like - statistics name 
                    (default : all)

 monitors system statistics for one session,
input parameters:
sid - SID of the session,
like_stat_name - statistics name 
                (default: all),
sleep_interval_sec - sleep interval in sec.
                (default: 30)

 shows system memory statistics
for running sessions,
input parameter: sid
      (default: all sessions)

 monitors one statistics for all sessions,
input parameters:
statistics_name - statistics name
            (default: "CPU used by this session"),
sleep_interval_sec - sleep interval in sec.
            (default: 30),
num_top_sessions - number of top sessions. 
            (default: 10), 
requirement : TIMED_STATISTICS=TRUE 

 shows time model statistics for one session,
input parameter: sid,
requirement: TIMED_STATISTICS=TRUE 

 shows names of os statistics,
input parameter : 
stat_name_like - statistics name,
                 (default : all) 

 shows names of system statistics,
input parameter : 
stat_name_like - statistics name,
                 (default : all) 

 reports system sort statistics

 shows system statistics,
input parameter : 
stat_name_like - statistic name
                (default : all)

 monitors system statistics,
input parameter:
stat_name_like - statistics name 
                 (default: physical%),
sleep_interval_sec - sleep interval (sec.)
                 (default: 30),
requirement : TIMED_STATISTICS=TRUE

 shows system time model statistics 
requirement: TIMED_STATISTICS=TRUE 

 shows relationships between the 
system time model statistics 

 shows a current SQL of the sessions
waiting for an event,
input parameter: event name 

 shows, how long are sessions waiting 
for an event,
input parameter: event name,
requirement : TIMED_STATISTICS=TRUE 

 shows the number of waiting sessions per event 

 shows, how long the running sessions 
waited for an event,
input parameter: event name,
requirement : TIMED_STATISTICS=TRUE 

 monitoring of blocking sessions
for an event,
input parameters: event_name_like,
      (default: all events),
                  sleep interval (sec.),
      (default: 60)

 reports blocking sessions 
for an event,
input parameter: event_name_like,
       default : all events

 reports history of blocking sessions 
for an event,
input parameter: 
begin_time - start time (default : sysdate - 1),
              (format - dd.mm.yyyy hh24:mi:ss),
end_time   - end time (default : sysdate),
              (format - dd.mm.yyyy hh24:mi:ss),

event_name_like - default: all events

 reports the block classes and data files affected
by buffer busy waits.
Pior to release 8.1.6 run first the script 
$ORACLE_HOME/rdbms/admin/catperf.sql to
create the view V$BUFFER_POOL_STATISTICS

 monitors buffer busy wait statistics,
input parameter:
sleep_interval_sec - sleep interval in sec.
                     (default: 30),
requirement : TIMED_STATISTICS=TRUE 

 reports sessions waiting for the
following wait events:
cursor: pin S wait on X,
cursor: pin S,
cursor: pin X
cursor: mutex X

 monitors wait events,
input parameters:
sleep_interval_sec - sleep interval in sec.
                     (default: 30),
num_top_events - number of top events
                     (default: all), 
requirement : TIMED_STATISTICS=TRUE 

 monitors buffer waits for datafiles,
input parameters:
sleep_interval_sec - sleep interval in sec.
                      (default: 30),
num_top_data_files - number of top datafiles
                      (default: all), 
requirement : TIMED_STATISTICS=TRUE 

 monitors non-idle wait events,
input parameter : sleep interval (sec.),
                  (default : 60),
requirement : TIMED_STATISTICS=TRUE

 reports waiting time for non-idle events,
requirement : TIMED_STATISTICS=TRUE

 shows sessions waiting for library cache lock

 shows sessions waiting for library cache pin

 shows wait statistics for one session,
input parameter: SID,
requirement: TIMED_STATISTICS=TRUE 

 shows complete names of wait events with 
wait classes and descriptions of respective 
parameters from the view sys.v_$session_wait,
input parameter: 
event_name_like - event name
                 (default: all events) 

 shows summary wait statistics for 
running sessions,
requirement : TIMED_STATISTICS=TRUE 

 shows system wait statistics, 
requirement : TIMED_STATISTICS=TRUE 

 shows an execution plan for one SQL statement 
from the sqlarea,
input parameters: 
   SQL hash value and/or
   SQL Id and/or
   signature (exact or force matching_signature),
   SQL child number (default: all children),
   without_pred_info - without predicate information ?
                       (Y,N), default Y,
   truncate_other_to - truncate "OTHER" from
                       v$sql_plan to N 
                       characters,
                       (default : don't truncate)

 shows PGA statistics 

 shows pga memory 
for running processes

 shows PGA statistics for sessions, 
input parameter : sid
        (default: all sessions)

 reports sort usage of sessions,
input parameter : sid,
       (default : all sessions)

 shows work area activity for 
sessions,
input parameter: sid
    (default : all Sessions) 

 reports system sort statistics

 shows workarea histograms 

 generates a create script for the X_$ views
used in this tool,
input parameter : user to grant select privileges
on the X_$ views
(default: public)

 generates a script to grant the select privileges
on the SYS tables used in this tool,
input parameter : user to grant select privileges
on the SYS tables
(default: public)

 prepares not sys user for working with this tool,
input parameter : user name
                  (default : user XYZ)