sql plan baseline is getting used even if parsing_schema is different than sql executing schema
Hi
We had RAC db of version 11.2.0.4 on Linux. Recently we had performance issue and to fix it, we created sql plan baseline.
As we can see in below output, parsing_schema_name in dba_sql_plan_baseline shows SYSTEM whereas sql is being executed from another application schema.
When we checked gv$sql, we can see sql plan baseline is being used and its peeking correct plan. Application is running fine after this change and never had issue.
My question is how sql plan baseline is getting used even if parsing_schema_name in dba_sql_plan_baseline is SYSTEM and sql being executed from another schema?