Re: Oracle Timing

From: <milagre_at_softdes.com.br>
Date: Mon, 15 Feb 1999 03:02:21 GMT
Message-ID: <7a82nq$hbs$1@nnrp1.dejanews.com>

Hello Mike Rose,

It is milliseconds.

bye

In article <3wqx2.2787$0p5.1811_at_news.rdc1.md.home.com>, "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.
>
> TIA
>
> Mike Rose
>
> SQL/orc1>Set Timing On
> SQL/orc1>Begin LOAD_DEALER_REPORTS; END;
> 2
> 2
> 2
>
> SQL/orc1>l
> 1* Begin LOAD_DEALER_REPORTS; END;
> SQL/orc1>/
>
> PL/SQL procedure successfully completed.
>
> real: 8901750
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sun Feb 14 1999 - 21:02:21 CST