Thomas, Unfortunatetly this only goes to 100th's of a second (same result as SELECT HSECS FROM V$TIMER). I'm after milliseconds. Thanks, Scott. Quoting "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>: > Scott, > > How about: > > select dbms_utility.get_time from dual? > > > > function get_time return number; > -- Find out the current time in 100th's of a second. > -- Output argukments: > -- get_time > -- The time is the number of 100th's of a second from some > -- arbitrary epoch. > > > > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of > scott.hutchinson@xxxxxxxxxxxxxxxxxxxxx > Sent: Friday, September 30, 2005 10:31 AM > To: oracle-l@xxxxxxxxxxxxx > Subject: Millisecond timer in PL/SQL > > All, > > I'm looking for a way to measure the elapsed time (in milliseconds) of > executing a bunch of functions within a PL/SQL package. I've written a > "timer" > function that records this by using SYSTIMESTAMP, however is causes the > sessions to spend a significant amount of time waiting on "cache buffers > > chains". > > Coding "w_date := SYSTIMESTAMP;" will result in a recursive "SELECT > SYSTIMESTAMP FROM DUAL", and this is the sql being executed by sessions > waiting > on this latch (from v$session_wait and v$sqlarea). > > Does anyone have suggestions for ways that I can improve this? > > I have 50 concurrent sessions (batch jobs) running this, and each will > call > the "timer" function about 60 times per second. Originally I used > V$TIMER, > however the HSECS from this was not granular enough. > > Thanks, > > Scott Hutchinson > Interact Analysis Ltd > > ::This message sent using the free Web Mail service from > http://TheName.co.uk > -- > //www.freelists.org/webpage/oracle-l > -- > //www.freelists.org/webpage/oracle-l > ::This message sent using the free Web Mail service from http://TheName.co.uk -- //www.freelists.org/webpage/oracle-l