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 databaseuse the Enterprise Manager Cluster Database Performance Page to view problems inside and outside the databaseuse the Enterprise Manager Cluster Database Performance Page to view database throughput and drill down to view throughput for specific instancesuse the Oracle Enterprise Manager cloud control cluster cache coherency page to view statistics relating to global cache throughputuse additional monitoring links in Enterprise Manager to view database locks and to access the top activity page for the databaseuse EM Database Express Performance Hub to view both historical and real-time performance data
-
describe how AWR manages snapshots in RACidentify RAC specific sections in an AWR reportdiagnose performance problems with the RAC specific sections of the Active Session History Reportuse the Automatic Database Diagnostic Monitor to analyze performance for the entire cluster or for individual instanceslist what ADDM diagnoses for RAC and use ADDM specific pages in Enterprise Manager to diagnose RAC database performanceuse Enterprise Manager to view database performance and find RAC-specific information in an AWR report
IN THIS COURSE
-
1.Enterprise Manager Monitoring Overview3m 40s
-
2.Cluster Database Performance Page4m 26s
-
3.Cluster Database Performance Page Throughput3m 26s
-
4.Accessing the Cluster Cache Coherency Page3m 48s
-
5.Additional Monitoring Links2m 55s
-
6.EM Database Express Performance Hub3m 24s
-
7.AWR Snapshots and RAC3m 26s
-
8.AWR Reports and RAC5m 3s
-
9.Active Session History Reports for RAC3m 53s
-
10.Automatic Database Diagnostic Monitor for RAC4m 13s
-
11.ADDM-specific RAC Diagnostics4m 11s
-
12.Exercise: Diagnose Database Performance with EM5m 53s
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.