Oracle AWR report
Automatic Workload Repository or AWR Oracle report collects, processes, and maintains performance statistics for problem detection and selftuning purposes. This gathered data is stored both in memory and in the database and is displayed in both reports and views.
The AWR warehouse is built in the SYS schema, using the SYSAUX tablespace by default. Oracle Database, by default captures snapshots once every hour; the snapshot size varies depending on the database load. These snapshots will be stored in SYSAUX tablespace.
For more Information Visit:
https://asrblogger.com/
Join Telegram : https://t.me/asrBlogger
Scripts from Github : https://github.com/anishs10/dbscripts
Sample AWR & ASH Report Link:
https://asrblogger.com/oracleawraut...
https://asrblogger.com/ashactiveses...
#oracledatabase #oracledatabasetutorial #performancetuning #databasetuning #performanceoptimization #asrblogger #asrbloggerdba