Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> how can see the amount of cpu a query uses?
Hello, thx for reading this!
I use a simple query: select count(*) from Person where id between 250000 and 600000;
what i would like to know is: elpased CPU time for this query.
ps. if i set auto trace in pl/sql i get no info about cpu.
thx
-- Outgoing mail is certified Virus Free. NAV HomePage: freesco_ linux router http://users.pandora.be/vanespenReceived on Mon Apr 08 2002 - 08:23:47 CDT