Oracle Database 19c: Performance Management and Tuning
Oracle Database 19c: Performance Management and Tuning
Durată: 5 zile
Certificare: Oracle Database 19c Perf Mgmt & Tuning Professional
Cui îi este dedicat cursul?
Database Administrator
Cunoștințe și abilități inițiale
-
Prezentarea cursului
Students learn how to use Oracle Database automatic tuning features such as SQL Tuning Advisor, SQL Access Advisor, Automatic Workload Repository and Automatic Database Diagnostic Monitor, and practice these tuning methods. The course focuses on the tuning tasks expected of a DBA: reactive tuning of SQL statements, maintaining SQL statement and operation performance, and tuning the Oracle Database Instance components.
Ce subiecte abordează cursul
Describe Performance Management
Use AWR Performance Statistics
Use AWR Based Tools
Improve SQL Statement Performance
Influence the Optimizer
Use Tuning Analyzers and Advisors
Monitor Operations and applications
Manage Memory
Manage Database Memory
Use In-Memory Column Store Feature
Ce abilități se dobândesc în urmă cursului
- -
You can earn certification Oracle Database 19c Perf Mgmt & Tuning Professional after completion of following courses:
and pass the certification exams:
- 1Z0-084 - Oracle Database 19c: Performance Management and Tuning