Re: Millisecond timer in PL/SQL

I think you can use the trick of defining a view on sys.x$dual and doing the select from that view.
Accessing x$dual does not use buffer gets so maybe there will not be enqueue.

Adar Yechiel
Rechovot, Israel

scott.hutchinson_at_interact-analysis.com wrote:

>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".
>
>

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