Re: elapsed time in millisecond

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 Tue Nov 16 1999 - 04:46:20 CST