PL/SQL Packages DBMS_OLAP

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:



© Copyright SS64.com 1999-2013
Some rights reserved