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: Oracle Timing

Re: Oracle Timing

From: Jurij Modic <jmodic_at_src.si>
Date: Sun, 14 Feb 1999 11:17:40 GMT
Message-ID: <36c6b0c4.2544821@news.arnes.si>


On Sun, 14 Feb 1999 02:27:11 GMT, "Mike Rose" <mmrose_at_home.com> wrote:

>I seem to have forgotten the units returned by the Oracle SQL*Plus Set
>Timing command. I just ran the following in SQL*Plus and I need to know what
>the "real: 8901750" means in hours/minutes/seconds/milliseconds or whatever.
> ...[SNIP]...
> real: 8901750

It's in milliseconds, so your procedure took for about two and a half hours to complete.

HTH,
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)



The above opinions are mine and do not represent any official standpoints of my employer Received on Sun Feb 14 1999 - 05:17:40 CST

Original text of this message

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