set lines 200
COLUMN ONWER HEADING 'Owner' FORMAT A24
COLUMN ROWNER HEADING 'GroupOwner' FORMAT A24
COLUMN NAME HEADING MV FORMAT A28
COLUMN RNAME HEADING Group FORMAT A28
COLUMN BROKEN HEADING 'Broken?' FORMAT A7
COLUMN next_refresh HEADING 'Next Refresh'
COLUMN INTERVAL HEADING 'Interval' FORMAT a40

SELECT 
  ROWNER 
 ,RNAME 
 ,BROKEN 
 ,TO_CHAR(NEXT_DATE, 'DD-MON-YYYY HH:MI:SS AM') next_refresh 
 ,INTERVAL 
FROM DBA_REFRESH 
--WHERE INTERVAL <> 'null'
ORDER BY 1
/

SELECT 
  OWNER
 ,RNAME 
 ,NAME
 ,BROKEN 
 ,TO_CHAR(NEXT_DATE, 'DD-MON-YYYY HH:MI:SS AM') next_refresh 
 ,INTERVAL 
FROM DBA_REFRESH_CHILDREN       
--WHERE INTERVAL <> 'null'
ORDER BY 1
/

PROMPT
SELECT OWNER, NAME, RNAME, REFGROUP, JOB, NEXT_DATE  FROM DBA_REFRESH_CHILDREN WHERE NAME = 'VIWMRHTDEXT';

SELECT * FROM DBA_REFRESH WHERE RNAME = 'SG_CD03FOL_MUITOGRANDES5';

SELECT * FROM DBA_MVIEW_REFRESH_TIMES  WHERE NAME = 'VIWMRHTDEXT';

SELECT 
   QUERY                                          
  ,REFRESH_MODE                                   
  ,REFRESH_METHOD                                 
  ,BUILD_MODE                                     
  ,FAST_REFRESHABLE                               
  ,LAST_REFRESH_TYPE                              
  ,LAST_REFRESH_DATE                              
  ,STALENESS                                      
FROM DBA_MVIEWS 
WHERE MVIEW_NAME  =  'VIWMRHTDEXT';