RE: Millisecond timer in PL/SQL
- From: "Kennedy, Jim" <jim_kennedy@xxxxxxxxxx>
- To: <scott.hutchinson@xxxxxxxxxxxxxxxxxxxxx>, <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- Date: Fri, 30 Sep 2005 08:12:18 -0700
Would a call to an external proc work? How about a simple Java program
that returned what you are looking for? One would have to measure the
overhead of the call.
Jim
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
scott.hutchinson@xxxxxxxxxxxxxxxxxxxxx
Sent: Friday, September 30, 2005 8:10 AM
To: Thomas.Mercadante@xxxxxxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: Millisecond timer in PL/SQL
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
