Re: Performance Measures?

Jeff Wyant wrote:
>
> 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.

dbms_utility.get_time (100's of a second since db started)

-- 
==========================================
Connor McDonald
BHP Information Technology
Perth, Western Australia
"These views mine not BHP..etc etc"

"The only difference between me and a madman is that I am not mad."