Change: cube_name,cube_name, decode(sparse_type,'COMPRESSED','COMPR',sparse_type) sparse_type, sparse_type, to_char(precompute_condition) precompute_condition,precompute_condition, nvl(precompute_percent,0) precompute_percent, precompute_percent, nvl(precompute_percent_top,0) precompute_percent_top from all_cubes order by 1,2,3;OWNER AW ......... CUBE_NAME. TYPE . PRECOMPUTE_CONDITION ..................................... PCT TOP----- ------------ ---------- ------ ---------------------------------------------------------- --- ---DM .. SALES ...... FORECAST . DENSE. DM.TIME   View changes from previous version. (Word count: 185)

Change: There were only format changes (bold, italics, etc.) in this version. See this version for details. (Word count: 185)

Change: To determine Cube information in Oracle Database 11g consider using this script. set lines 110 pages 1000 col owner for a5col cube_name for a10col aw_name for a12 hea AWcol sparse_type for a6 hea TYPEcol precompute_condition for a54 wrapcol precompute_percent for 99 hea PCTcol   View changes from previous version. (Word count: 185)