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:
- About Checking Tablespace and Rollback Segment Requirements
- Adding and Modifying Initialization Parameters
- Monitoring Data Dictionary Tables
Parent topic: Postinstallation Configuration Tasks on Windows
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.
See Also:
Oracle Database Administrator's Guide for more information on tablespace
Parent topic: About Advanced Replication on Windows
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 |
|---|---|---|
|
|
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.
Parent topic: About Advanced Replication on Windows
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.
Parent topic: About Advanced Replication on Windows