PL/SQL (MOSC)

MOSC Banner

PL/SQL in AWR or Statspack

in PL/SQL (MOSC) 1 commentAnswered ✓

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?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center