Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: **Performance of queries
Sybrand Bakker wrote in message
<924582996.5679.0.muttley.d4ee154e_at_news.demon.nl>...
>Hi Haruka,
>
>Two methods to do this:
>in sqlplus 3.3 and beyond
>use :
>set autotrace on explain stat
Haruka,
You can also use this set statement in sqlplus:
set timing on
This will give you exactly elapsed time in HH:MI:SS.msec format. Received on Tue Apr 20 1999 - 07:56:47 CDT
![]() |
![]() |