16 Oracle Beehive Database Post-Installation Procedures

After successfully installing Oracle Beehive, perform the following tuning recommendations on your Oracle Beehive database:

• Set the disable_on_error parameter to N in the DBMS_APPLY_ADM package so that errors are skipped (execute these PL/SQL block as the SYS user):

  BEGIN
    dbms_apply_adm.set_parameter (
      apply_name => 'CDC$A_SEARCH_CHANGE_SET',
      parameter => 'disable_on_error',
      value => 'N'
    );
  END;
  /
  
  BEGIN
    dbms_apply_adm.start_apply(apply_name => 'CDC$A_SEARCH_CHANGE_SET');
  END;
  /
  

• Configure the DBMS_CAPTURE_ADM package as follows (execute these PL/SQL blocks as the SYS user):

  BEGIN
    dbms_capture_adm.set_parameter (
      'CDC$C_SEARCH_CHANGE_SET',
      '_checkpoint_frequency',
      '1000'
    );
  END;
  /
  
  BEGIN
    dbms_capture_adm.alter_capture (
      'CDC$C_SEARCH_CHANGE_SET',
      checkpoint_retention_time => 14
    );
  END;
  /