Oracle® 11g: Performance Tuning of SQL Expressions
Duration
32
hours
Location
Online
Language
English
Code
DB-002
Training for 7-8 or more people?
Customize trainings
for your specific needs
Description
The course describes the methodology that can be used for solving various performance problems related to Oracle SQL – more specifically the 11g version.
After completing the course, a certificate
is issued on the Luxoft Training form
is issued on the Luxoft Training form
Objectives
- Understand the stages of executing SQL expressions
- How to retrieve statistical data on execution of SQL expressions
- Solving performance problems by adjusting SQL expressions
Target Audience
- Database administrators
- System administrators
- Application developers
- Software Testers
Roadmap
- 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