Oracle DBA

Performance Diagnostics, AWR & Monitoring

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.

This is 11 of 23 free samples for Oracle DBA.

More Oracle DBA topic samples