$page_title = $titlebar_text; $header_bar_text = $titlebar_text; ///////////////////////////////////// // get header include('rlib_header.php'); // print <<

Oracle DBMS_AW_STATS

Version 11.1  
General Information
Description Gathers statistics for AW's DIMENSIONS & CUBES
Source {ORACLE_HOME}/rdbms/admin/dbmsawst.sql
First Available 11.1
Constants
Name Data Type Value

aw_error

NUMBER -20001
Dependencies

DBMS_ASSERT

DBMS_AW_LIB DUAL
Object Privileges execute granted to PUBLIC
 
ANALYZE

This procedure generates optimizer statistics on a cube or a 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;
/
 
Related Topics
DBMS_AW
  EOM; ///////////////////////////////////// // get footer include('rlib_footer.php'); ?>