Re: Performance Measures?

From: Roger Snowden <rsnowden_at_supergeek.com>
Date: 1998/02/12
Message-ID: <01bd37f6$6dd68620$096fc589@WS1009.labinterlink.com>#1/1

In SQL*PLUS, set timing on. This gives back the execution time for each operation. Pretty handy.

Roger

Jeff Wyant <wyant_at_wcoil.com> wrote in article <6br88o$svr$1_at_208.10.2.116>...
> I've been trying to time my stored procedures in Oracle by getting the
> date and time at the start of the stored procedure and then again at the
> end of the stored procedure. The problem I've been running into is that
> the Oracle sysdate only goes to the second and I need to measure in
> milliseconds. Does anyone have a way to perform this type of
> measurement?
> Thanks.
>
>
Received on Thu Feb 12 1998 - 00:00:00 CST