FGA Policies Disable Plan Stability Baselines
Last updated on MAY 31, 2017
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms