alter session set nls_date_format = 'DD-MON-YY HH24:MI:SS';column Owner format a14column master_owner format a14select distinct owner,name mview,master_owner master_owner,last_refreshfrom dba_mview_refresh_times;set long 4000alter 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_fastfrom dba_mviews where mview_name = '';
Wednesday, August 18, 2010
Check when was materialised view got refreshed
Checking when was the MV got refreshed last time:
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment