VIEW: SYS.DBA_APPLY_PARAMETERS

Source

View Text - Preformatted

select ap.apply_name, pp.name, pp.value,
       decode(pp.user_changed_flag, 1, 'YES', 'NO')
  from sys.streams$_process_params pp, sys.streams$_apply_process ap
 where pp.process_type = 1
   and pp.process# = ap.apply#
   and /* display internal parameters if the user changed them */
       (pp.internal_flag = 0
        or
        (pp.internal_flag = 1 and pp.user_changed_flag = 1)
       )

View Text - HTML Formatted

SELECT AP.APPLY_NAME
, PP.NAME
, PP.VALUE
, DECODE(PP.USER_CHANGED_FLAG
, 1
, 'YES'
, 'NO')
FROM SYS.STREAMS$_PROCESS_PARAMS PP
, SYS.STREAMS$_APPLY_PROCESS AP
WHERE PP.PROCESS_TYPE = 1
AND PP.PROCESS# = AP.APPLY#
AND /* DISPLAY INTERNAL PARAMETERS IF THE USER CHANGED THEM */ (PP.INTERNAL_FLAG = 0 OR (PP.INTERNAL_FLAG = 1
AND PP.USER_CHANGED_FLAG = 1) )