MAXTRANSMEM

Valid for

Extract

Description

Use MAXTRANSMEM to control the maximum amount of memory that can be allocated for a transaction. If a transaction exceeds the maximum memory value, then Extract only tracks the checkpoint of the begin transaction until the commit transaction is found. Once a commit is found, Extract returns and extracts data starting from the begin checkpoint.

As of Oracle GoldenGate for HP NonStop release 19.1.0.0.0, the native mode extract uses 64-bit extended segments instead of the C heap for storing transaction data. Extended segments are allocated and deallocated as needed.

Default

Native mode 500G

Syntax

MAXTRANSMEM <size>

<size>

The max number of megabytes or gigabytes to allow. You can use the suffix M for Megabytes or G for Gigabytes. With native mode extract there is no need to change the default as the default is the max.

The minimum value is 2000000.

The maximum value is 110M for mode.

The maximum value is 500G for native mode.

Example

MAXTRANSMEM 50M 
MAXTRANSMEM 256G