info@smashgaps.com +91.7391.042.951 020 2565 4714

Oracle Database 12c Sql Tuning

Oracle 11gR2 OCA Training and Placement - Best Job Oriented IT Training Institutes and certification courses
Category Name : Database
Time Limit : 20 hrs
Count : 2-6
Review

Intended Audience Data Warehouse Administrator, PL/SQL Developer, Data Warehouse Developer, Application Developers, Database Administrators, Developer, Support Engineer

Prerequisites This course is based on Oracle Database 11g Release 2.

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