1.149 INMEMORY_MAX_POPULATE_SERVERS
INMEMORY_MAX_POPULATE_SERVERS
specifies the maximum number of background populate servers to use for In-Memory Column Store (IM column store) population, so that these servers do not overload the rest of the system.
Property | Description |
---|---|
Parameter type |
Integer |
Default value |
Half of the value of See the "CPU_COUNT" description for information about how |
Modifiable |
|
Modifiable in a PDB |
No |
Range of values |
0 to a value based on the number of cores in the system. |
Basic |
No |
Oracle RAC |
All instances should use the same value. |
This parameter has meaning only if the INMEMORY_SIZE
parameter is also set to a positive value.
The value to use for this parameter depends on the number of cores in the system. A certain percentage of CPU should be allocated for in-memory background population, and this parameter should be set accordingly. You can also set this parameter to 0
to temporarily disable populate tasks on the system from executing.
Note:
Be careful not to set the value of this parameter too high. If it is set close to the number of cores or higher, no CPU could be left for the rest of the system to run.
Note:
The IM column store is not populated if this parameter is set to 0.
See Also:
-
Oracle Database In-Memory Guide for an introduction to the IM column store
-
Oracle Database In-Memory Guide for more information about the IM column store