Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: **Performance of queries

Re: **Performance of queries

From: Ilja Anikushin <aiv_at_strogino.ru>
Date: Tue, 20 Apr 1999 12:56:47 -0000
Message-ID: <7fhfh6$ict$1@ns.mtu.ru>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US