VIEW: SYS.KU$_M_VIEW_LOG_VIEW

Source

View Text - Preformatted

select '1',
         case when dbms_metadata.get_version >= '11.02.00.00.00' then '1'
              else '0'
         end,
         m.mowner, m.master,
         to_char(m.oldest,'YYYY-MM-DD HH24:MI:SS'),
         TO_CHAR(m.oldest_pk, 'YYYY-MM-DD HH24:MI:SS'),
         m.oscn,
         TO_CHAR(m.youngest, 'YYYY-MM-DD HH24:MI:SS'),
         m.yscn, m.log, m.trig,
         case when dbms_metadata.get_version >= '11.02.00.00.00'
           then m.flag
           else bitand(m.flag,65535)  /* pre-11.2, flag was a ub2 */
         end,
         TO_CHAR(m.mtime, 'YYYY-MM-DD HH24:MI:SS'),
         m.temp_log,
         TO_CHAR(m.oldest_oid, 'YYYY-MM-DD HH24:MI:SS'),
         TO_CHAR(m.oldest_new, 'YYYY-MM-DD HH24:MI:SS'),
         TO_CHAR(m.oldest_seq, 'YYYY-MM-DD HH24:MI:SS'),
         p.value$,
         case when dbms_metadata.get_version >= '11.02.00.00.00'
           then TO_CHAR(m.purge_start, 'YYYY-MM-DD HH24:MI:SS')
           else NULL
         end,
         case when dbms_metadata.get_version >= '11.02.00.00.00'
           then m.purge_next
           else NULL
         end,
         (select count(*)
                       from   sys.mlog_refcol$ r
                       where  m.mowner = r.mowner
                          and m.master = r.master),
         cast(multiset(select r.colname,
                              to_char(r.oldest, 'YYYY-MM-DD HH24:MI:SS'),
                              r.flag
                       from   sys.mlog_refcol$ r
                       where  m.mowner = r.mowner
                          and m.master = r.master)
                       as ku$_refcol_list_t),
         (select count(*)
                       from   sys.slog$ s
                       where  m.mowner = s.mowner
                          and m.master = s.master),
         cast(multiset(select s.snapid,
                              to_char(s.snaptime, 'YYYY-MM-DD HH24:MI:SS'),
                              case when
                                dbms_metadata.get_version >= '11.02.00.00.00'
                                then s.tscn
                                else NULL
                              end
                       from   sys.slog$ s
                       where  m.mowner = s.mowner
                          and m.master = s.master)
                       as ku$_slog_list_t)
  from   sys.mlog$ m, sys.props$ p
  where  p.name  = 'GLOBAL_DB_NAME'
  /* for < 11.2, exclude MV logs with async_purge, sched_purge, commit scn */
  and (dbms_metadata.get_version >= '11.02.00.00.00'
       or
       (dbms_metadata.get_version < '11.02.00.00.00'
        and bitand(m.flag, 16384+32768+65536)=0))

View Text - HTML Formatted

SELECT '1'
, CASE WHEN DBMS_METADATA.GET_VERSION >= '11.02.00.00.00' THEN '1' ELSE '0' END
, M.MOWNER
, M.MASTER
, TO_CHAR(M.OLDEST
, 'YYYY-MM-DD HH24:MI:SS')
, TO_CHAR(M.OLDEST_PK
, 'YYYY-MM-DD HH24:MI:SS')
, M.OSCN
, TO_CHAR(M.YOUNGEST
, 'YYYY-MM-DD HH24:MI:SS')
, M.YSCN
, M.LOG
, M.TRIG
, CASE WHEN DBMS_METADATA.GET_VERSION >= '11.02.00.00.00' THEN M.FLAG ELSE BITAND(M.FLAG
, 65535) /* PRE-11.2
, FLAG WAS A UB2 */ END
, TO_CHAR(M.MTIME
, 'YYYY-MM-DD HH24:MI:SS')
, M.TEMP_LOG
, TO_CHAR(M.OLDEST_OID
, 'YYYY-MM-DD HH24:MI:SS')
, TO_CHAR(M.OLDEST_NEW
, 'YYYY-MM-DD HH24:MI:SS')
, TO_CHAR(M.OLDEST_SEQ
, 'YYYY-MM-DD HH24:MI:SS')
, P.VALUE$
, CASE WHEN DBMS_METADATA.GET_VERSION >= '11.02.00.00.00' THEN TO_CHAR(M.PURGE_START
, 'YYYY-MM-DD HH24:MI:SS') ELSE NULL END
, CASE WHEN DBMS_METADATA.GET_VERSION >= '11.02.00.00.00' THEN M.PURGE_NEXT ELSE NULL END
, (SELECT COUNT(*)
FROM SYS.MLOG_REFCOL$ R
WHERE M.MOWNER = R.MOWNER
AND M.MASTER = R.MASTER)
, CAST(MULTISET(SELECT R.COLNAME
, TO_CHAR(R.OLDEST
, 'YYYY-MM-DD HH24:MI:SS')
, R.FLAG
FROM SYS.MLOG_REFCOL$ R
WHERE M.MOWNER = R.MOWNER
AND M.MASTER = R.MASTER) AS KU$_REFCOL_LIST_T)
, (SELECT COUNT(*)
FROM SYS.SLOG$ S
WHERE M.MOWNER = S.MOWNER
AND M.MASTER = S.MASTER)
, CAST(MULTISET(SELECT S.SNAPID
, TO_CHAR(S.SNAPTIME
, 'YYYY-MM-DD HH24:MI:SS')
, CASE WHEN DBMS_METADATA.GET_VERSION >= '11.02.00.00.00' THEN S.TSCN ELSE NULL END
FROM SYS.SLOG$ S
WHERE M.MOWNER = S.MOWNER
AND M.MASTER = S.MASTER) AS KU$_SLOG_LIST_T)
FROM SYS.MLOG$ M
, SYS.PROPS$ P
WHERE P.NAME = 'GLOBAL_DB_NAME' /* FOR < 11.2
, EXCLUDE MV LOGS WITH ASYNC_PURGE
, SCHED_PURGE
, COMMIT SCN */
AND (DBMS_METADATA.GET_VERSION >= '11.02.00.00.00' OR (DBMS_METADATA.GET_VERSION < '11.02.00.00.00'
AND BITAND(M.FLAG
, 16384+32768+65536)=0))