When the DS_TOTAL_MEMORY configuration parameter is not set

When the DS_TOTAL_MEMORY configuration parameter is not set, the database server uses other sources to calculate a value for the amount of decision-support memory.

When SHMTOTAL is set, the database server uses the following formula to calculate the amount of decision-support memory:
decision_support_memory = SHMTOTAL -
                  nondecision_support_memory
When the database server finds that you did not set SHMTOTAL, it sets decision-support memory as in the following example:
decision_support_memory = min_ds_total_memory

For a description of the variable min_ds_total_memory, see Deriving a minimum for decision-support memory.


Copyright© 2019 HCL Technologies Limited