Oracle Database 11g R2: SQL Tuning

  • 4h 24m
  • Sideris Courseware Corporation
  • Sideris
  • 2011

This learning guide will equip database administrators and application developers to build efficient SQL statements and to tune database applications. When this effort is complemented by database server and PL/SQL application tuning, then a highly efficient application execution environment is created. One will learn about the internals of SQL statement execution, how to monitor the performance of such execution, and how one can influence the behavior of the database to achieve performance gains. This textbook is a mandatory reference for any database administrator or SQL database application developer.

In this Book

  • Introduction
  • Workshop Setup Guide
  • Tuning & the Oracle Database Advisory Framework
  • Tuning & the Oracle Database Advisory Framework
  • Viewing & Monitoring the Execution Plan
  • Viewing & Monitoring the Execution Plan
  • Understanding the Optimizer
  • Understanding the Optimizer
  • Execution Plan Methods & Operations
  • Execution Plan Methods & Operations
  • Managing Optimizer Statistics
  • Managing Optimizer Statistics
  • Enhanced Optimizer Statistics
  • Enhanced Optimizer Statistics
  • Histograms & Extended Statistics
  • Histograms & MultiColumn Statistics
  • Application Tracing
  • Application Tracing
  • ADDM & the SQL Tuning Advisor
  • ADDM & the SQL Tuning Advisor
  • The SQL Access Advisor
  • The SQL Access Advisor
  • Plan Management
  • Plan Management
  • Managing Cursor Sharing
  • Optimizer Hints
  • Optimizer Hints
SHOW MORE
FREE ACCESS