Hi,
I saw following AWR report:
SQL ordered by Elapsed Time DB/Inst: RPAY/rpay Snaps: 13002-13017
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> % Total DB Time is the Elapsed Time of the SQL statement divided
into the Total Database Time multiplied by 100
Elapsed CPU Elap per % Total
Time (s) Time (s) Executions Exec (s) DB Time SQL Id
---------- ---------- ------------ ---------- ------- -------------
52,758 22,485 0 N/A 57.7 5anp47ckk98v7
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN :
= FALSE; BEGIN data1; :mydate := next_date; IF broken THEN :b := 1; ELSE :
b := 0; END IF; END;
Please notice the number of executions. Evenif the number of executions is 0, the query comes in topmost slot in AWR report, why?
Regards,