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 12c
Describe the automatic workload repository (awr) and its infrastructure in oracle database 12c
Create an automatic workload repository (awr) baseline in oracle database 12c
Manage automatic workload repository (awr) settings in oracle database 12c
Set the statistics_level parameter for a database in oracle database 12c
Use the automatic database diagnostic monitor in enterprise manager in oracle database 12c -
Describe the advisory framework in oracle database 12c
Access the advisor central page in enterprise manager and identify the packages used to invoke advisors in oracle database 12c
Describe and view the automated database maintenance tasks in oracle database 12c
Describe server-generated alerts and set metric thresholds for them in oracle database 12c
Recognize different alert types and clear alerts in oracle database 12c
IN THIS COURSE
-
1. Introduction to Database Maintenance5m 11sAfter completing this video, you will be able to describe database maintenance tasks and view alert history in Oracle Database 12c. FREE ACCESS
-
2. The Automatic Workload Repository5m 20sUpon completion of this video, you will be able to describe the Automatic Workload Repository (AWR) and its infrastructure in Oracle Database 12c. FREE ACCESS
-
3. Creating an AWR Baseline2m 38sIn this video, you will learn how to create an Automatic Workload Repository (AWR) baseline in Oracle Database 12c. FREE ACCESS
-
4. Managing AWR3m 11sIn this video, you will manage Automatic Workload Repository (AWR) settings in Oracle Database 12c. FREE ACCESS
-
5. Setting a Statistics Level2m 16sLearn how to set the STATISTICS_LEVEL parameter for a database in Oracle Database 12c. FREE ACCESS
-
6. Using the ADDM3m 13sLearn how to use the Automatic Database Diagnostic Monitor in Oracle Database 12c Enterprise Manager. FREE ACCESS
-
7. The Advisory Framework5m 33sUpon completion of this video, you will be able to describe the Advisory Framework in Oracle Database 12c. FREE ACCESS
-
8. Accessing Advisors2m 53sLearn how to access the Advisor Central page in Enterprise Manager and identify the packages used to invoke advisors in Oracle Database 12c. FREE ACCESS
-
9. Automated Maintenance Tasks3m 39sUpon completion of this video, you will be able to describe and view the automated database maintenance tasks in Oracle Database 12c. FREE ACCESS
-
10. Configuring Server-Generated Alerts4mAfter completing this video, you will be able to describe server-generated alerts and set metric thresholds for them in Oracle Database 12c. FREE ACCESS
-
11. Recognizing and Clearing Alerts2m 16sAfter completing this video, you will be able to recognize different alert types and clear alerts in Oracle Database 12c. FREE ACCESS
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.
