SQL plan baselines created in spite of false optimizer_capture_sql_plan_baselines
Oracle 19.17.0.0.0, 2-node RAC on RHEL 7.9
We see SQL plan baselines being created
SQL> select plan_name, created, origin from dba_sql_plan_baselines where created>'30-MAR-23 01.00.00.000000 AM' order by 2; PLAN_NAME CREATED ORIGIN -------------------------------- ------------------------------ ----------------------------- SQL_PLAN_g8jq9twx5xv1aaec05c9c 30-MAR-23 03.00.37.235671 AM AUTO-CAPTURE SQL_PLAN_2vq9fhj375h999e3c1a58 30-MAR-23 06.40.09.322935 AM AUTO-CAPTURE SQL_PLAN_2hnx0f2f4admvd034c016 30-MAR-23 07.09.05.419048 AM AUTO-CAPTURE SQL_PLAN_1dyd0bcy4mu09b860ab39 30-MAR-23 07.10.31.859884 AM AUTO-CAPTURE SQL_PLAN_bbpfvmg0cbuf9049b3dec 30-MAR-23 07.45.38.716972 AM AUTO-CAPTURE SQL_PLAN_bw8m1g62xrz0556c551b1 30-MAR-23 07.45.38.813105 AM AUTO-CAPTURE SQL_PLAN_bs9y9hc5641dv7534c43b 30-MAR-23 08.56.18.918956 AM AUTO-CAPTURE SQL_PLAN_3avyy9fkph8k282d7f15a 30-MAR-23 10.10.27.320510 AM AUTO-CAPTURE SQL_PLAN_dt67gnm6747ngb61a3b19 30-MAR-23 11.00.38.225288 AM AUTO-CAPTURE ...
0