[Oracle Database] Oracle AWR
Snapshot SQL > col begin_interval_time for a30SQL > col end_interval_time for a30SQL > select snap_id, to_char (begin_interval_time,'yyyy-mm-dd hh34:mi:ss') begin_interval_time, to_char (end_interval_time,'yyyy-mm-dd hh34:mi:ss') end_interval_time from dba_hist_snapshot order by 1 SNAP_ID BEGIN_INTERVAL_TIME END_INTERVAL_TIME- 2018-06-25 19:00:22 2018-06-25 20:00 : 25 156 2018-06-25 20:00:25 2018-06-25 21:00:27 15715706-06-25 21:00:27 2018-06-25 22:00:33 1582018-06-25 22:00:33 2018-06-25 23:00:36 1590006-25 23:00:36 2018-06-26 00Peruvian 39 160 2018-06-26 00:00:39 2018-06-26 01:00:41 1612018-06-26 01:52:17 2018-06-26 02:04:22 1622018-06-26 02:04:22 2018-06-26 03:00:24 1632018-06-26 03:00:24 2018-06-26 04 purge 27 164 2018- 06-26 04:00:27 2018-06-26 05:00:29 165165 2018-06-26 05:00:29 2018-06-26 06:00:32 SQL > exec dbms_workload_repository.create_snapshot () PL/SQL procedure successfully completed.SQL > exec dbms_workload_repository.drop_snapshot_range; PL/SQL procedure successfully completed.SQL > col snap_interval for a20SQL > col retention for a20SQL > select snap_interval,retention,topnsql from dba_hist_wr_control SNAP_INTERVAL RETENTION TOPNSQL--+ 00000 01 exec dbms_workload_repository.modify_snapshot_settings 00.0 + 00008 00008 exec dbms_workload_repository.modify_snapshot_settings 00.0 DEFAULTSQL > 00.0 (retention= > 15001440 discipline interval30) PL/SQL procedure successfully completed.SQL > select snap_interval,retention,topnsql from dba_hist_wr_control SNAP_INTERVAL RETENTION TOPNSQL- + 00000 00015 SQL 00.0 + 00015 00 SQL 00.0 baseline exec dbms_workload_repository.create_baseline Baseline_name= > 'baseline01') PL/SQL procedure successfully completed.SQL > col baseline_name for a30SQL > select baseline_name,baseline_id,start_snap_id,end_snap_id from dba_hist_baseline BASELINE_NAME BASELINE_ID START_SNAP_ID END_SNAP_ID---baseline01 1 155 156SYSTEM _ MOVING_WINDOW 01 168SQL > exec dbms_workload_repository.drop_baseline (baseline_name= > 'baseline01' Cascade= > false) PL/SQL procedure successfully completed.SQL > select baseline_name,baseline_id,start_snap_id,end_snap_id from dba_hist_baseline BASELINE_NAME BASELINE_ID START_SNAP_ID END_SNAP_ID---SYSTEM_MOVING_WINDOW 0 1 168 Report SQL > @? / rdbms/admin/awrrpt.sql-- generate the most common AWR report SQL > @? / rdbms/admin/awrddrpt.sql-- compare two AWR reports SQL > @? / rdbms/admin/awrsqrpt.sql-- generate the execution plan of the specified sql_id in the AWR report
