1. Reference for Oracle GoldenGate
  2. Oracle GoldenGate Classic Architecture
  3. Manager Parameters
  4. THREADOPTIONS

THREADOPTIONS

Valid For

Classic Extract, Oracle Database only

Description

Use the THREADOPTIONS parameter to control how a threaded Extract operates.

Stop and restart GGSCI, Manager, and Extract for the change to take effect.

Default

None

Syntax

THREADOPTIONS
[INQUEUESIZE n]
[OUTQUEUESIZE n]
[PROCESSTHREADS SELECT thread_spec | PROCESSTHREADS EXCEPT thread_spec]
[STACKSIZE bytes]
INQUEUESIZE n

Specifies the number of queue entries in the input queue of each producer Extract thread in an Oracle RAC cluster. Higher values produce better performance for large amounts of data. Lower values move data more quickly in environments with very little activity. Valid values are 16 to 65535. The default is 128. The default should be adequate in most cases, but if you need to increase it, 1000 should be sufficient in most types of environments. See also OUTQUEUESIZE.

In addition to INQUEUESIZE and OUTQUEUESIZE, AIX users might obtain better performance by setting the environment variable AIXTHREAD_SCOPE to S (system scope) which specifies the use of multiple CPUs so that processes can run concurrently. To use system scope, add the following to the .profile file of the user who starts the Manager process or else export the variable manually before starting GGSCI. 

AIXTHREAD_SCOPE=S
export AIXTHREAD_SCOPE
OUTQUEUESIZE n

Specifies the number of queue entries in the output queue of each producer Extract thread in an Oracle RAC cluster. Valid values are 8 to 65535. The default is 2048. The default should be adequate in most cases.

[PROCESSTHREADS SELECT thread_spec | PROCESSTHREADS EXCEPT thread_spec]

Specifies the Extract threads to be processed or to be excluded from processing. Valid values are:

  • A single thread ID, such as 1

  • A range, such as 1-5

Extract threads are mapped to redo threads. Caution: Excluding any of the Extract threads from being processed excludes that data from being synchronized with the target tables.

Primarily for use when Extract is in Archived Log Only mode (ALO).

[STACKSIZE bytes]

Specifies the stack size of each producer Extract thread in an Oracle RAC cluster. Valid values are a range of 65536 - 33554432; the default is 1048576.