2.339 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 Database 23ai.