By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,586 Members | 2,347 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,586 IT Pros & Developers. It's quick & easy.

SNAP_GET_DYN_SQL

P: n/a
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
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.