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