dba:oracle:docs:awr
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | |||
dba:oracle:docs:awr [2023/01/31 08:22] – removed - external edit (Unknown date) 127.0.0.1 | dba:oracle:docs:awr [2023/01/31 08:22] (current) – ↷ Page moved from dba:oracle:awr to dba:oracle:docs:awr dodger | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== [DOC] AWR ====== | ||
+ | |||
+ | ====== Configuration ====== | ||
+ | ===== Actual config ===== | ||
+ | |||
+ | <code sql> | ||
+ | select * from dba_hist_wr_control ; | ||
+ | </ | ||
+ | or, only timings: | ||
+ | <code sql> | ||
+ | select | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | from dba_hist_wr_control | ||
+ | / | ||
+ | </ | ||
+ | |||
+ | ===== retention ===== | ||
+ | |||
+ | ==== modify ==== | ||
+ | Modify, units are minutes: | ||
+ | <code sql> | ||
+ | BEGIN | ||
+ | DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS( | ||
+ | retention => 20160); | ||
+ | END; | ||
+ | / | ||
+ | </ | ||
+ | |||
+ | ===== frequency ===== | ||
+ | Modify, units are minutes: | ||
+ | <code sql> | ||
+ | BEGIN | ||
+ | DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS( | ||
+ | interval | ||
+ | END; | ||
+ | / | ||
+ | </ | ||
+ | |||
+ | |||
+ | ===== Number of SQL's captured on each snapshot ===== | ||
+ | Modify, units are minutes: | ||
+ | <code sql> | ||
+ | BEGIN | ||
+ | DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS( | ||
+ | topnsql | ||
+ | END; | ||
+ | / | ||
+ | </ | ||
+ | |||
+ | ====== Basic queries ====== | ||
+ | |||
+ | ===== List AWR snapshots ===== | ||
+ | <code sql> | ||
+ | select | ||
+ | DBID, | ||
+ | snap_id, | ||
+ | snap_level, | ||
+ | to_char(begin_interval_time, | ||
+ | from | ||
+ | | ||
+ | order by 1; | ||
+ | </ | ||
+ | |||
+ | ===== View SQL_TEXT of selected SQL_ID ===== | ||
+ | <code sql> | ||
+ | select SQL_TEXT from WRH$_SQLTEXT where SQL_ID='< | ||
+ | </ | ||
+ | |||
+ | |||
+ | |||
dba/oracle/docs/awr.txt · Last modified: 2023/01/31 08:22 by dodger