VIEW: SYS.DBA_SECUREFILE_LOG_PARTITIONS

Source

View Text - Preformatted

select p.guid, u.name, d.name, p.log#, tb.name, p.part#, t.name,
  decode(bitand(p.lob_flags, 2), 2, 'SFILE_CACHE', 'SFILE_NOCACHE'),
         decode(bitand(p.lob_flags, 12),
                    4, 'SFILE_NOLOGGED',
                    8, 'SFILE_FS_LOGGED',
                    'SFILE_LOGGED'),
         decode(bitand(p.lob_flags, 16), 16, 'DEDUPLICATE',
                'NO_DEDUPLICATE'),
         decode(bitand(p.lob_flags, 224),
                  32, 'SFILE_COMPRESS_HIGH',
                  64, 'SFILE_COMPRESS_LOW',
                  128, 'SFILE_COMPRESS_MEDIUM',
                  'SFILE_NOCOMPRESS'),
  p.name, p.part_scn, p.part_time, p.min_scn, p.min_time
         from cli_log$ d, cli_part$ p, ts$ t, user$ u, cli_tab$ tb
         where d.log# = p.log# and p.log# = tb.log# and p.tab# = tb.tab# and p.user# = u.user#
          and  p.ts#  = t.ts#

View Text - HTML Formatted

SELECT P.GUID
, U.NAME
, D.NAME
, P.LOG#
, TB.NAME
, P.PART#
, T.NAME
, DECODE(BITAND(P.LOB_FLAGS
, 2)
, 2
, 'SFILE_CACHE'
, 'SFILE_NOCACHE')
, DECODE(BITAND(P.LOB_FLAGS
, 12)
, 4
, 'SFILE_NOLOGGED'
, 8
, 'SFILE_FS_LOGGED'
, 'SFILE_LOGGED')
, DECODE(BITAND(P.LOB_FLAGS
, 16)
, 16
, 'DEDUPLICATE'
, 'NO_DEDUPLICATE')
, DECODE(BITAND(P.LOB_FLAGS
, 224)
, 32
, 'SFILE_COMPRESS_HIGH'
, 64
, 'SFILE_COMPRESS_LOW'
, 128
, 'SFILE_COMPRESS_MEDIUM'
, 'SFILE_NOCOMPRESS')
, P.NAME
, P.PART_SCN
, P.PART_TIME
, P.MIN_SCN
, P.MIN_TIME
FROM CLI_LOG$ D
, CLI_PART$ P
, TS$ T
, USER$ U
, CLI_TAB$ TB
WHERE D.LOG# = P.LOG#
AND P.LOG# = TB.LOG#
AND P.TAB# = TB.TAB#
AND P.USER# = U.USER#
AND P.TS# = T.TS#