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
© Copyright SS64.com 1999-2013
Some rights reserved