|Oracle9i Supplied PL/SQL Packages and Types Reference
Release 2 (9.2)
Part Number A96612-01
DBMS_OUTLN package, synonymous with
OUTLN_PKG, contains the functional interface for subprograms associated with the management of stored outlines.
A stored outline is the stored data that pertains to an execution plan for a given SQL statement. It enables the optimizer to repeatedly re-create execution plans that are equivalent to the plan originally generated along with the outline.The data stored in an outline consists, in part, of a set of hints that are used to achieve plan stability.
This chapter discusses the following topics:
DBMS_OUTLN contains management procedures that should be available to appropriate users only.
EXECUTE privilege is not extended to the general user community unless the DBA explicitly does so.
PL/SQL functions that are available for outline management purposes can be executed only by users with
EXECUTE privilege on the procedure (or package).