Re: elapsed time in millisecond

Don't forget the underlying system should provide timings up to 1/1000 of a second (and not simulate it ).

Anjo.

Joerg Lanzinger wrote:

> Shure. There are various way to achieve this: I simply "forwarded" the output of the standard C gettime-function as a
> string.
> I wrote the procedures for Oracle8i on Solaris and Linux (I won't be able to help you much with the NT stuff :-( ).
> Please contact me by email if interested in the code.
> May I know what you're trying to measure?
>
> Bis denn
> Jörg
>
> Norris schrieb:
>
> > May I know how to call the external procedure inside PL/SQL stored procedure? Also, how to store the timestamp data?
> >
> > In comp.databases.oracle.server Joerg Lanzinger <joerg_at_lanzinger.de> wrote:
> > > Hi,
> >
> > > I faced the same problem, and all I could think of was writting an external C-procedure
> > > reading out system ticks. Of course this introduces some measurement flaws through the
> > > calling overhead, but this overhead should remain constant.
> >
> > > HTH
> > > Jörg
> >
> > > Norris schrieb:
> >
> > >> How can I get the elasped time in millisecond between start and end time interval ?
Received on Thu Nov 25 1999 - 03:31:18 CST