RAC Monitoring

Oracle 12c
  • 12 Videos | 48m 53s
  • Includes Assessment
  • Earns a Badge
Likes 1
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 43s
  • Locked
    2. 
    Cluster Database Performance Page
    4m 29s
  • Locked
    3. 
    Cluster Database Performance Page Throughput
    3m 29s
  • Locked
    4. 
    Accessing the Cluster Cache Coherency Page
    3m 51s
  • Locked
    5. 
    Additional Monitoring Links
    2m 58s
  • Locked
    6. 
    EM Database Express Performance Hub
    3m 27s
  • Locked
    7. 
    AWR Snapshots and RAC
    3m 29s
  • Locked
    8. 
    AWR Reports and RAC
    5m 6s
  • Locked
    9. 
    Active Session History Reports for RAC
    3m 56s
  • Locked
    10. 
    Automatic Database Diagnostic Monitor for RAC
    4m 16s
  • Locked
    11. 
    ADDM-specific RAC Diagnostics
    4m 14s
  • Locked
    12. 
    Exercise: Diagnose Database Performance with EM
    5m 56s

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

Likes  2
Likes  23