Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Topmost query evenif the number of executions is 0

santiNov 1 2010 — edited Nov 1 2010
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,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 29 2010
Added on Nov 1 2010
3 comments
272 views