Question
Database time versus elapsed time: what does each measure during diagnosis?
Answer
Database time aggregates active-session CPU and non-idle wait time; elapsed time is wall-clock duration for one request. Use database time to rank workload demand and elapsed time to assess user experience.