Oracle Database 11g: SQL Tuning Workshop (Self-Study Course)

 

Who should attend

  • Developers
  • Technical consultants

Course Objectives

  • Identify problem SQL statements
  • Modify a SQL statement to perform at its best
  • Trace an application
  • Understand how the Query Optimizer makes decisions about how to access data
  • Interpret execution plans
  • Use optimizer hints effectively
  • Generate a load test

Product Description

  • Architecture, SQL Tuning, and Optimization
    • Database Architecture and SQL Tuning
    • SQL Processing and the Optimizer
  • Indexes, Access Paths, and Join Operations
    • Table Scans, Indexes, Access Paths, and Joins
  • Execution Plans and Star Transformations
    • Interpreting Execution Plans
    • Understanding Star Transformation
  • Optimizer Statistics, Hints, and Cursor Sharing
    • Optimizer Statistics
    • Bind Variables, Cursor Sharing, and Optimizer Hints
  • Application Tracing and Automatic SQL Tuning
    • Application Tracing, Trace Files, and the tkprof Utility
    • Automatic SQL Tuning

Price on request

BUY NOW