Replication Enhancements in 9i

Replication Enhancements

9i allows you to add a new Master site to a Master Group without quiescing the Master Group. The new Master site must be configured for multi-master replication, you can only add one new Master site at a time, the Master Group must be replicating in asynchronous mode, and all links must be configured for parallel propagation.

To ensure transactions are propagated in the proper order, 9i now tracks dependency SCNs at the row level (8i could not track dependencies because it only tracked SCNs at the block level). To use this feature, encode keyword ROWDEPENDENCIES on the CREATE TABLE statement.

9i can now replicate user-defined types, user-defined operators, and these database objects:

• Tables having column objects, nested tables, VARRAYs and REF columns
• Object tables
• Object views (including INSTEAD OF triggers)
• Index types

9i eliminates the SNP background processes used to submit jobs. Instead, it uses a job coordinator background process (called CJQ0), and that job coordinator spawns job queue processes (J00n) to perform the work. The initialization parameter JOB_QUEUE_PROCESSES establishes the upper limit for the number of job queue processes, and the parameter JOB_QUEUE_INTERVAL is now obsolete.