BIT_VECTOR_PINNABLE_CACHE_PERCENT Option

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

Allowed Values

0 – 100

Default

40

Scope

Option can be set at the database (PUBLIC) or user level. When set at the database level, the value becomes the default for any new user, but has no impact on existing users. When set at the user level, overrides the PUBLIC value for that user only. No system privilege is required to set option for self. System privilege is required to set at database level or at user level for any user other than self.

Requires the SET ANY PUBLIC OPTION system privilege to set this option. Can be set temporary for an individual connection or for the PUBLIC role. Takes effect immediately.

Remarks

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 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.

Related reference
HASH_PINNABLE_CACHE_PERCENT Option
SORT_PINNABLE_CACHE_PERCENT Option