|Oracle® Beehive Installation Guide
Release 1 (1.4) for Linux x86
Part Number E13791-03
disable_on_error parameter to
N in the
DBMS_APPLY_ADM package so that errors are skipped:
BEGIN exec dbms_apply_adm.set_parameter ( apply_name => 'CDC$A_SEARCH_CHANGE_SET', parameter => 'disable_on_error', value => 'N' ); END;
DBMS_CAPTURE_ADM package as follows:
BEGIN exec dbms_capture_adm.set_parameter ( 'CDC$C_SEARCH_CHANGE_SET', '_checkpoint_frequency', '1000' ); END; BEGIN exec dbms_capture_adm.alter_capture ( 'CDC$C_SEARCH_CHANGE_SET', checkpoint_retention_time => 14 ); END;
Oracle Beehive uses Oracle LogMiner extensively, which enables you to query online and archived redo log files through an SQL interface. By default, Oracle LogMiner stores its data in the
SYSAUX tablespace. By default, the
SYSAUX tablespace contains one datafile (bigfile) in auto-extensible mode. This means that if
SYSAUX is almost out of space, the RDBMS kernel will physically increase the size of the datafile, which is a time-consuming operation.
To prevent this operation from occurring too frequently, perform one of the following recommendations:
Make sure that there is enough space in the
SYSAUX tablespace, and follow the steps described in OracleMetaLink Note 429599.1, "How to reduce the Highwater of
LOGMNR_RESTART_CKPT$ in 10.2."
Make sure that there is enough space in
SYSAUX, and increase the size of disk space to be allocated automatically when more extends are required. (The default is the size of one data block). Specify this size in the
NEXT clause of the
autoextend_clause in the SQL statement
For example, the following statement modifies the
SYSAUX tablespace datafile so that 500 Mb will be allocated to it when more extends are required:
ALTER DATABASE DATAFILE '<location of SYSAUX datafile>' AUTOEXTEND ON NEXT 500M;
Refer to Oracle Database SQL Language Reference for more information.
DBMS_LOGMNR_D.SET_TABLESPACE procedure to re-create all Oracle LogMiner tables in an alternate tablespace. Ensure that the alternate tablespace has the characteristics specified in recommendation 2 (specifying a larger amount of disk space to be allocated when more extends are required).
Refer to the
SET_TABLESPACE procedure from the
DBMS_LOGMNR_D package in Oracle Database PL/SQL Packages and Types Reference for more information.