EVALUATE_MVIEW_STRATEGY Procedure

This procedure measures the utilization of each existing materialized view based on the materialized view usage statistics collected from the workload. The workload_id is optional. If not provided, EVALUATE_MVIEW_STRATEGY uses a hypothetical workload.

Periodically, the unused results can be purged from the system by calling the DBMS_OLAP.PURGE_RESULTS procedure.

See Also: "DBMS_OLAP Interface Views"

Syntax

DBMS_OLAP.EVALUATE_MVIEW_STRATEGY (
run_id        IN NUMBER,
workload_id   IN NUMBER,
filter_id     IN NUMBER);

Parameters

Table 34-6 EVALUATE_MVIEW_STRATEGY Procedure Parameters

Parameter	Datatype	Description
run_id	NUMBER	An ID generated by the DBMS_OLAP.CREATE_ID procedure to identify results of a run
workload_id	NUMBER	An optional workload ID that maps to a workload in the current repository. Use the parameter DBMS_OLAP.WORKLOAD_ALL to choose all workloads
filter_id	NUMBER	Specify filter for the workload to be used. The value DBMS_OLAP.FILTER_NONE indicates no filtering