 |
|
Oracle Tips by Burleson |
Use of
the OUTLN_PKG To Manage SQL Stored Outlines
The OUTLN_PKG
package provides for the management of stored outlines. A stored
outline is an execution plan for a specific SQL statement. A stored
outline permits the optimizer to stabilize a SQL statement’s
execution plan giving repeatable execution plans even when data and
statistics change.
The DBA should
take care to whom they grant execute on the OUTLN_PKG, by default it
is not granted to the public user group nor is a public synonym
created.
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
