Mview

SELECT OWNER, NAME, TABLE_NAME, UPDATABLE, REFRESH_METHOD,
LAST_REFRESH, ERROR, TYPE, NEXT, START_WITH, STATUS, REFRESH_MODE
FROM CDB_SNAPSHOTS;

alter session set nls_date_format='dd-mm-yyyy hh24:mi';

set linesize 300
set pagesize 200
col owner for a20
col mview_name for a50
col container_name for a40
select owner,mview_name,container_name,fast_refreshable,staleness,compile_state,stale_since,con_id
from cdb_mviews
order by owner,mview_name;