Oracle DBMS_AW_STATS
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
 
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_ASSERT DBMS_STANDARD DBMS_UTILITY
DBMS_AW_LIB    
Documented Yes
First Available 11.1.0.6
Security Model Owned by SYS with EXECUTE granted to PUBLIC
Source {ORACLE_HOME}/rdbms/admin/dbmsawst.sql
Subprograms
 
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;
/

Related Topics
DBMS_AW
DBMS_AW_XML
DBMS_CUBE
DBMS_CUBE_LOG
Packages
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved