Metrics & Monitoring

Oracle 12c    |    Intermediate
  • 18 videos | 47m 29s
  • Includes Assessment
  • Earns a Badge
Rating 4.3 of 13 users Rating 4.3 of 13 users (13)
Metrics are used for system health monitoring, problem detection, and self tuning in Oracle Database 12c. Explore how to establish and manage performance baselines and work with real-time SQL monitoring.

WHAT YOU WILL LEARN

  • Describe the use of metrics and the importance of statistics within an oracle database
    Define the oracle database metrics and describe their benefits
    Use dictionary views and em cloud control to report on database metrics
    Describe the benefits of having statistics histograms
    Define database alerts and the dictionary views associated with them
    Describe how awr baselines can be used to compare two periods
    Define awr baselines and its benefits
    List and describe the types of awr baselines
    Describe how to create awr baselines
  • Configure awr baselines and templates
    Describe how baselines are used when defining alert thresholds
    Describe database operations and provide use cases
    List the scope and concepts around database operations
    Describe how to identify and enable monitoring of a database operation
    List the steps in identifying, starting, and completing a database operation
    Describe the concept of load database operations and list the dictionary views  associated with it
    Describe the pl/sql package needed to report on database operations
    Use em cloud control to create baselines and configure alert thresholds upon them

IN THIS COURSE

  • Locked
    1.  Metrics and Statistics
    2m 37s
    After completing this video, you will be able to describe the use of metrics and the importance of statistics within an Oracle database. FREE ACCESS
  • Locked
    2.  Oracle Database Metrics
    2m 12s
    In this video, you will learn how to define Oracle database metrics and describe their benefits. FREE ACCESS
  • Locked
    3.  Viewing Metric Information
    1m 57s
    In this video, find out how to use dictionary views and EM cloud control to report on database metrics. FREE ACCESS
  • Locked
    4.  Statistic Histograms
    2m 46s
    After completing this video, you will be able to describe the benefits of having histograms of statistics. FREE ACCESS
  • Locked
    5.  Database Alerts
    2m 47s
    In this video, you will learn how to define database alerts and the dictionary views associated with them. FREE ACCESS
  • Locked
    6.  Comparative Performance Analysis with AWR Baselines
    1m 49s
    Upon completion of this video, you will be able to describe how AWR baselines can be used to compare two periods of time. FREE ACCESS
  • Locked
    7.  AWR Baselines
    2m 31s
    In this video, find out how to define AWR baselines and the benefits of doing so. FREE ACCESS
  • Locked
    8.  Types of Baselines
    3m 26s
    Upon completion of this video, you will be able to list and describe the types of AWR baselines. FREE ACCESS
  • Locked
    9.  Creating AWR Baselines
    2m 31s
    After completing this video, you will be able to describe how to create AWR baselines. FREE ACCESS
  • Locked
    10.  Managing Baselines and Templates
    3m 34s
    During this video, you will learn how to configure AWR baselines and templates. FREE ACCESS
  • Locked
    11.  Performance Monitoring and Baselines
    3m 8s
    After completing this video, you will be able to describe how baselines are used to define alert thresholds. FREE ACCESS
  • Locked
    12.  Real-Time Database Operation Monitoring
    2m 35s
    Upon completion of this video, you will be able to describe database operations and provide examples of when to use them. FREE ACCESS
  • Locked
    13.  Database Operation Concepts
    1m 34s
    After completing this video, you will be able to list the scope and concepts around database operations. FREE ACCESS
  • Locked
    14.  Identifying a Database Operation
    2m 11s
    Upon completion of this video, you will be able to describe how to identify and enable monitoring of a database operation. FREE ACCESS
  • Locked
    15.  Workflow of a Database Operation
    2m 20s
    After completing this video, you will be able to list the steps in identifying, starting, and completing a database operation. FREE ACCESS
  • Locked
    16.  Monitoring Load Database Operations
    2m 27s
    Upon completion of this video, you will be able to describe the concept of load database operations and list the dictionary views associated with it. FREE ACCESS
  • Locked
    17.  Database Operations Reporting and Tuning
    2m 54s
    Upon completion of this video, you will be able to describe the PL/SQL package needed to report on database operations. FREE ACCESS
  • Locked
    18.  Exercise: Creating Baselines
    4m 12s
    During this video, you will learn how to use EM cloud control to create baselines and configure alert thresholds. 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.

YOU MIGHT ALSO LIKE

Channel Performance Management & Measurement
Book SQL Server 2022 Query Performance Tuning: Troubleshoot and Optimize Query Performance, 6th Edition
Book Practical Database Auditing for Microsoft SQL Server and Azure SQL: Troubleshooting, Regulatory Compliance, and Governance

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Backup Strategies
Rating 4.7 of 30 users Rating 4.7 of 30 users (30)
Course User Security Features & Configuration
Rating 4.2 of 24 users Rating 4.2 of 24 users (24)
Course Performance Tuning
Rating 4.5 of 32 users Rating 4.5 of 32 users (32)