Oracle® 11g: Performance Tuning of SQL Expressions
Czas trwania
32
hours
Lokalizacja
Online
Język
English
Kod
DB-002
Szkolenie dla #uczestników# lub większej liczby osób?
Dostosuj treningi
dla Twoich konkretnych potrzeb
Opis
The course describes the methodology that can be used for solving various performance problems related to Oracle SQL – more specifically the 11g version.
Po ukończeniu kursu na formularzu Luxoft Training
wydawany jest certyfikat
wydawany jest certyfikat
Cele
- Understand the stages of executing SQL expressions
- How to retrieve statistical data on execution of SQL expressions
- Solving performance problems by adjusting SQL expressions
Grupa docelowa
- Database administrators
- System administrators
- Application developers
- Software Testers
Plan działania
- Tuning methodology
- Processing SQL expressions
- EXPLAIN and AUTOTRACE: tools used to monitor execution plan of SQL statement
- Performance diagnostics tools SQL*TRACE and TKPROF
- Rule-Based Optimization and Cost-Based Optimization
- Indexes and the main methods of data access
- Statistics collection for optimizer
- Operation modes of optimizer. Factors influencing optimizer’s work. Hints to optimizer
- Sorting and merging tables
- Query execution plan (Stored Outline)
- Extended indexing features (bitmap indexes and function-based indexes)
- Materialized views and temporary tables
- Alternative data storage (Index-organized tables and clustered indexes)
- New features of version 11g