PL/SQL Packages DBMS_OUTLN

Manage stored outlines. Synonymous with OUTLN_PKG

Subprocedures:

DROP_BY_CAT        Drop outlines that belong to a specified category. 

DROP_COLLISION     Drop an outline with an ol$.hintcount value that
                   does not match the number of hints for that outline in ol$hints. 

DROP_EXTRAS        Clean up after an import by dropping extra hint tuples
                   not accounted for by hintcount.  

DROP_UNREFD_HINTS  Drop hint tuples that have no corresponding outline in
                   the OL$ table. 

DROP_BY_CAT        Drop outlines that have never been applied in the
                   compilation of an SQL statement.  

UPDATE_BY_CAT      Change the category of an outline. 

GENERATE_SIGNATURE Generate a signature for the specified SQL text.  

For full documentation of the packaged procedures above see the Oracle Manual:
"Oracle9i Supplied PL/SQL Packages and Types Reference"

or the book Oracle Built in Packages by Steven Feuerstein et al
Related Commands:

Related Views:

 DBA_OUTLINES                              USER_OUTLINES 
 DBA_OUTLINE_HINTS                         USER_OUTLINE_HINTS 


© Copyright SS64.com 1999-2014
Some rights reserved