Metrics & Monitoring

Oracle 12c    |    Intermediate
  • 18 Videos | 47m 29s
  • 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

CHANNEL Measuring & Managing Performance
Likes 167 Likes 167  
CHANNEL Wintellect SQL Server
Likes 1 Likes 1  
CHANNEL Oracle Database 12c Administrator Certified Professional
Likes 50 Likes 50  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Automatic Workload Repository
Likes 5 Likes 5  
COURSE SQL Tuning
Likes 20 Likes 20  
COURSE Backup & Recovery Options
Likes 31 Likes 31