Specifies the percent of memory used for prefetching.
Scope
Option can be set at the database (PUBLIC) level
only.
Requires the SET ANY SYSTEM OPTION system
privilege to set this option. You must shut down
the database and restart it for the change to 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.