VIEW: SYSTEM.MVIEW_LOG

Source

View Text - Preformatted

select
      m.runid# as id,
      m.filterid# as filterid,
      m.run_begin,
      m.run_end,
      decode(m.run_type,1,'EVALUATE',2,'EVALUATE_W',3,'RECOMMEND',
                      4,'RECOMMEND_W',5,'VALIDATE',6,'WORKLOAD',
                      7,'FILTER','UNKNOWN') AS type,
      decode(m.status,0,'UNUSED',1,'CANCELLED',2,'IN_PROGRESS',3,'COMPLETED',
                    4,'ERROR','UNKNOWN') AS status,
      m.message,
      m.completed,
      m.total,
      m.error_code
   from system.mview$_adv_log m, all_users u
   where m.uname = u.username
   and   u.user_id = userenv('SCHEMAID')

View Text - HTML Formatted

SELECT M.RUNID# AS ID
, M.FILTERID# AS FILTERID
, M.RUN_BEGIN
, M.RUN_END
, DECODE(M.RUN_TYPE
, 1
, 'EVALUATE'
, 2
, 'EVALUATE_W'
, 3
, 'RECOMMEND'
, 4
, 'RECOMMEND_W'
, 5
, 'VALIDATE'
, 6
, 'WORKLOAD'
, 7
, 'FILTER'
, 'UNKNOWN') AS TYPE
, DECODE(M.STATUS
, 0
, 'UNUSED'
, 1
, 'CANCELLED'
, 2
, 'IN_PROGRESS'
, 3
, 'COMPLETED'
, 4
, 'ERROR'
, 'UNKNOWN') AS STATUS
, M.MESSAGE
, M.COMPLETED
, M.TOTAL
, M.ERROR_CODE
FROM SYSTEM.MVIEW$_ADV_LOG M
, ALL_USERS U
WHERE M.UNAME = U.USERNAME
AND U.USER_ID = USERENV('SCHEMAID')