Maximum percentage of a user’s temp memory that a persistent bit-vector object can pin.
0 – 100
40
DBA permissions are not required to set this option. Can be set temporary for an individual connection or for the PUBLIC group. Takes effect immediately.
BIT_VECTOR_PINNABLE_CACHE_PERCENT controls the percentage of a user’s temp memory allocation that any one persistent bit-vector object can pin in memory. It defaults to 40%, and should not generally be changed by users.
This option is primarily for use by Sybase Technical Support. If you change the value of BIT_VECTOR_PINNABLE_CACHE_PERCENT, do so with extreme caution; first analyze the effect on a wide variety of queries.