21: feature_usage := NULL;
22: total_feature_usage := 0;
23:
24: select decode (count(*), 0, 0, 1) into num_capture
25: from dba_capture
26: where UPPER(purpose) NOT IN ('GOLDENGATE CAPTURE','XSTREAM_OUT');
27:
28: select decode (count(*), 0, 0, 1) into num_ds_capture
29: from dba_capture
25: from dba_capture
26: where UPPER(purpose) NOT IN ('GOLDENGATE CAPTURE','XSTREAM_OUT');
27:
28: select decode (count(*), 0, 0, 1) into num_ds_capture
29: from dba_capture
30: where UPPER(purpose) NOT IN ('GOLDENGATE CAPTURE','XSTREAM_OUT')
31: and UPPER(capture_type) = 'DOWNSTREAM';
32:
33: select decode (count(*), 0, 0, 1) into num_apply