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
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
|
|
|