@nls

column owner format a15
column FAST_REF format a8
column COMPILE format a8
column REWRITE format a7
column STALENESS format a9


select owner,mview_name,last_refresh_date, REWRITE_ENABLED REWRITE, REWRITE_CAPABILITY, REFRESH_MODE REF_MD, REFRESH_METHOD REF_MTHD, BUILD_MODE, FAST_REFRESHABLE FAST_REF, LAST_REFRESH_TYPE, STALENESS, COMPILE_STATE COMPILE
from dba_mviews 
where owner like upper('%&1%') 
and mview_name like upper('%&2%')  order by 1,2;

