Metrics & Monitoring
Oracle 12c
| Intermediate
- 18 Videos | 47m 29s
- 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 databasedefine the Oracle database metrics and describe their benefitsuse dictionary views and EM cloud control to report on database metricsdescribe the benefits of having statistics histogramsdefine database alerts and the dictionary views associated with themdescribe how AWR baselines can be used to compare two periodsdefine AWR baselines and its benefitslist and describe the types of AWR baselinesdescribe how to create AWR baselines
-
configure AWR baselines and templatesdescribe how baselines are used when defining alert thresholdsdescribe database operations and provide use caseslist the scope and concepts around database operationsdescribe how to identify and enable monitoring of a database operationlist the steps in identifying, starting, and completing a database operationdescribe the concept of load database operations and list the dictionary views associated with itdescribe the PL/SQL package needed to report on database operationsuse 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.YOU MIGHT ALSO LIKE
CHANNEL
Wintellect SQL Server
Likes 1