Metrics & Monitoring

Oracle 12c    |    Intermediate
  • 18 Videos | 55m 59s
  • Includes Assessment
  • Earns a Badge
Likes 16 Likes 16
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

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 10 Likes 10  
Likes 24 Likes 24  
Likes 103 Likes 103  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 33 Likes 33  
Likes 14 Likes 14