RE: Millisecond timer in PL/SQL

  • To: <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>, <scott.hutchinson@xxxxxxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 30 Sep 2005 11:02:24 -0400

It does the same as:

Select HSECS from v$timer;

Also, I don't understand, how milliseconds is "more granular" than
HSECS? 

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mercadante, Thomas F
(LABOR)
Sent: Friday, September 30, 2005 10:56 AM
To: scott.hutchinson@xxxxxxxxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Millisecond timer in PL/SQL

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

--
//www.freelists.org/webpage/oracle-l

Other related posts: