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...%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