查看Oralce存储过程执行计划

–调用存储过程
declare
l_return_code varchar2(1);
l_return_message varchar2(2000);
begin
sys.dbms_profiler.start_profiler(‘20210917’);
my_pkg.main(‘10’,l_return_code,l_return_message);
commit;
sys.dbms_profiler.stop_profiler;
exception when others then
dbms_output.put_line(‘error’);
end;

–查看存储过程执行计划
select u.unit_name
,round(d.total_time/1e9) time_ms
,round(d.total_time*100/sum(d.total_time) over(),2) pct_time
,d.total_occur as execs
,substr(ltrim(a.text),1,1000) as text
,dense_rank() over (order by d.total_time desc) ranking
from plsql_profiler_runs r
,plsql_profiler_units u
,plsql_profiler_data d
,all_source a
where r.runid = u.runid
and u.runid=d.runid
and u.unit_numbee = d.unit_number
and a.owner =u.unit_owner
and a.type =u.unit_type
and a.name=u.unit_name
and a.line=d.line#
and r.run_comment = ‘20210917’;