get_time - negative time intervals ???

From: mminfo <mminfo_at_email.msn.com>
Date: Mon, 13 Sep 1999 13:46:33 -0400
Message-ID: <OIWmEBh$#GA.280@cpmsnbbsa02>

We have a procedure that tracks the execution time of SPs by taking the difference between the SPs start and end times, as reported by get_time (dbms_utility).

The problem we have been having is that this procedure is occaisionally netting us negative time intervals - i.e. time(END of SP) - time(START of SP) < 0!

The problem is (seemingly) intermittent - it has happened more than once, however. There seems to be no correlation with time of day (incl. noon and midnight), nor with any given SP, and we are certain that at least some of the SPs take more than 1/100 th of a second to execute, so the probability of some kind of rounding error seems small.

Any explanations or tips would be very much appreciated.

Thanks for your time,
Mark Received on Mon Sep 13 1999 - 12:46:33 CDT