trying to understand an awr report

Hi,

    I'm trying to understand some of the information in an AWR report.

    Specifically,

• The "executions" column and "Elap per exec" , in several cases is empty, but shows "DB time", "Elapsed TIme", and "CPU time". Can anyone explain that ?
• 1 transactions shows 5.509,111 executions but no "elap per exec".

    These numbers are from 9 hours of snapshots.

Solaris 10, RDBMS, and RAC 10.2.0.4.

    Your comments are appreciated.

        thanks

        ed    

  a.. Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.   b.. % Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100

      Elapsed Time (s) CPU Time (s) Executions  Elap per Exec (s)  % Total DB Time SQL Id SQL Module SQL Text 
      16,520 16,518 19,286 0.86 4.03 d4fdhcjs2vndp  SELECT C603210194 FROM T2245 W... 
      12,041 12,023     2.94 3ycgb4yb5svuc    SELECT T954.C1, C1000000161 FR... 
      11,554 11,528     2.82 00yn69r0dguk6    SELECT T954.C1, C1000000161 FR... 
      11,441 9,214 19,384 0.59 2.79 41cnaprwx32n6  SELECT cdintegrationid FROM bm... 
      11,356 11,337     2.77 gvtgqv0gqx6nn    SELECT T954.C1, C1000000161 FR... 
      7,877 7,875     1.92 fyb6g4640yaag    SELECT T954.C1, C1000000161 FR... 
      7,465 1 5 1492.91 1.82 cmdx8dhbwnncy  DELETE FROM T129 WHERE C1 = :"... 
      6,731 6,728     1.64 0pks9t80ukx0s    SELECT T936.C1 FROM T936 WHERE... 
      5,947 2,982 1,308 4.55 1.45 4rkq5f7cx0aau   SELECT T1346.C1 FROM T1346 WHE... 
      5,134 5,122 134 38.31 1.25 9g2vbj6d66ssr  SELECT T954.C1, C1000000161, C... 
      4,990 4,843 5,509,111 0.00 1.22 9dqj7wx3yc9yq  SELECT fieldId, vuiId, propSho... 
      4,807 4,807 32 150.23 1.17 0xjy5qb0z6s1w  SELECT T727.C1, C10000001, C30... 

--
http://www.freelists.org/webpage/oracle-l