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 12c
tune the performance of a database instance in Oracle Database 12c
use EM Database Express and EM Cloud Control to monitor database performance in Oracle Database 12c
monitor session performance in Oracle Database 12c
monitor top services in Oracle Database 12c
describe and view wait events in Oracle Database 12c
use the data dictionary views to diagnose and tune performance problems in Oracle Database 12c
identify guidelines for memory management in Oracle Database 12c -
describe Automatic Memory Management (AMM) and related memory parameters in Oracle Database 12c
enable and monitor Automatic Memory Management (AMM) in Oracle Database 12c
describe Automatic Shared Memory Management (ASSM) in Oracle Database 12c
describe and enable Automatic Segment Space Management (ASSM) in Oracle Database 12c
describe values for autotuned SGA parameters in Oracle Database 12c
describe the program global area (PGA) and the dynamic performance statistics available in the Oracle Database 12c
configure 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.
