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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Timing Statistics

Re: Timing Statistics

From: John Verhoeven <johnv_at_acix.DIALix.oz.au>
Date: 1997/06/18
Message-ID: <johnv.0aw1@acix.DIALix.oz.au>#1/1

In article dated Wed, 11 Jun 1997 19:16:03 GMT, Joost Ouwerkerk (owrkrj_at_mailhub.sickkids.on.ca) wrote:
> In SQL*Plus 3.1 I can get a rough idea of how well my SQL script is
> performing by means of the SET TIMING ON command. Is SQL*Plus
> returning this or is it coming from the database server? And in what
> units is this number?

From my experience it seems to be elapsed time (wall clock) time.

-- 
 _--_|\  John Verhoeven           Unix / Database Administrator Westrail
/      \              johnv_at_DIALix.oz.au / jverhoeven_at_westrail.wa.gov.au
*_.--._/
      v   "Smile! things could be worse... So I did... and they were..."
Received on Wed Jun 18 1997 - 00:00:00 CDT

Original text of this message

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