Hi.. again, I feel stupid. But I Googled for this info, and could not find
it (and I call myself the Goddess of Google, and with good reason...)
I wish to find a way to measure the CPU time used by any given query (or
set of queries).
I could not find any information on how to do this...
Is there some secret internal table (like the V$ virtual tables in Oracle)
that contains this info?
I'd love to find a V$CPUTIME table or something, so I could best optimize
my SQL...
I don't want to have to do it the inefficient way... e.g. by running the
same group of queries 1000 times or so several times, and averaging the
times...
--
J e s s i c a L e a h B l a n k