Written by one the world's most widely-read Oracle script developers and author of 14 best-selling Oracle books, Mike Ault targets his substantial knowledge of Oracle tuning in this concise eBook. With decades of experience using Oracle, Mike Ault shares secrets for Oracle stored outlines and SQL optimizer plan stability.

* Install OUTLN Schema “After the Fact”. * Create an OUTLINE object. * Use DML and Packages to Edit Outlines. * Replace a Non-Hinted Outline.

About the Author:

Mike Ault

Mike Ault has five Oracle Masters Certificates.  Ault was the first popular Oracle author with his book "Oracle7 Administration and Management" and he also wrote several of the "Exam Cram" books.

Table of Contents:

 

Setting Up for Use of Outlines Installing OUTLN Schema “After the Fact” Script to Install OUTLN Schema General Facts about OUTLN Schema Requirements for OUTLINE Use Some General Usage Notes: Views Used With OUTLINES Packages Used with OUTLINEs Plan Stability Creation of a OUTLINE object Altering a OUTLINE Dropping an OUTLINE Use of the OUTLN_PKG To Manage SQL Stored Outlines DROP_UNUSED DROP_BY_CAT UPDATE_BY_CAT

New Procedures for Oracle9i Manually Editing Plans Using DML and Packages to Edit Outlines A Detailed Example Using DBMS_OUTLN_EDIT.GENERATE_SIGNATURE Replacing a Non-Hinted Outline Technique Example Moving OUTLINES from One DB to Another Scenario Technique Example