Adaptive Server allows you to allocate total physical memory dynamically. Many of the configuration parameters that consume memory were static in pre-12.5 versions of Adaptive Server, and the server needed to be restarted when more memory was required. For example, when you changed the number of user connections, you had to restart the server for this to take effect. Many of the configuration parameter that effect memory are now dynamic, and the server does not have to be restarted for them to take effect. For a full list of the configuration parameters that have changed from static to dynamic, see Table 10-1.
Configuration parameter |
Configuration parameter |
|---|---|
addition network memory |
number of pre-allocated extents |
audit queue size |
number of user connections |
cpu grace time |
number of worker processes |
deadlock pipe max messages |
open index hash spinlock ratio |
default database size |
open index spinlock ratio |
default fill factor percent |
open object spinlock ratio |
disk i/o structures |
partition groups |
errorlog pipe max messages |
partition spinlock ratio |
max cis remore connections |
permission cache entries |
memory per worker process |
plan text pipe max messages |
number of alarms |
print recovery information |
number of aux scan descriptors |
process wait events |
number of devices |
size of global fixed heap |
number of dtx participants |
size of process object heap |
number of java sockets |
size of shared class heap |
number of large i/o buffers |
size of unilib cache |
number of locks |
sql text pipe max messages |
number of mailboxes |
statement pipe max messages |
number of messages |
tape retention in days |
number of open databases |
time slice |
number of open indexes |
user log cache spinlock ratio |
number of open objects |
