VIEW: SYS.DBA_CAPTURE_PARAMETERS

Source

View Text - Preformatted

select q.capture_name, p.name, p.value,
       decode(p.user_changed_flag, 1, 'YES', 'NO'), p.source_database
  from sys.streams$_process_params p, sys.streams$_capture_process q
 where p.process_type = 2
   and p.process# = q.capture#
   and /* display internal parameters if the user changed them */
       (p.internal_flag = 0
        or
        (p.internal_flag = 1 and p.user_changed_flag = 1)
       )

View Text - HTML Formatted

SELECT Q.CAPTURE_NAME
, P.NAME
, P.VALUE
, DECODE(P.USER_CHANGED_FLAG
, 1
, 'YES'
, 'NO')
, P.SOURCE_DATABASE
FROM SYS.STREAMS$_PROCESS_PARAMS P
, SYS.STREAMS$_CAPTURE_PROCESS Q
WHERE P.PROCESS_TYPE = 2
AND P.PROCESS# = Q.CAPTURE#
AND /* DISPLAY INTERNAL PARAMETERS IF THE USER CHANGED THEM */ (P.INTERNAL_FLAG = 0 OR (P.INTERNAL_FLAG = 1
AND P.USER_CHANGED_FLAG = 1) )