Calls
-
PROCEDURE DBMS_OLAP.ADD_FILTER_ITEM(filter_idIN NUMBER,filter_nameIN VARCHAR2,string_listIN VARCHAR2,number_minIN NUMBER,number_maxIN NUMBER,date_minIN VARCHAR2,date_maxIN VARCHAR2); Adds another filter to an existing filter, filter_id. The filter_name parameter describes the type of filter, while the remainder of the parameters are used by different types of filters. New with Oracle9i.
-
PROCEDURE DBMS_OLAP.CREATE_ID(idOUT NUMBER); Creates a unique id used to identify a filter, workload, or results of a Summary Advisor or validation run. New with Oracle9i.
-
PROCEDURE DBMS_OLAP.ESTIMATE_{SUMMARY_SIZE | MVIEW_SIZE}(stmt_idIN VARCHAR2,select_clauseIN VARCHAR2,num_rowsOUT NUMBER,num_bytesOUT NUMBER); Returns num_rows and num_bytes that would be in a materialized view created by the select_clause. ESTIMATE_SUMMARY_SIZE was used with Oracle8i and ESTIMATE_MVIEW_SIZE with Oracle9i.
-
PROCEDURE DBMS_OLAP.EVALUATE_UTILIZATION; Measures utilization of materialized views. The output is in MVIEW$_EVALUATIONS. Only in Oracle8i.
-
PROCEDURE DBMS_OLAP.EVALUATE_UTILIZATION_W; Measures utilization of materialized views based on a workload in the default schema. Only in Oracle8i.
-
PROCEDURE DBMS_OLAP.EVALUATE_MVIEW_STRATEGY(run_idIN NUMBER,workload_idIN NUMBER,filter_idIN NUMBER); Estimates utilization of a materialized view, based on a workload_id and filter_id and returns run_id as an ID to identify the results of the run. New with Oracle9i.
-
PROCEDURE DBMS_OLAP.GENERATE_MVIEW_REPORT ...