Recommended setting of PROCESSES parameter in the init.ora file. (4321191)

What is the recommended value of PROCESSES parameter in the init.ora file.

General Recommendations by Shareplex (Best Practices)

PROCESSES parameter

The PROCESSES parameter in the init.ora file must be set to accommodate connections created by Shareplex and the database users. Its value depends on whether a system is a source system, a target system, or a system that serves as both a source and target system.

1)Source system only

If a system serves only as a source system, the following formula takes into account logins made by the Read process.

(Peak number of source database sessions) + (background Oracle processes) + (value of SP_ORD_LDA_ARRAY_SIZE parameter +3) = PROCESSES value

Although the Post process is one Oracle user, it creates as many connections on the target system as there are sessions on the source system in order to maintain transaction consistency.

2)Target system only

The PROCESSES parameter on the target system must be set high enough to accommodate Post's connections, plus the background Oracle processes those connections generate, plus the peak number of users expected to access the target database for queries. Use the following formula as a guide:

(Peak number of source database sessions) + (peak number of target database sessions) + (background Oracle processes) = PROCESSES value

3)Combination of source and target system

If a system serves as both a source system and a target system, the following formula takes into account logins made by the Read process as well as Post's connections, background Oracle processes, and user connections.

(Peak number of source database sessions) + (peak number of target database sessions) + (background Oracle processes) + (value of SP_ORD_LDA_ARRAY_SIZE parameter +3) = PROCESSES value