Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Server execution timing in pl/sql

Server execution timing in pl/sql

From: Jeremy Ovenden <jovenden_at_hazelweb.co.uk>
Date: Thu, 1 Jul 1999 15:43:29 +0100
Message-ID: <7lfush$mm$1@gxsn.com>


Say I have a pl/sql procedure, in SQLPLUS I can SET TIMING ON and when the procedure runs, it wil display something like 'real: 231' which means 231 milliseconds execution time. I would like to be able to get this level of accuracy within a plsql programso that it can record/report on this data.

So far I have only worked out how to get timings to the nearest second (subtracting start datetime from end datetime) e.g. elapsed_time := ((enddate - startdate) * 86400)

which yields the result in seconds.

How can I get down to milliseconds?

TIA Jeremy Received on Thu Jul 01 1999 - 09:43:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US