Parameters in this group configure user environments.
[User Environment] number of user connections = 40 stack size = DEFAULT stack guard size = DEFAULT permission cache entries = DEFAULT user log cache size = 65536 user log cache spinlock ratio = 1 max native threads per engine = DEFAULT messaging memory = DEFAULT enable real time messaging = DEFAULT histogram tuning factor = DEFAULT rtm thread idle wait period = DEFAULT
number of user connections = 40 This option sets the maximum number of user connections that can be connected to Adaptive Server at the same time. The default is 25.
user log cache size = 65536 This option specifies the size in bytes of each user’s log cache. The size of this private log cache is determined by the logical page size of the server. A large value of 65536 (65K) avoids having to write to the real log until this cache is full, which is more efficient when performing a lot of loads.
user log cache spinlock ratio = 1 For ASE with multiple engines, this option specifies the ratio of user log caches per user log cache spinlock. There is one user log cache for each configured user connection. A value of 1 reduces contention and locking of the real log.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
