Automatic Workload Repository
GPTKB entity
Statements (37)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
gptkb:database
|
| gptkbp:abbreviation |
gptkb:AWR
|
| gptkbp:accessibleBy |
gptkb:Oracle_Enterprise_Manager
SQL scripts AWR reports DBA_HIST views DBMS_WORKLOAD_REPOSITORY package |
| gptkbp:dataRetention |
configurable
default 8 days |
| gptkbp:documentation |
https://docs.oracle.com/en/database/oracle/oracle-database/19/tgdba/automatic-workload-repository.html
|
| gptkbp:enables |
historical analysis
trend analysis performance analysis bottleneck identification system tuning SQL tuning |
| https://www.w3.org/2000/01/rdf-schema#label |
Automatic Workload Repository
|
| gptkbp:introducedIn |
gptkb:Oracle_Database_10g
|
| gptkbp:license |
Oracle Diagnostics Pack
|
| gptkbp:notableCollection |
performance statistics
wait events system metrics Active Session History SQL statistics workload data |
| gptkbp:partOf |
gptkb:Oracle_Database
|
| gptkbp:purpose |
performance monitoring
database diagnostics |
| gptkbp:relatedTo |
gptkb:Statspack
Active Session History Oracle Performance Tuning |
| gptkbp:snapshotInterval |
configurable
default 60 minutes |
| gptkbp:storage |
SYSAUX tablespace
|
| gptkbp:bfsParent |
gptkb:AWR
gptkb:Oracle_19c |
| gptkbp:bfsLayer |
7
|