RAC Monitoring
Oracle 12c
| Intermediate
- 12 videos | 48m 17s
- Includes Assessment
- Earns a Badge
A main concern for any database administrator is that a database is performing optimally. Explore RAC monitoring and tuning techniques using Enterprise Manager Cloud Control and database tools like AWR, ASH, and ADDM.
WHAT YOU WILL LEARN
-
use Enterprise Manager to get an overview of the performance statistics for the database
use the Enterprise Manager Cluster Database Performance Page to view problems inside and outside the database
use the Enterprise Manager Cluster Database Performance Page to view database throughput and drill down to view throughput for specific instances
use the Oracle Enterprise Manager cloud control cluster cache coherency page to view statistics relating to global cache throughput
use additional monitoring links in Enterprise Manager to view database locks and to access the top activity page for the database
use EM Database Express Performance Hub to view both historical and real-time performance data -
describe how AWR manages snapshots in RAC
identify RAC specific sections in an AWR report
diagnose performance problems with the RAC specific sections of the Active Session History Report
use the Automatic Database Diagnostic Monitor to analyze performance for the entire cluster or for individual instances
list what ADDM diagnoses for RAC and use ADDM specific pages in Enterprise Manager to diagnose RAC database performance
use Enterprise Manager to view database performance and find RAC-specific information in an AWR report
IN THIS COURSE
-
1. Enterprise Manager Monitoring Overview3m 40sIn this video, you will learn how to use Enterprise Manager to get an overview of the performance statistics for your database. FREE ACCESS
-
2. Cluster Database Performance Page4m 26sIn this video, find out how to use the Enterprise Manager Cluster Database Performance Page to view problems inside and outside of the database. FREE ACCESS
-
3. Cluster Database Performance Page Throughput3m 26sDuring this video, you will learn how to use the Enterprise Manager Cluster Database Performance Page to view database throughput and drill down to view throughput for specific instances. FREE ACCESS
-
4. Accessing the Cluster Cache Coherency Page3m 48sFind out how to use the Oracle Enterprise Manager cloud control cluster cache coherency page to view statistics relating to global cache throughput. FREE ACCESS
-
5. Additional Monitoring Links2m 55sFind out how to use additional monitoring links in Enterprise Manager to view database locks and to access the top activity page for the database. FREE ACCESS
-
6. EM Database Express Performance Hub3m 24sIn this video, you will learn how to use the EM Database Express Performance Hub to view both historical and real-time performance data. FREE ACCESS
-
7. AWR Snapshots and RAC3m 26sUpon completion of this video, you will be able to describe how AWR manages snapshots in a RAC environment. FREE ACCESS
-
8. AWR Reports and RAC5m 3sIn this video, learn how to identify RAC-specific sections in an AWR report. FREE ACCESS
-
9. Active Session History Reports for RAC3m 53sDuring this video, you will learn how to diagnose performance problems by using the RAC specific sections of the Active Session History Report. FREE ACCESS
-
10. Automatic Database Diagnostic Monitor for RAC4m 13sIn this video, find out how to use the Automatic Database Diagnostic Monitor to analyze performance for the entire cluster or for individual instances. FREE ACCESS
-
11. ADDM-specific RAC Diagnostics4m 11sUpon completion of this video, you will be able to list what ADDM diagnoses for RAC and use ADDM specific pages in Enterprise Manager to diagnose RAC database performance. FREE ACCESS
-
12. Exercise: Diagnose Database Performance with EM5m 53sLearn how to use Enterprise Manager to view database performance and find RAC-specific information in an AWR report. 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.
