Hi Team,
OS:RHEL
DB:11gR2
I have generated a AWR for half an hour and it shows the Elapsed time: 30 mins and DB time as: 47,251 minutes.
We also checked the top sql in the SQL Ordered by elapsed time section of the AWR and found that the total Elapsed time for 306051 executions is 74245 seconds.
If we convert the total elapsed time in seconds to hours, it is coming to be 20 hours. So the question arises that if the the total duration is only 30 mins then how come the top query is taking 20 hours.
We do understand that the the total duration of the AWR is not same as that of DB time, DB time depends on so many factors like CPU cores, IOs but we are unable to correlate the duration and DB time.
Thanks