Using Oracle SQL Stored Outlines and Optimizer Plan Stability 2003.pdf

Rampant TechPress

Using Oracle SQL Stored

Outlines & Optimizer Plan

Stability

Mike Ault

ROBO B OOKS M ONOGRAPH

S TABILIZING E XECUTION P LANS IN O RACLE

Notice

While the author & Rampant TechPress makes every effort to ensure the

information presented in this white paper is accurate and without error, Rampant

TechPress, its authors and its affiliates takes no responsibility for the use of the

information, tips, techniques or technologies contained in this white paper. The

user of this white paper is solely responsible for the consequences of the

utilization of the information, tips, techniques or technologies reported herein.

P AGE II

ROBO B OOKS M ONOGRAPH

S TABILIZING E XECUTION P LANS IN O RACLE

Using Oracle SQL Stored Outlines &

Optimizer Plan Stability

By Mike Ault

Published by Rampant TechPress, Kittrell, North Carolina, USA

Series Editor: Don Burleson

Production Editor: Teri Wade

Cover Design: Bryan Hoff

Oracle, Oracle7, Oracle8, Oracle8i, and Oracle9i are trademarks of Oracle

Corporation. Oracle In-Focus is a registered Trademark of Rampant TechPress.

Many of the designations used by computer vendors to distinguish their products

are claimed as Trademarks. All names known to Rampant TechPress to be

trademark names appear in this text as initial caps.

The information provided by the authors of this work is believed to be accurate

and reliable, but because of the possibility of human error by our authors and

staff, Rampant TechPress cannot guarantee the accuracy or completeness of

any information included in this work and is not responsible for any errors,

omissions, or inaccurate results obtained from the use of information or scripts in

this work.

Visit www.rampant.cc for information on other Oracle In-Focus books.

ISBN: 0-9740716-8-4

P AGE III