Using Oracle Sql Stored Outlines & Optimizer Plan Stability by Mike Ault

By Mike Ault

Show description

Read or Download Using Oracle Sql Stored Outlines & Optimizer Plan Stability (Oracle In-Focus Series) PDF

Best databases books

Teradata RDBMS SQL/Data Dictionary Quick Reference

This publication is a brief reference for the SQL dialect supported via the Teradata Relational Database administration approach. The publication can also be a brief connection with the supported information description words for the Teradata RDBMS and the knowledge Dictionary. The viewers for this speedy reference is all clients of Teradata SQL who want quickly, non-detailed information regarding find out how to constitution a SQL assertion.

Access Forms & Reports For Dummies

Create queries that make types and studies worthwhile improve types to entry the knowledge you would like and make reviews that make experience! in the event you inspiration you needed to use a spreadsheet application to supply reviews and kinds, wager what! entry can end up great-looking types and stories that truly convey what is going on along with your information -- in case you understand how to invite it properly.

Extra resources for Using Oracle Sql Stored Outlines & Optimizer Plan Stability (Oracle In-Focus Series)

Sample text

2. g. ol$hints(ol_name, hint#) PAGE 25 COPYRIGHT © 2003 RAMPANT TECHPRESS. ALL RIGHTS RESERVED. ROBO BOOKS MONOGRAPH STABILIZING EXECUTION PLANS IN ORACLE / 3. OL$HINTS from the test database, selecting the appropriate category for the required application with the new 8i QUERY export parameter. 4. In the production database, it is recommended to store all stored outlines in a separate tablespace. If this is not set yet, create a new tablespace, and set this tablespace as the default one for the OUTLN schema user.

The outlines for all categories are inserted in the OL$ and OL$HINTS tables owned by OUTLN schema. 2. g. ol$hints(ol_name, hint#) PAGE 25 COPYRIGHT © 2003 RAMPANT TECHPRESS. ALL RIGHTS RESERVED. ROBO BOOKS MONOGRAPH STABILIZING EXECUTION PLANS IN ORACLE / 3. OL$HINTS from the test database, selecting the appropriate category for the required application with the new 8i QUERY export parameter. 4. In the production database, it is recommended to store all stored outlines in a separate tablespace.

Drop the OL$ and OL$HINTS tables so that the import recreates them in the appropriate tablespace. 5. OL$HINTS tables and/or rows only depending on the status of the previous step in the production database. Example Using the QUERY option in export you can select distinct categories of outlines from the test database. ol$hints; CATEGORY -----------------------------COURSE COURSE COURSE COURSE TRAIN TRAIN OL_NAME -----------------------------SYS_OUTLINE_0003140951400000 SYS_OUTLINE_0003140952040001 SYS_OUTLINE_0003140953500002 SYS_OUTLINE_0003140955480003 CO_CL_JOIN DEPT_LOC For this example, the category of outlines for the application is TRAIN.

Download PDF sample

Rated 4.11 of 5 – based on 6 votes