Oracle | DBMS_AW

Oracle DBMS_AW_STATS Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

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;

      /