PREFETCH_BUFFER_PERCENT
Option
Specifies the percent of memory used for prefetching.
Allowed Values
0 – 100
Default
40
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.