DB time
Pradeep prajapati, December 08, 2017 - 11:28 am UTC
DB time is actual includes wait timing.
actual work time is cpu time if am not wrong.
last question need to cover i.e. how to find elapsed time for any specific sql query.
if in PLSQL any sql is problematic then how to find.
Thanks
Pradeep
December 13, 2017 - 1:57 am UTC
"actual work time is cpu time"
Really depends on your definition. For example I/O is "wait time" but I would still call that actual work.
"if in PLSQL any sql is problematic then how to find. "
I would start with v$sqlstats and/or AWR reports.