查看某条sql的解析次数和执行次数 绑定变量对比

create or replace procedure proc1
as
begin
          for i in 1..100000
          loop
          execute immediate  
          'insert into t values('||i||')';
           commit;
           end loop;
end;

/

set timing on;

execute proc1;

select t.sql_text,t.sql_id,t.parse_calls,t.executions from v$sql t where sql_text like 'insert into t%';

create or replace procedure proc2
as
begin
          for i in 1..100000
          loop
          execute immediate  
          'insert into t values(:x)' using i;
           commit;
           end loop;
end;

/

execute proc2;

出自 《收获，不止oracle》