Re: Substracting two timestamp values

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1997/08/19
Message-ID: <33fbfd90.34831444@newshost>#1/1

To get hundred'ths of seconds for timings, use dbms_utility.get_time. For example:

   start_time := dbms_utility.get_time;
   f(x);
   stop_time := dbms_utility.get_time;

   htp.p( 'The operation took '|| (stop_time-start_time)/100 ||' seconds...' );

On Mon, 18 Aug 1997 19:36:20 -0600, Jesper Brynaa <jesper_at_cti.dtu.dk> wrote:

>Even more thanks- It was almost what i needed to!
>
>
>But does anyone know how to extract Time intervals less than one
>second?
>
>It is for use in comparing execution times of different
>implementations of a
>specific search.
>
>I use:
> htp.p(to_char( to_date( to_char( 86400 * ( time_stop - time_start
>),'99999' ),
>'SSSSS'), '"The operation took " SS " seconds"' )||htf.br);
>
>My masters final includes a section about optimizing, and comparing
>search
>strategies. Since I work on a very limited data volume, a more precise
>time
>would be very useful.
>
>Regards
>Jesper Brynaa
>Student at Technical University of Denmark
>
>-------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD

http://govt.us.oracle.com/ -- downloadable utilities

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Aug 19 1997 - 00:00:00 CDT