AWR

Understanding AWR quick

Quick Instructions For Obtaining The Automatic Workload Repository (AWR) Report [ID 1086120.1]
FAQ: How to Use AWR reports to Diagnose Database Performance Issues [ID 1359094.1]
How to Read PGA Memory Advisory Section in AWR and Statspack Reports [ID 786554.1]
How to Interpret the OS stats section of an AWR report [ID 762526.1]


AWR report
@?/rdbms/admin/awrrpt.sql
@?/rdbms/admin/awrrpti.sql   ------- RAC


AWR snapshot interval
select * from dba_hist_wr_control;
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
AWR snapshots available
set line 150
col startup_time for a30
col END_INTERVAL_TIME for a30
col BEGIN_INTERVAL_TIME for a30
SELECT snap_id, startup_time,BEGIN_INTERVAL_TIME,END_INTERVAL_TIME
FROM dba_hist_snapshot
ORDER BY 1,2;
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DROP_SNAPSHOT_RANGE

Drop a range of snapshots dbms_workload_repository.drop_snapshot_Range(
low_snap_id IN NUMBER,
high_snap_id IN NUMBER
dbid IN NUMBER DEFAULT NULL);
exec dbms_workload_repository.drop_snapshot_range(1105, 1199);