SQL> create table spm_test(id int);

Table created.

SQL>
SQL> sho parameter optimizer_capture

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
optimizer_capture_sql_plan_baselines boolean     FALSE
SQL> col sql_text for a35
SQL> col plan_name for a30
SQL> select sql_text, plan_name, origin, enabled, accepted
  2    from dba_sql_plan_baselines
  3   where signature = dbms_sqltune.sqltext_to_signature('select * from spm_test where id = 0');

no rows selected

SQL>
SQL> select * from spm_test where id = 0;

no rows selected

SQL>
SQL> var loaded number
SQL> set autop on
SQL> exec :loaded:=dbms_spm.load_plans_from_cursor_cache(dbms_sql_translator.sql_id('select * from spm_test where id = 0'))

PL/SQL procedure successfully completed.


    LOADED
----------
         1

SQL>
SQL> select sql_text, plan_name, origin, enabled, accepted
  2    from dba_sql_plan_baselines
  3   where signature = dbms_sqltune.sqltext_to_signature('select * from spm_test where id = 0');

SQL_TEXT                            PLAN_NAME                      ORIGIN                        ENA ACC
----------------------------------- ------------------------------ ----------------------------- --- ---
select * from spm_test where id = 0 SQL_PLAN_c266nn652fxk2f2fc655a MANUAL-LOAD-FROM-CURSOR-CACHE YES YES

SQL>
SQL> create index spm_test_i on spm_test(id);

Index created.

SQL>
SQL> select * from spm_test where id = 0;

no rows selected

SQL>
SQL> select sql_text, plan_name, origin, enabled, accepted
  2    from dba_sql_plan_baselines
  3   where signature = dbms_sqltune.sqltext_to_signature('select * from spm_test where id = 0');

SQL_TEXT                            PLAN_NAME                      ORIGIN                        ENA ACC
----------------------------------- ------------------------------ ----------------------------- --- ---
select * from spm_test where id = 0 SQL_PLAN_c266nn652fxk2a7f4712e AUTO-CAPTURE                  YES NO
select * from spm_test where id = 0 SQL_PLAN_c266nn652fxk2f2fc655a MANUAL-LOAD-FROM-CURSOR-CACHE YES YES