Oracle SQL Statement Tuning
- Recommended Duration:
- 2 Days
- Version
- Oracle 11g and Oracle 10g
(earlier course versions available)
- Benefits
- Participants will improve SQL so that they may more efficiently satisfy user needs. The latest releases of Oracle products will be discussed. Hands-on exercises will allow participants to: practice complex SQL statements, learn how to use catalog tables, properly use indexes, be able to detect and improve many common performance problems.
- Audience
- Experienced users of Oracle and SQL needing to tune Oracle applications.
- Prerequisites
- Previous Oracle experience or education is essential to understanding the advanced topics presented in this class. Participants should be familiar with both SQL and SQL*Plus (or the locally-select tool).
- Major Topics
-
- Oracle RDBMS concepts and data storage
- Advanced SQL usage
- Complex SELECT statements (subqueries, joins, and outer joins)
- SQL Performance statements:
Merge, multi-table Insert, Returning, Materialized Views, WITH subquery, aggregation features, more…
- System catalog tables
- Indexing, proper use of indexes
- Optimizing SQL
- Hints
- SQL use of indexes
- EXPLAIN
- Trace
- Trace 10046 and Wait Events
- TKPROF
- AUTOTRACE
- PL/SQL
- Exercises
- There are six machine exercises.