Опис курсу
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.
Аудиторія
- Database Administrator
- Technical support
Попередні вимоги
- Knowledge of SQL and PL/SQL (for DBA use)
- Linux skills, including familiarity with command-line options such as ls, cd, cp, and su
Цілі курсу
- 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