Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Server execution timing in pl/sql
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
![]() |
![]() |