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
DBA_OUTLINES USER_OUTLINES DBA_OUTLINE_HINTS USER_OUTLINE_HINTS
© Copyright SS64.com 1999-2013
Some rights reserved