About Advanced Replication on Windows

5.10 About Advanced Replication on Windows

Oracle Database installs packages and procedures automatically rather than as a separate manual process. There are many configuration and usage possibilities with Advanced Replication.

This section describes how to manually configure Advanced Replication in Oracle Database. Follow the instructions only if you add Advanced Replication to an installation of Oracle Database that was not previously configured with this feature.

Configuring Advanced Replication consists of the following steps:

Topics:

5.10.1 About Checking Tablespace and Rollback Segment Requirements

Table 5-3 Advanced Replication Tablespace/Rollback Segment Requirements

Tablespace/Rollback Segment	Minimum Free Space
SYSTEM	20 MB
UNDOTBS	10 MB
RBS	5 MB
TEMP	10 MB
USERS	No specific requirement

Note:

Replication triggers and procedures are stored here.

5.10.2 Adding and Modifying Initialization Parameters

If you use Advanced Replication, then certain parameter values must be added to the initialization parameter file, and others must be set to recommended values.

Table 5-4 Advanced Replication Initialization Parameters

Parameter Name	Recommended Value	Site
`JAVA_POOL_SIZE`	50 MB	master
`DISTRIBUTED_LOCK_TIMEOUT`	300 seconds	master
`GLOBAL_NAMES`	TRUE	master
`OPEN_LINKS`	4	master
`PROCESSES`	Add 9 to current value	master
`JOB_QUEUE-PROCESSES`	2	master
`JOB_QUEUE_PROCESSES`	2	materialized view

Note

Depends on the number of n-way sites.

5.10.3 Monitoring Data Dictionary Tables

If you use Advanced Replication and intend to set up a large number of replicated objects, then you are required to monitor the following data dictionary tables with the SQL SELECT argument:

ARGUMENT$
IDL_CHAR$
IDL_UB1$
IDL_UB2$
IDL_SB4$
I_ARGUMENT1
I_SOURCE1I$
SOURCE$
TRIGGER

If necessary, increase the storage parameters to accommodate storage requirements of large numbers of replicated objects.