Automatic Workload Repository
Oracle 12c
| Intermediate
- 9 videos | 25m 42s
- Includes Assessment
- Earns a Badge
The Automatic Workload Repository provides services to database components to collect, maintain, and use statistics for issue detection and self-tuning. Explore AWR in Oracle Database 12c, including administration and reporting.
WHAT YOU WILL LEARN
-
describe the Automatic Workload Repositorydescribe the types of statistics stored in AWR and the AWR architectureuse EM cloud control to configure AWRuse a PL/SQL package to manage and modify AWR snapshot settingsuse EM cloud control and SQL*Plus to generate an AWR report
-
describe the sections of an AWR reportdescribe how to compare two periods in AWRdescribe the structure of an AWR comparison reportuse EM cloud control to generate and review an AWR report
IN THIS COURSE
-
1.Automatic Workload Repository2m 33s
-
2.AWR Architecture1m 50s
-
3.AWR Administration2m 21s
-
4.Managing Snapshots with PL/SQL2m 15s
-
5.Generating AWR Reports3m 1s
-
6.Reading an AWR Report3m 17s
-
7.Producing Reports Comparing Periods2m 23s
-
8.Reading an AWR Comparison Report2m 13s
-
9.Exercise: Review an AWR Report5m 49s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.