PREFETCH_BUFFER_PERCENT option

Function

Specifies the percent of memory used for prefetching.

Allowed values

0 – 100

Default

40

Scope

Can be set only for the PUBLIC group. DBA authority is required to set the option. Shut down and restart the database server to have the change take effect.

Description

PREFETCH_BUFFER_PERCENT is an alternative to PREFETCH_BUFFER_LIMIT, as it specifies the percentage of cache available for use in prefetching.

Do not set this option unless advised to do so by Sybase Technical Support.