Initialization parameters

global_names: This parameter specifies whether or not the database link is required to have the same name as the database to which it connects. In order to use Streams to share information between databases, this parameter should be set to TRUE at each database that is participating in the Streams environment.  When setting a TRUE value for this parameter, a database link whose name matches with the destination database name must be created.

job_queue_processes This parameter specifies the number of job queue processes for each instance.  The numbers range from J000 to J999.  Job queue processes handle requests created by dbms_job. This parameter must be set to at least 2 at each database that is propagating events in the Streams environment.  It should be set to the same value as the maximum number of jobs that can run simultaneously, plus two. This is an important parameter. If this parameter is not set, Oracle will not spawn any job processes and the Streams propagation process never starts.

open_link This parameter specifies the maximum number of concurrent open connections to remote databases that are allowed in one session. These connections include database links as well as external procedures and cartridges, each of which uses a separate process. In a Streams environment, this parameter should be set to the default value of 4 or higher. Especially, when multi-way replication is configured, many database links will be used for data transfer. Setting the correct number of links in the open_link parameter ensures that all of those links will be successful.