Oracle | DBMS_AW

Oracle DBMS_AW_STATS Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Gathers statistics for AW's DIMENSIONS & CUBES. Statistics generation does not have a significant performance cost.

AUTHID CURRENT_USER

Constants

Name	Data Type	Value
aw_error	NUMBER	-20001

Dependencies

DBMS_AW_LIB

DBMS_STANDARD

DBMS_UTILITY

Documented Yes: Packages and Types Reference

First Available 11.1

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/dbmsawst.sql

Subprograms

ANALYZE

CLEAR

ANALYZE

This procedure generates optimizer statistics on a cube or dimension dbms_aw_stats.analyze(inName IN VARCHAR2);

BEGIN

        dbms_aw_stats.analyze('units_cube');

        dbms_aw_stats.analyze('time');

        dbms_aw_stats.analyze('customer');

        dbms_aw_stats.analyze('product');

        dbms_aw_stats.analyze('channel');

      END;

      /

CLEAR

Clears optimizer statistics on a cube or dimension dbms_aw_stats.clear(inName IN VARCHAR2);

BEGIN

        dbms_aw_stats.clear('channel');

      END;

      /