Oracle 如何找到PL/SQL的sql_id

create or replace procedure p1 ( p int ) as
begin
  null;
end p1;
/

begin 
  p1(1);
end;
/

call p1(1);

exec p1(1);

select sql_id, sql_text from v$sql
where  upper(sql_text) like '%P1(1)%'
and    sql_text not like '%not this%';

SQL_ID          SQL_TEXT              
curcusf2wkc2p   begin   p1(1); end;   
93rz7mjcffpf3   BEGIN p1(1); END;     
1csakzn21fu7g   call p1(1)  

create or replace procedure p2 ( p int ) as
begin
  null;
end p2;
/

create or replace procedure p1 ( p int ) as
begin
  p2(p);
end p1;
/

exec p1(1);

select sql_id, sql_text from v$sql
where  upper(sql_text) like '%P2(%)%';

SQL_ID          SQL_TEXT                                                                   
34wxm6wdmr5nh   select sql_id, sql_text from v$sql where  upper(sql_text) like '%P2(%)%'