FGA Policies Disable Plan Stability Baselines
(Doc ID 2272107.1)
Last updated on MARCH 05, 2021
Applies to:Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
This note tries to explain the interaction between FGA policies and Plan Stability Baselines.
- Enabling FGA policies on tables for which Plan Stability Baselines are already applied has an adverse effect on the baselines. The baselines are no longer used. This is the expected behavior.
- Trying to activate a new baseline for a query that accesses tables with FGA policies is also not functioning. This is the incorrect behavior that has been fixed.
See the attached file baselines_fga.sql for the testcase reproducing the above scenarios.
When trying to enable either feature (FGA/Baselines) in a situation when the other feature is already enabled.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document