Re: timer function with PL/SQL?

From: Peter Schneider <peter.schneider_at_okay.net>
Date: Fri, 10 Jul 1998 13:10:50 GMT
Message-ID: <6o5427$qm0$1@trader.ipf.de>

On Fri, 10 Jul 1998 11:32:26 +0200, Bram Stieperaere <bse_at_N_O_S_P_A_Msodexho-pass.be> wrote:

>Hi All,
>
>how can I measure the execution time of a PL/SQL function with the
>highest possible precision? sysdate works only with seconds. Can I
>access the OS time?
>
>Thanks.

Hi Bram,

have a look at the DBMS_UTILITY.GET_TIME function. It returns the time in hundreds of a second since the DB is up. Works nice for PL/SQL performance testing.

HTH,
Peter

--
Peter Schneider
peter.schneider_at_okay.net Received on Fri Jul 10 1998 - 08:10:50 CDT