RESULT_CACHE_AUTO_BLOCKLIST

Use RESULT_CACHE_AUTO_BLOCKLIST to enable or disable adaptive result cache object exclusion.

Property Description
Parameter type String
Syntax RESULT_CACHE_AUTO_BLOCKLIST = { OFF | ON }
Default value ON
Modifiable ALTER SYSTEM
Modifiable in a PDB Yes
Basic No
Oracle RAC Different instances can use different values.

When this parameter is set to ON, adaptive result cache object exclusion is enabled.

When this parameter is set to OFF, adaptive result cache object exclusion is disabled.

Note: This parameter is available starting with Oracle AI Database 26ai.