Mview analysis and advisory functions, some of the procedures generate output tables.
Subprocedures:
ADD_FILTER_ITEM Filter the contents being used during the recommendation process.
CREATE_ID Generate an internal ID used by a new workload collection,
a new filter, or a new advisor run
ESTIMATE_MVIEW_SIZE
Estimate the size of an mview that you might create, in bytes
and rows.
EVALUATE_MVIEW_STRATEGY
Measure the utilization of each existing mview.
GENERATE_MVIEW_REPORT
Generate an HTML-based report on the given Advisor run
GENERATE_MVIEW_SCRIPT
Generate a simple script containing the SQL commands to
implement Summary Advisor recommendations
LOAD_WORKLOAD_CACHE
Obtain a SQL cache workload.
LOAD_WORKLOAD_TRACE
Load a workload collected by Oracle Trace.
LOAD_WORKLOAD_USER
Loads a user-defined workload.
PURGE_FILTER Delete a specific filter or all filters.
PURGE_RESULTS Remove all results or those for a specific run.
PURGE_WORKLOAD Delete all workloads or a specific collection.
RECOMMEND_MVIEW_STRATEGY
Generate a set of recommendations about which mviews
should be created, retained, or dropped.
SET_CANCELLED
Stop the Advisor if it takes too long returning results.
VALIDATE_DIMENSION
Verify that the relationships specified in a dimension
are correct.
VALIDATE_WORKLOAD_CACHE
Validate the SQL Cache workload before performing load operations
VALIDATE_WORKLOAD_TRACE
Validate the Oracle Trace workload before performing
load operations
VALIDATE_WORKLOAD_USER
Validate the user-supplied workload before performing
load operations
For full documentation of the packaged procedures above see the Oracle Manual:
"Oracle9i Supplied PL/SQL Packages and Types Reference"
or the book Oracle Built in Packages by Steven Feuerstein et al
Related Commands:
Related Packages: