Already a member?
Sign in
Welcome! This is a website that everyone can build together. It's easy!
Determine Existence and ReWriteability of Cube Organized Materialized Views (11.1.0)
This script will allow you to determine the existence of Materialized Views generated via the OLAP option.
set lines 110 pages 500
col cube_mv for a35 hea 'Cube Materialized View'
col rewrite_enabled for a7 hea 'ReWrite'
col build_mode for a8 hea 'Build|Mode'
col refresh_mode for a8 hea 'Refresh|Mode'
col refresh_method hea 'Refresh|Method'
col last_refresh_date hea 'Refresh|Last Date' col staleness hea 'Staleness'
select owner||'.'||mview_name cube_mv,rewrite_enabled
, refresh_mode,refresh_method,last_refresh_date,staleness
from all_mviews
where container_name like 'CB$%'
order by cube_mv;
............................................Build... Refresh..Refresh..Refresh
Cube Materialized View..............ReWrite Mode.....Mode.... Method...Last Date Staleness
----------------------------------- ------- -------- --------.--------- -------------------
DM.CB$CHANNEL_SALES_CHANNEL........ N...... DEFERRED.DEMAND...COMPLETE 29-OCT-07 FRESH..............
DM.CB$CUSTOMER_REGIONAL............ N.......DEFERRED.DEMAND...COMPLETE 29-OCT-07 FRESH...............
DM.CB$PRODUCT_STANDARD..............N.......DEFERRED.DEMAND...COMPLETE 29-OCT-07 FRESH...............
DM.CB$SALES_CUBE....................Y.......DEFERRED.DEMAND...FORCE... 29-OCT-07 FRESH...............
DM.CB$TIME_CALENDAR.................N.......DEFERRED.DEMAND...COMPLETE 29-OCT-07 FRESH...............
DM.CB$TIME_FISCAL...................N.......DEFERRED.DEMAND...COMPLETE 29-OCT-07 FRESH...............
set lines 110 pages 500
col cube_mv for a35 hea 'Cube Materialized View'
col rewrite_enabled for a7 hea 'ReWrite'
col build_mode for a8 hea 'Build|Mode'
col refresh_mode for a8 hea 'Refresh|Mode'
col refresh_method hea 'Refresh|Method'
col last_refresh_date hea 'Refresh|Last Date' col staleness hea 'Staleness'
select owner||'.'||mview_name cube_mv,rewrite_enabled
, refresh_mode,refresh_method,last_refresh_date,staleness
from all_mviews
where container_name like 'CB$%'
order by cube_mv;
............................................Build... Refresh..Refresh..Refresh
Cube Materialized View..............ReWrite Mode.....Mode.... Method...Last Date Staleness
----------------------------------- ------- -------- --------.--------- -------------------
DM.CB$CHANNEL_SALES_CHANNEL........ N...... DEFERRED.DEMAND...COMPLETE 29-OCT-07 FRESH..............
DM.CB$CUSTOMER_REGIONAL............ N.......DEFERRED.DEMAND...COMPLETE 29-OCT-07 FRESH...............
DM.CB$PRODUCT_STANDARD..............N.......DEFERRED.DEMAND...COMPLETE 29-OCT-07 FRESH...............
DM.CB$SALES_CUBE....................Y.......DEFERRED.DEMAND...FORCE... 29-OCT-07 FRESH...............
DM.CB$TIME_CALENDAR.................N.......DEFERRED.DEMAND...COMPLETE 29-OCT-07 FRESH...............
DM.CB$TIME_FISCAL...................N.......DEFERRED.DEMAND...COMPLETE 29-OCT-07 FRESH...............
Latest page update: made by olapdba
, Feb 13 2008, 11:17 AM EST
(about this update
About This Update
Edited by olapdba
2 words added
1 word deleted
view changes
- complete history)
Edited by olapdba
2 words added
1 word deleted
view changes
- complete history)
Keyword tags:
None
More Info: links to this page
