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.
Remarks
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
Technical Support.