Oracle查看收集procedure中每行执行sql执行的性能;

eclare

begin

dbms_profiler.start_profiler(‘test_START_RUN_MONITOR’);

–需要进行验证的包方法
ies_monitor_pkg.START_RUN_MONITOR;
dbms_profiler.stop_profiler;

end;

select * from plsql_profiler_runs;

select * from plsql_profiler_data d where d.runid = 3;