RAC Monitoring

Oracle 12c    |    Intermediate
  • 12 Videos | 52m 47s
  • Includes Assessment
  • Earns a Badge
Likes 8 Likes 8
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

  • Locked
    1. 
    Enterprise Manager Monitoring Overview
    3m 40s
  • Locked
    2. 
    Cluster Database Performance Page
    4m 26s
  • Locked
    3. 
    Cluster Database Performance Page Throughput
    3m 26s
  • Locked
    4. 
    Accessing the Cluster Cache Coherency Page
    3m 48s
  • Locked
    5. 
    Additional Monitoring Links
    2m 55s
  • Locked
    6. 
    EM Database Express Performance Hub
    3m 24s
  • Locked
    7. 
    AWR Snapshots and RAC
    3m 26s
  • Locked
    8. 
    AWR Reports and RAC
    5m 3s
  • Locked
    9. 
    Active Session History Reports for RAC
    3m 53s
  • Locked
    10. 
    Automatic Database Diagnostic Monitor for RAC
    4m 13s
  • Locked
    11. 
    ADDM-specific RAC Diagnostics
    4m 11s
  • Locked
    12. 
    Exercise: Diagnose Database Performance with EM
    5m 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.

YOU MIGHT ALSO LIKE

CHANNEL PostgreSQL
Likes 40 Likes 40  
Likes 1 Likes 1  
Likes 29 Likes 29