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: Time a sql statement

Re: Time a sql statement

From: Paul Quenneville <paulq_at_rogers.com>
Date: Thu, 28 Feb 2002 04:40:13 GMT
Message-ID: <Nwif8.46$gX1.25@news1.bloor.is> 





Oracle Dba hmmm...



set timing on



"godmann" <allanwtham_at_yahoo.com> wrote in message
news:95cd51c.0202271829.2645ecf6_at_posting.google.com...


> Hi there,

>

>    In sqlplus, how do you go about to time a sql statement? I want

> to know how many msec it takes for a particular *doubtful* statement.

>

> Allan W. Tham

> Oracle DBA

Received on Wed Feb 27 2002 - 22:40:13 CST












Original text of this message













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