Hi all,
I would like to get the total execution time and the cpu time of a query
execution.
For that purpose, I think SNAP_GET_DYN_SQL is the correct table function.
But SNAPSHOT_DYN_SQL gives me similar results.
For finding out, if these table functions do what I would like to have, I
have some questions on them:
- Is TOTAL_EXEC_TIME_MS the total execution time in milliseconds, whereas
TOTAL_EXEC_TIME is the total execution time with an abstract unit?
- Is the TOTAL_USR_TIME_MS+TOTAL_SYS_TIME_MS of SNAP_GET_DYN_SQL the total
cpu time for that statement? Since I also needed the physical and logical
reads of the execution of my statements, I used SNAP_GET_DYN_SQL instead of
SNAPSHOT_DYN_SQL (where I would have TOTAL_SYS_CPU_TIME and
TOTAL_USR_CPU_TIME).
Thanks in advance for help.
Cheers,
Ina