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.
See Also:
Oracle Database Advanced Replication for more information about Advanced Replication and for definitions of master sites and materialized view sites
Configuring Advanced Replication consists of the following steps:
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.
See Also:
Oracle Database Administrator's Guide for more information on tablespace
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 |
|---|---|---|
|
|
50 MB |
master |
|
|
300 seconds |
master |
|
|
TRUE |
master |
|
|
4 |
master |
|
|
Add 9 to current value |
master |
|
|
2 |
master |
|
|
2 |
materialized view |
Note
Depends on the number of n-way sites.
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.