GENERATE_MVIEW_REPORT Procedure

Generates an HTML-based report on the given Advisor run.

Syntax

DBMS_OLAP.GENERATE_MVIEW_REPORT (
filename     IN VARCHAR2,
id           IN NUMBER,
flags        IN NUMBER);

Table 34-7 GENERATE_MVIEW_REPORT Procedure Parameters

Parameter	Datatype	Description
filename	VARCHAR2	Fully qualified output file name to receive HTML data. Note that the Oracle server restricts file access within Oracle stored procedures. See the "Security and Performance" section of the Java Developer's Guide for more information on file permissions
id	NUMBER	An ID that identifies an advisor run. Or use the parameter DBMS_OLAP.RUNID_ALL to indicate all advisor runs should be reported
flags	NUMBER	Bit masked flags indicating what sections should be reported DBMS_OLAP.RPT_ACTIVITY -- Overall activities DBMS_OLAP.RPT_JOURNAL -- Runtime journals DBMS_OLAP.RPT_WORKLOAD_FILTER -- Filters DBMS_OLAP.RPT_WORKLOAD_DETAIL -- Workload information DBMS_OLAP.RPT_WORKLOAD_QUERY -- Workload query information DBMS_OLAP.RPT_RECOMMENDATION -- Recommendations DBMS_OLAP.RPT_USAGE -- Materialized view usage DBMS_OLAP.RPT_ALL -- All sections