Identify SQLID

@/u01/dba/orafindsqlid.sql

To find your current SID use...

SELECT sid FROM v$mystat WHERE ROWNUM=1; 

or 

SELECT sys_context('userenv','sid') FROM dual;

SELECT sql_id,

       child_number,

       sql_text

  FROM v$sql

 WHERE sql_text LIKE '%mytable%';

SQLID History

@/u01/dba/orasqlidhistory.sql

Bibliography