Oracle® 11g: Performance Tuning of SQL Expressions

The course describes the methodology that can be used for solving various performance problems related to Oracle® SQL – more specifically the 11g version.
Code: DB-002
Duration: 32 hours

Description

The course describes the methodology that can be used for solving various performance problems related to Oracle SQL – more specifically the 11g version.

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

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


Register for the next course
+
Registering in advance ensures you have priority. We’ll notify you when we schedule the next course on this topic
Bucharest €500
Krakow €500
Wroclaw €500

Invoices for the course will be issued in local currency. All fees above can change according to training location and delivery mode and are subject to change while scheduling. For individual participants the price is as displayed. For legal entities VAT is added to the displayed price.

Courses you may be interested in:

Recommended Reading:

Sign up

First Name*
Last Name*
Company
Email*
Preferred Location
Phone
Your Comment
Luxoft Warsaw - Warsaw Spire, plac Europejski 1, 00-844 Warszawa
Dimitrie Pompeiu nr 5-7 , building C, Et. 5, sect 2, Bucharest, 014459

Contact phone:

021 371 4858
Luxoft Poland Wroclaw - Silver Tower pl. Konstytucji 3-go Maja 3 50-048 Wroclaw
Aleja Generała Tadeusza Bora-Komorowskiego 25, Quattro Business Park Five, 31-476 Kraków, Poland

Contact phone:

+48 122110650
Success
Thank you.
Your request has been received.