try
set timing on
before running the query.
cot_r <bvanespen_at_yahoo.com> wrote in message
news:DRgs8.5829$Ze.1927_at_afrodite.telenet-ops.be...
> 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/vanespen
>
>
>
Received on Mon Apr 08 2002 - 09:24:22 CDT
