DBA Data[Home] [Help]

SYS.DBMS_FEATURE_GOLDENGATE dependencies on DBA_APPLY

Line 46: select decode (count(*), 0, 0, 1) into num_apply from dba_apply

42: select decode (count(*), 0, 0, 1) into num_ds_capture
43: from dba_capture where UPPER(purpose) = 'GOLDENGATE CAPTURE' and
44: UPPER(capture_type) = 'DOWNSTREAM';
45:
46: select decode (count(*), 0, 0, 1) into num_apply from dba_apply
47: where UPPER(purpose) IN ('GOLDENGATE APPLY', 'GOLDENGATE CAPTURE');
48:
49: select sum(count) into num_dblogreader
50: from GV$GOLDENGATE_CAPABILITIES where name like 'DBLOGREADER';