Oracle® Beehive Installation Guide Release 1 (1.5) for Solaris Operating System (SPARC 64-Bit) Part Number E14832-05 |
|
|
View PDF |
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; /