Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: HELP! Execution time of Select stmt
Put the following code in a file, and run it in sql*plus
you should see 2 numbers on output.
The difference of which is the elapsed time to the 1/100 of a second.
"Ho" <kowho_at_singnet.com.sg> wrote in message
news:9q2ftd$b3e$1_at_coco.singnet.com.sg...
>
> How to determine the execution time of a SELECT statement in order to
> fine tune the SELECT stmt ?
>
> Many thanks for your help in advance.
>
>
Received on Thu Oct 11 2001 - 00:25:08 CDT