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.