Database Maintenance
Oracle 12c
| Intermediate
- 11 Videos | 40m 9s
- Includes Assessment
- Earns a Badge
Oracle Database 12c includes many features that simplify routine database maintenance and performance tuning. Learn how to configure and use the automated database monitoring and maintenance features available in Oracle Database 12c.
WHAT YOU WILL LEARN
-
describe database maintenance tasks and view alert history in Oracle Database 12cdescribe the Automatic Workload Repository (AWR) and its infrastructure in Oracle Database 12ccreate an Automatic Workload Repository (AWR) baseline in Oracle Database 12cmanage Automatic Workload Repository (AWR) settings in Oracle Database 12cset the STATISTICS_LEVEL parameter for a database in Oracle Database 12cuse the Automatic Database Diagnostic Monitor in Enterprise Manager in Oracle Database 12c
-
describe the Advisory Framework in Oracle Database 12caccess the Advisor Central page in Enterprise Manager and identify the packages used to invoke advisors in Oracle Database 12cdescribe and view the automated database maintenance tasks in Oracle Database 12cdescribe server-generated alerts and set metric thresholds for them in Oracle Database 12crecognize different alert types and clear alerts in Oracle Database 12c
IN THIS COURSE
-
1.Introduction to Database Maintenance5m 11s
-
2.The Automatic Workload Repository5m 20s
-
3.Creating an AWR Baseline2m 38s
-
4.Managing AWR3m 11s
-
5.Setting a Statistics Level2m 16s
-
6.Using the ADDM3m 13s
-
7.The Advisory Framework5m 33s
-
8.Accessing Advisors2m 53s
-
9.Automated Maintenance Tasks3m 39s
-
10.Configuring Server-Generated Alerts4m
-
11.Recognizing and Clearing Alerts2m 16s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.