@?/rdbms/admin/awrrpt.sql -- basic AWR report
@?/rdbms/admin/awrsqrpt.sql -- Standard SQL statement Report
@?/rdbms/admin/awrddrpt.sql -- Period diff on current instance
@?/rdbms/admin/awrrpti.sql -- Workload Repository Report Instance (RAC)
@?/rdbms/admin/awrgrpt.sql -- AWR Global Report (RAC)
@?/rdbms/admin/awrgdrpt.sql -- AWR Global Diff Report (RAC)
@?/rdbms/admin/awrinfo.sql -- Script to output general AWR information
==========================================================================================
set lines 100 pages 999
select snap_id,
snap_level,
to_char(begin_interval_time, 'dd/mm/yy hh24:mi:ss') begin
from
dba_hist_snapshot
order by 1;
@$ORACLE_HOME/rdbms/admin/awrrpt.sql
@%ORACLE_HOME%\rdbms\admin\awrrpt.sql
Diff Report
===========
@$ORACLE_HOME/rdbms/admin/awrddrpt.sql
For Multiple AWR reports from a RAC database instances.
To run Global AWR :
===================
define report_type = 'html';
define num_days = 2;
define begin_snap = 15024;
define end_snap = 15025;
@$ORACLE_HOME/rdbms/admin/awrgrpt.sql
To run ASH report
=================
define report_type = 'html'
define begin_time = '07/27/14 22:20:00'
define duration = 10
define report_name = ashrpt_1_0727_2230.html
@$ORACLE_HOME/rdbms/admin/ashrpt.sql
Summary of All User Input
-------------------------
Format : HTML
DB Id : 305917710
Inst num : 1
Begin time : 27-Jul-14 22:10:00
End time : 27-Jul-14 22:20:00
Slot width : Default
Report targets : 0
Report name : ashrpt_1_0727_2220.html
