CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

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
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [206 users online]    © 2010 psoug.org