Oracle SQL Statement Tuning
- Recommended Duration:
- 2 Days
- Version
- Oracle 10g. Course covers Oracle9i and Oracle8i, it is also useful for shops using Oracle8 or Oracle 7. (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.
- Major Topics
-
- Oracle RDBMS concepts and data storage
- Advanced SQL usage
- Complex SELECT statements (subqueries, joins, and outer joins)
- 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.