SELECT SQL_HANDLE, SQL_TEXT, PLAN_NAME, ORIGIN,
ENABLED, ACCEPTED
FROM DBA_SQL_PLAN_BASELINES
WHERE SQL_TEXT LIKE '%id=1000%';


SQL_HANDLE            SQL_TEXT                                         PLAN_NAME                     ORIGIN        ENA ACC
------------------------- -------------------------------------------------- ---------------------------------------- -------------- --- ---
SQL_a6b12c50dcd955b1 select /*+ id=1000 */ name from EMP where id=1000 SQL_PLAN_adc9ca3fdkpdjd8a279cc AUTO-CAPTURE YES NO
SQL_a6b12c50dcd955b1 select /*+ id=1000 */ name from EMP where id=1000 SQL_PLAN_adc9ca3fdkpdjea3b638c MANUAL-LOAD  YES YES