Re: Can someone briefly refresh my memory...

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Fri, 30 Apr 2004 01:04:36 +1000
Message-ID: <40911985$0$20347$afc38c87@news.optusnet.com.au>

Bricklen wrote:

> Howard J. Rogers wrote:
>

>> I set timing on in Sql*Plus 8.1.7.0, did a bit of DML and came out 
>> with a time of (and I quote) "00:01:101.96".
>>
>> Does that mean '1 minute, 101 point 96 seconds'?
>>
>> Why is it not 2 minutes 41.96 seconds, which feels about right for the 
>> run in question??
>>
>> Or is it counting in base 32-and-a-half or something???
>>
>> Regards
>> HJR

>
> Hi Howard,
> I recall hearing mention of a bug in sqlplus' timing output. All that I
> could dig up was this:
> http://groups.google.ca/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=uadns90vx.fsf%40oracle.comX
>
>
> If you run out of options, I'm sure you could contact Oracle's sqlplus
> division directly by way of Christopher Jones or Alison Holloway to get
> the full details.

Thanks Bricklen,

It's been a while since I did much testing on 8i (and even then, that would have been on 8.1.5 which is unaffected by what is definitely a bug -which was, incidentally, fixed in 9.0.1).

The seconds counter doesn't reset to 0 after 59, so the seconds count is cumulative, so my run time was actually 101.96 seconds, or 1 minute 41.96 seconds. At least, I think that's how I should interpret it!

Regards
HJR Received on Thu Apr 29 2004 - 10:04:36 CDT