RAC Monitoring

Oracle 12c    |    Intermediate
  • 12 videos | 48m 17s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 5 users Rating 4.6 of 5 users (5)
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
    In this video, you will learn how to use Enterprise Manager to get an overview of the performance statistics for your database. FREE ACCESS
  • Locked
    2.  Cluster Database Performance Page
    4m 26s
    In 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
  • Locked
    3.  Cluster Database Performance Page Throughput
    3m 26s
    During 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
  • Locked
    4.  Accessing the Cluster Cache Coherency Page
    3m 48s
    Find out how to use the Oracle Enterprise Manager cloud control cluster cache coherency page to view statistics relating to global cache throughput. FREE ACCESS
  • Locked
    5.  Additional Monitoring Links
    2m 55s
    Find 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
  • Locked
    6.  EM Database Express Performance Hub
    3m 24s
    In 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
  • Locked
    7.  AWR Snapshots and RAC
    3m 26s
    Upon completion of this video, you will be able to describe how AWR manages snapshots in a RAC environment. FREE ACCESS
  • Locked
    8.  AWR Reports and RAC
    5m 3s
    In this video, learn how to identify RAC-specific sections in an AWR report. FREE ACCESS
  • Locked
    9.  Active Session History Reports for RAC
    3m 53s
    During this video, you will learn how to diagnose performance problems by using the RAC specific sections of the Active Session History Report. FREE ACCESS
  • Locked
    10.  Automatic Database Diagnostic Monitor for RAC
    4m 13s
    In 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
  • Locked
    11.  ADDM-specific RAC Diagnostics
    4m 11s
    Upon 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
  • Locked
    12.  Exercise: Diagnose Database Performance with EM
    5m 53s
    Learn 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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.4 of 34 users Rating 4.4 of 34 users (34)
Rating 4.8 of 9 users Rating 4.8 of 9 users (9)
Course SQL Tuning
Rating 3.7 of 18 users Rating 3.7 of 18 users (18)