dba:oracle:docs:awr
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Last revisionBoth sides next revision | ||
dba:oracle:awr [2022/02/11 11:12] – ↷ Page moved from oracle:awr to dba:oracle:awr dodger | dba:oracle:docs:awr [2023/01/31 08:22] – removed - external edit (Unknown date) 127.0.0.1 | ||
---|---|---|---|
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