PL/SQL in AWR or Statspack
The following is from a Statspack report:
===
Elapsed Elap per CPU Old
Time (s) Executions Exec (s) %Total Time (s) Physical Reads Hash Value
---------- ------------ ---------- ------ ---------- --------------- ----------
15910.16 12,235 1.30 13.4 12557.43 4,854,471 1352090743
Module: BC_Onsite.API.dll
Begin DONOR_QUESTIONNAIRE.CALC_QTYPE(donor_id_in=>:v0, coll_date
_in=>:v1, don_type_in=>:v2, qtype_out=>:v3, comments_out=>:v4, r
eset_flag_out=>:v5, err_out=>:v6); End;
===
My interpretation is that the procedure CALC_QTYPE generated the statistics shown.
There are 20+ SELECT statements inside that procedure.
Is there a way to get more/better detail?