Oracle Distributed Systems

Size and Placement of Data Dictionary Objects

The properties of advanced replication’s underpinning tables and indexes are such that they warrant their own tablespace. A default installation, however, places these objects in the SYSTEM tablespace with its default values for INITIAL and NEXT extents. The default installation quickly fragments the SYSTEM tablespace and often requires the addition of several data files to support the growth of the replication data dictionary. Fortunately, these problems are avoidable if you follow these steps when you create your database or at least before you run catproc.sql :

1. Create a separate tablespace for the replication data dictionary objects, and specify default storage parameters for INITIAL, NEXT, and PCTINCREASE:

   CREATE TABLESPACE symrep_data
   DATAFILE '/export/vol01/oradata/PHQS/symrep_data01.dbf' SIZE 500M
   DEFAULT STORAGE (INITIAL 512K NEXT 1M PCTINCREASE 1);

2. Make the new tablespace the default tablespace for user SYSTEM:

   ALTER USER system DEFAULT TABLESPACE symrep_data;

3. Run the catproc.sql script from server manager, connected as user SYS:

   socrates% svrmgrl
   
   Oracle Server Manager Release 3.0.4.0.0 - Production
   
   (c) Copyright 1997, Oracle Corporation.  All Rights Reserved.
   
   Oracle8 Enterprise Edition Release 8.0.4.1.0 - Production
   With the Partitioning and Objects options
   PL/SQL Release 8.0.4.1.0 - Production
   
   SVRMGR> connect internal
   Connected.
   SVRMGR> @catproc
   ...

   catproc.sql creates, among other things, the objects that support deferred transactions, ...