Deriving a minimum for decision-support memory

In the first part of the algorithm that the database server uses to derive the new value for the DS_TOTAL_MEMORY configuration parameter, the database server establishes a minimum amount for decision-support memory.

When you assign a value to the DS_MAX_QUERIES configuration parameter, the database server sets the minimum amount of decision-support memory according to the following formula:
min_ds_total_memory = DS_MAX_QUERIES * 128 kilobytes
When you do not assign a value to the DS_MAX_QUERIES configuration parameter, the database server uses the following formula instead, which is based on the value of information in the VPCLASS configuration parameter:
min_ds_total_memory = NUMBER_CPUVPS * 2 * 128 kilobytes

Copyright© 2018 HCL Technologies Limited