Wednesday, August 18, 2010

Check when was materialised view got refreshed

Checking when was the MV got refreshed last time:

alter session set nls_date_format = 'DD-MON-YY HH24:MI:SS';

column Owner format a14
column master_owner format a14

select distinct owner,
name mview,
master_owner master_owner,
last_refresh
from dba_mview_refresh_times;

set long 4000
alter session set nls_date_format='DD-MON-YYYY HH24:MI:SS';
select query, rewrite_enabled, refresh_mode rmode, refresh_method rmethod,
last_refresh_date, last_refresh_type rtype, staleness, compile_state,
build_mode bmode, fast_refreshable ref_fast
from dba_mviews where mview_name = '';

No comments: