To maximize memory available for individual OLTP transactions instead of for decision support and parallel processing in queries, consider the following configuration adjustments:
Queries that require large amounts of memory cannot be allocated more memory than the value that you specify in the DS_TOTAL_MEMORY configuration parameter.
The DS_MAX_QUERIES configuration parameter specifies the maximum number of memory-consuming queries that can execute concurrently.
When you set MAX_PDQPRIORITY to 0, the amount of memory available for parallel execution is limited to 128 kilobytes for each SQL operator instance.
When OLTP applications build indexes, however, set PDQPRIORITY to a higher value or allow the optimizer to allocate memory appropriately for the index build, as described in Enabling Optimizer-Determined Memory Allocation.
When you reduce the value of MAX_PDQPRIORITY or DS_TOTAL_MEMORY, response for large queries that require parallel processing is slow.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]