Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

Calls

PROCEDURE DBMS_OLAP.ADD_FILTER_ITEM (filter_id IN NUMBER, filter_name IN VARCHAR2, string_list IN VARCHAR2, number_min IN NUMBER, number_max IN NUMBER, date_min IN VARCHAR2, date_max IN 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 (id OUT 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_id IN VARCHAR2, select_clause IN VARCHAR2, num_rows OUT NUMBER, num_bytes OUT 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_id IN NUMBER, workload_id IN NUMBER, filter_id IN 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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page