Databases Reference
In-Depth Information
Procedures
The most relevant procedures are:
F
CLEAR_USED
: clears the outline "used" flag
F
DROP_BY_CAT
: drops outlines which belong to a specific category
F
UPDATE_BY_CAT
: updates the category of outlines to a new category
F
DROP_UNUSED
: drops outlines never applied in the compilation of a SQL statement
DBMS_OUTLN_EDIT
This package contains the functional interface to manage stored outlines.
The public role has execute privileges on
DBMS_OUTLN_EDIT
, which is defined with
invoker's rights.
Procedures
The most relevant procedures are:
F
CREATE_EDIT_TABLES
: creates outline editing tables in calling a user's schema;
beginning from Oracle 10
g
, you will not need to use this procedure because the
outline editing tables are part—as temporary tables—of the
SYSTEM
schema
F
REFRESH_PRIVATE_OUTLINE
: refreshes the in-memory copy of the outline,
synchronizing its data with the edits made to the outline hints
F
DROP_EDIT_TABLES
: drops the outline editing tables from the calling user's schema
DBMS_SHARED_POOL
This package allows access to information about sizes of the objects stored in the shared
pool and marks them for keeping or not-keeping.
Procedures
The most relevant procedures are:
F
KEEP
: keeps an object in the shared pool, so it isn't subject to aging
F
UNKEEP
: unkeeps an object from the shared pool
F
PURGE
: purges the object
F
SIZES
: shows objects in the shared pool larger than the specified size