| 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 is granted to PUBLIC |
| |
| 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 (11.2)  |
Clears optimizer statistics on a cube or dimension |
dbms_aw_stats.clear(inName IN VARCHAR2); |
BEGIN
dbms_aw_stats.clear('channel');
END;
/ |
