How to find the number of seconds (or milliseconds) elapsed after a query?
Dear all,
I have found an interesting tutorial about Oracle analytic functions on orafaq web site that I share with you:
hxxp://www.orafaq.com/node/55
I was curious to compare the performance of each query using analytic functions with the traditional methods (GROUP BY and self joins).
Is there any command to write in SQL*Plus in order to see the total amount of seconds or milliseconds elapsed once a query has been terminated?
Thanks in advance,
:)