Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E41527-12
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

INMEMORY_MAX_POPULATE_SERVERS

Property Description
Parameter type Integer
Default value Half the effective CPU thread count or the PGA_AGGREGATE_TARGET value divided by 512M, whichever is less.
Modifiable ALTER SYSTEM
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.

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.

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:

This initialization parameter is available starting with Oracle Database 12c Release 1 (12.1.0.2).

See Also: