Performance Tuning
Oracle 12c
| Intermediate
- 15 Videos | 1h 5m 24s
- Earns a Badge
Performance tuning is an important aspect of Oracle Database 12c administration. Learn how to monitor and tune both database and memory performance in Oracle Database 12c.
WHAT YOU WILL LEARN
-
plan, monitor, and tune performance in Oracle Database 12ctune the performance of a database instance in Oracle Database 12cuse EM Database Express and EM Cloud Control to monitor database performance in Oracle Database 12cmonitor session performance in Oracle Database 12cmonitor top services in Oracle Database 12cdescribe and view wait events in Oracle Database 12cuse the data dictionary views to diagnose and tune performance problems in Oracle Database 12cidentify guidelines for memory management in Oracle Database 12c
-
describe Automatic Memory Management (AMM) and related memory parameters in Oracle Database 12cenable and monitor Automatic Memory Management (AMM) in Oracle Database 12cdescribe Automatic Shared Memory Management (ASSM) in Oracle Database 12cdescribe and enable Automatic Segment Space Management (ASSM) in Oracle Database 12cdescribe values for autotuned SGA parameters in Oracle Database 12cdescribe the program global area (PGA) and the dynamic performance statistics available in the Oracle Database 12cconfigure AWR retention parameters, generate an AWR report, review server-generated alerts, and enable Automatic Memory Management (AMM) in Oracle Database 12c
IN THIS COURSE
-
1.Performance Monitoring and Tuning5m 18s
-
2.Instance Performance Tuning5m 14s
-
3.Using Enterprise Manager to Manage Performance3m 53s
-
4.Monitoring Session Performance4m 44s
-
5.Monitoring Top Services2m 34s
-
6.Viewing Wait Events3m 4s
-
7.Using Views to Tune Performance2m 15s
-
8.Memory Management Guidelines6m 41s
-
9.Automatic Memory Management3m 55s
-
10.Enabling and Monitoring AMM4m 41s
-
11.Automatic Shared Memory Management3m 3s
-
12.Enabling ASSM7m 4s
-
13.Autotuned SGA Parameters1m 54s
-
14.Managing the Program Global Area6m 8s
-
15.Exercise: Perform Database Maintenance4m 57s
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.