DBMS_OUTLN
This package contains the functional interface to manage stored outlines.
To use this package the EXECUTE_CATALOG_ROLE
role is needed. There is also a public synonym OUTLN_PKG
.
Procedures
The most relevant procedures are:
CLEAR_USED
: clears the outline "used" flagDROP_BY_CAT
: drops outlines which belong to a specific categoryUPDATE_BY_CAT
: updates the category of outlines to a new categoryDROP_UNUSED
: drops outlines never applied in the compilation of a SQL statement
Get Oracle Database 11gR2 Performance Tuning Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.