Oracle8i Supplied PL/SQL Packages Reference Release 2 (8.1.6) Part Number A76936-01 |
|
The OUTLN_PKG
package 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 recreate 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.
OUTLN_PKG
contains management procedures that should only be made available to appropriate users. 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).
|
![]() Copyright © 1996-2000, Oracle Corporation. All Rights Reserved. |
|