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:
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
Creation of a OUTLINE object
Altering a OUTLINE
Dropping an OUTLINE
Use of the OUTLN_PKG To Manage SQL Stored Outlines
New Procedures for Oracle9i
Manually Editing Plans
Using DML and Packages to Edit Outlines
A Detailed Example
Replacing a Non-Hinted Outline
Moving OUTLINES from One DB to