Search notes:

DBMS_SQL_TRANSLATOR.SQL_ID

select
   dbms_sql_translator.sql_id('select * from user_objects')
from
   dual;
--
-- 0d7hz8d1y5vw6

Check if SQL statement is in the library cache:

select *
from
   v$sql
where
   sql_id = '0d7hz8d1y5vw6';

See also