Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to find the number of seconds (or milliseconds) elapsed after a query?

dariyooshApr 7 2009 — edited Apr 7 2009
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,
:)
This post has been answered by 21205 on Apr 7 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 5 2009
Added on Apr 7 2009
11 comments
804 views