Получить консультацию
Training Center MUKКурсыOracleDatabaseOracle Database 19c: Performance Management and Tuning

Oracle Database 19c: Performance Management and Tuning

Код курса
19cDB-PMT
Продолжительность
5 Дней, 40 Ак. Часов
Описание курса
Цели
Требования
Программа курса
Описание курса

Course overview

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.

Цели

Course Objectives

  • 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
Требования

Prerequisites

  • Knowledge of SQL and PL/SQL (for DBA use)
  • Linux skills, including familiarity with command-line options such as ls, cd, cp, and su

Audience:

  • Database Administrator
  • Technical support
Программа курса

Course Outline

  • Defining the Scope of Performance Issues
  • Using the Time Model to Diagnose Performance Issues
  • Using Statistics and Wait Events to Diagnose Performance Issues
  • Using Log and Trace Files to Monitor Performance
  • Using Enterprise Manager Cloud Control and SQL Developer to Monitor Performance
  • Using Statspack to View Performance Data
  • Using Automatic Workload Repository
  • Using Metrics and Alerts
  • Using Baselines
  • Managing Automated Maintenance Tasks
  • Using ADDM to Analyze Performance
  • Using Active Session History Data for First Fault System Analysis
  • Using Emergency Monitoring and Real-Time ADDM to Analyze Performance Issues
  • Overview of SQL Statement Processing
  • Maintaining Indexes
  • Maintaining Tables
  • Introduction to Query Optimizer
  • Understanding Execution Plans
  • Viewing Execution Plans by Using SQL Trace and TKPROF
  • Managing Optimizer Statistics
  • Using Automatic SQL Tuning
  • Using the SQL Plan Management Feature
  • Using the SQL Tuning Advisor
  • Using the SQL Access Advisor
  • Overview of Real Application Testing Components
  • Using SQL Performance Analyzer to Determine the Impact of Changes
  • Using Database Replay to Test System Performance
  • Implementing Real-Time Database Operation Monitoring
  • Using Services to Monitor Applications
  • Overview of Memory Structures
  • Managing Shared Pool Performance
  • Managing Buffer Cache Performance
  • Managing PGA and Temporary Space Performance
  • Configuring the Large Pool
  • Using Automatic Shared Memory Management
  • Configuring the In-Memory Column Store Feature
  • Using the In-Memory Column Store Feature to Improve SQL Performance
  • Using In-Memory Column Store with Oracle Database Features

 

Регистрация на ближайший курс
Oracle Database 19c: Performance Management and Tuning
Код курса:
19cDB-PMT
Продолжительность:
5 Дней, 40 Ак. Часов
Зарегистрироваться
Получить консультацию
Свяжитесь со мной
Получить консультацию
Отправить заявку
Регистрация на вебинар
Отправить заявку
Ваша заявка получена!
Мы свяжемся с вами в ближайшее время.