Oracle® Beehive Installation Guide Release 1 (1.4) for Solaris Operating System (SPARC 64-Bit) Part Number E13793-02 |
|
|
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:
BEGIN exec dbms_apply_adm.set_parameter ( apply_name => 'CDC$A_SEARCH_CHANGE_SET', parameter => 'disable_on_error', value => 'N' ); END;
Configure the 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 ALTER TABLESPACE
.
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.
Call the 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.