Metrics & Monitoring
Oracle 12c
| Intermediate
- 18 Videos | 55m 59s
- Includes Assessment
- Earns a Badge
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
-
1.Metrics and Statistics2m 37s
-
2.Oracle Database Metrics2m 12s
-
3.Viewing Metric Information1m 57s
-
4.Statistic Histograms2m 46s
-
5.Database Alerts2m 47s
-
6.Comparative Performance Analysis with AWR Baselines1m 49s
-
7.AWR Baselines2m 31s
-
8.Types of Baselines3m 26s
-
9.Creating AWR Baselines2m 31s
-
10.Managing Baselines and Templates3m 34s
-
11.Performance Monitoring and Baselines3m 8s
-
12.Real-Time Database Operation Monitoring2m 35s
-
13.Database Operation Concepts1m 34s
-
14.Identifying a Database Operation2m 11s
-
15.Workflow of a Database Operation2m 20s
-
16.Monitoring Load Database Operations2m 27s
-
17.Database Operations Reporting and Tuning2m 54s
-
18.Exercise: Creating Baselines4m 12s
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.
