Database Tuning (MOSC)

MOSC Banner

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
...

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center