Schedule today!

Call Peggy at
  (800) 252-0652


Contact Us

More Oracle

Related Courses

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.