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