create or replace procedure parse1(s varchar2) is
 n int;
begin
   select/*+zz*/ count(*) into n from dual z where rownum=s;
   select/*+zz*/ count(*) into n from dual z where rownum=s;
   select/*+zz*/ count(*) into n from dual z where rownum=s;
end;
/
create or replace procedure parse2(i number) is
 n int;
begin
   select/*+zz*/ count(*) into n from dual z where rownum=i;
   select/*+zz*/ count(*) into n from dual z where rownum=i;
   select/*+zz*/ count(*) into n from dual z where rownum=i;
end;
/
begin
   parse1('1');
   parse2(1);
end;
/
select (select object_name
          from dba_objects
         where object_id = v.program_id) name,
       program_line# line,
       v.child_number,
       v.open_versions,
       v.executions,
       v.sql_text
from v$sql v
where sql_text like 'SELECT/*+zz*/%'
/
NAME             LINE CHILD_NUMBER OPEN_VERSIONS EXECUTIONS SQL_TEXT
---------- ---------- ------------ ------------- ---------- ------------------------------------------------------------
PARSE1              4            0             0          3 SELECT/*+zz*/ COUNT(*) FROM DUAL Z WHERE ROWNUM=:B1
PARSE1              4            1             1          3 SELECT/*+zz*/ COUNT(*) FROM DUAL Z WHERE ROWNUM=:B1

2 rows selected.