Re: SQLPLUS: set timing on

From: Adrian <adrian.shepherd_at_btinternet.com>
Date: Tue, 23 Feb 1999 21:09:00 -0000
Message-ID: <7av59r$6nu$1@mendelevium.btinternet.com>

HH:MM:SS.hundredths of a second format on the server , 00:00:00.10.00 is 10 seconds

milliseconds format on the client, 1200 ms = 1.2s

P.S.
If they were real times given by you, take into account that the select result blocks would have been cached in the SGA and would have reduced the second select by a factor of nearly ten in this case (no I/O)...

>When you set timing on in SQL*Plus and execute a query, the time it
>takes to execute is given.
>
>What is this time reported in? milliseconds
>
>In SQL*Plus on server the format returned is: 00.00.00.00
>In SQL*Plus from a PC the format returned is: real: 0000
>
>So what would 00.00.10.00 be?
>So what would 1200 be?
>
>TIA,
>
>Joe
Received on Tue Feb 23 1999 - 15:09:00 CST