Oracle 9i SQL Statement Tuning > Oracle 9i SQL Statement Tuning > Section 12: Using Plan Stability

Table of Contents

Download Safari Books Online apps: Apple iOS | Android

Entire Site

Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

This Book

Oracle 9i SQL Statement Tuning

Search

Table of Contents

Oracle 9i SQL Statement Tuning

Table of Contents

Section 1: Course Introduction

Section 2: Understanding The Tuning Issues

Section 3: SQL Statement Execution

Section 4: The EXPLAIN PLAN Utility

Section 5: The Cost Based Optimizer (CBO)

Section 6: Collecting Statistics

Section 7: Optimizer Operations

Section 8: Indexes & The Execution Plan

Section 9: Optimizer Hints

Section 10: Using TKPROF & AUTOTRACE

Section 11: Histograms

Section 12: Using Plan Stability

Objectives

About Plan Stability

Preparing For Stored Outlines

Creating & Using Stored Outlines

Data Dictionary Storage

Managing Stored Outlines

Workshop Section Using Plan Stability

Exercises

Solutions

Section 13: Editing Private Outlines

Section 14: Collecting System Statistics

Section 15: Exploiting & Managing Cursor Sharing

Optional Section 16: Understanding The Rule Based Optimizer

Optional Section 17: Tuning With The Rule Based Optimizer

Oracle SQL Statement Tuning Page 227 Section 12 Using Plan Stability O bjectives Learn About Plan Stability Prepare The Environment For Stored Outlines Learn To Create & Use Stored Outlines

Download Safari Books Online apps: Apple iOS | Android

This Book

Search

Contents

Oracle 9i SQL Statement Tuning > Section 12: Using Plan Stability - Pg. 227