Oracle Consulting Oracle Training Oracle Support Development
Home
Catalog
Oracle Books
SQL Server Books
IT Books
Job Interview Books
eBooks
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
 Phone
 800-766-1884
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books
image
image

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

Privacy Policy

  

 

  Using Oracle SQL Stored Outlines & Optimizer Plan Stability

Mike Ault
ISBN:
0-9740716-8-4
27 Pages

Only $7.95

 

 


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.

 
Key Features

* 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

 

 

 

 

 

   

 Copyright © 1996 -2016 by Burleson. All rights reserved.


Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks