VIEW: SYS.DBA_AUDIT_MGMT_CONFIG_PARAMS

Source

View Text - Preformatted

SELECT PARAMETER_NAME,
       (CASE
            WHEN cfg.PARAM_ID = 22 THEN STRING_VALUE
            WHEN cfg.PARAM_ID = 33 THEN
              decode(NUMBER_VALUE,
                     1, 'QUEUED WRITE MODE',
                     2, 'IMMEDIATE WRITE MODE',
                        'UNKNOWN MODE')
            ELSE
                CASE
                    WHEN NUMBER_VALUE = 0 THEN 'NOT SET'
                    ELSE TO_CHAR(NUMBER_VALUE)
                END
        END),
       decode(cfg.AUDIT_TRAIL_TYPE#,
              1, 'STANDARD AUDIT TRAIL',
              2, 'FGA AUDIT TRAIL',
              3, 'STANDARD AND FGA AUDIT TRAIL',
              4, 'OS AUDIT TRAIL',
              8, 'XML AUDIT TRAIL',
             12, 'OS AND XML AUDIT TRAIL',
             15, 'ALL AUDIT TRAILS',
             51, 'UNIFIED AUDIT TRAIL',
                 'UNKNOWN AUDIT TRAIL')
FROM DAM_CONFIG_PARAM$ cfg, DAM_PARAM_TAB$ prm
WHERE prm.PARAMETER# = cfg.PARAM_ID

View Text - HTML Formatted

SELECT PARAMETER_NAME
, (CASE WHEN CFG.PARAM_ID = 22 THEN STRING_VALUE WHEN CFG.PARAM_ID = 33 THEN DECODE(NUMBER_VALUE
, 1
, 'QUEUED WRITE MODE'
, 2
, 'IMMEDIATE WRITE MODE'
, 'UNKNOWN MODE') ELSE CASE WHEN NUMBER_VALUE = 0 THEN 'NOT SET' ELSE TO_CHAR(NUMBER_VALUE) END END)
, DECODE(CFG.AUDIT_TRAIL_TYPE#
, 1
, 'STANDARD AUDIT TRAIL'
, 2
, 'FGA AUDIT TRAIL'
, 3
, 'STANDARD
AND FGA AUDIT TRAIL'
, 4
, 'OS AUDIT TRAIL'
, 8
, 'XML AUDIT TRAIL'
, 12
, 'OS
AND XML AUDIT TRAIL'
, 15
, 'ALL AUDIT TRAILS'
, 51
, 'UNIFIED AUDIT TRAIL'
, 'UNKNOWN AUDIT TRAIL') FROM DAM_CONFIG_PARAM$ CFG
, DAM_PARAM_TAB$ PRM WHERE PRM.PARAMETER# = CFG.PARAM_ID