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@xxxxxxxxxxxxxxxxxxxxx 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

Other related posts: