BIT_VECTOR_PINNABLE_CACHE_PERCENT option

Function

Maximum percentage of a user’s temp memory that a persistent bit-vector object can pin.

Allowed values

0 – 100

Default

40

Scope

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.

Description

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.

See also

“HASH_PINNABLE_CACHE_PERCENT option”.

“SORT_PINNABLE_CACHE_PERCENT option”.