select plan_name, sql_text, sql_handle, origin, 
optimizer_cost, enabled, fixed, accepted 
from dba_sql_plan_baselines
where sql_text like '%MERGE%ORDER_CORPORATE_INFO_TEMP%'

SYS_SQL_PLAN_f24b6a7a75820bb5
MERGE INTO ORDER_CORPORATE_INFO_HIST T USING ORDER_CORPORATE_INFO_TEMP S ON (T.C
SYS_SQL_cedef0a9f24b6a7a       AUTO-CAPTURE                3 YES NO  NO

SYS_SQL_PLAN_f24b6a7a6901a4b3
MERGE INTO ORDER_CORPORATE_INFO_HIST T USING ORDER_CORPORATE_INFO_TEMP S ON (T.C
SYS_SQL_cedef0a9f24b6a7a       AUTO-CAPTURE             9066 YES NO  NO

SQL> select value from v$parameter where name = 'optimizer_capture_sql_plan_baselines';

VALUE
-------
FALSE


SQL> select distinct(origin) from dba_sql_plan_baselines;

ORIGIN
--------------
AUTO-CAPTURE

SQL> select distinct(accepted) from dba_sql_plan_baselines;

ACC
---
YES
NO


select count(*) from dba_sql_plan_baselines where accepted = 'YES'
  COUNT(*)
----------
      1635


select count(*) from dba_sql_plan_baselines where accepted = 'NO'
  COUNT(*)
----------
      3886

select SIGNATURE, SQL_HANDLE, PLAN_NAME from dba_sql_plan_baselines where (SIGNATURE,CREATED) in (select SIGNATURE,min(CREATED) from dba_sql_plan_baselines group by SIGNATURE);