How can we translate elapsed time in AWR Report.
189223May 21 2008 — edited May 21 2008Hi,
Would you please let us know
How can we translate elapsed time-440,945(s), which looks unrealistic if we convert them to minutes?.
Your early response is really appreciated.
SQL ordered by Elapsed Time
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 Time (s) CPU Time (s) Executions Elap per Exec (s) % Total DB Time SQL Id SQL Module SQL Text
440,945 4 364 1211.39 167.64 ff3tw948tx0c6 JDBC Thin Client DELETE FUND_RESULT_STAT_EXT WH...
77,157 15 103 749.10 29.33 4v6tkhufa6hk0 JDBC Thin Client DELETE FUND_RESULT_STAT_EXT WH...