View Single Post

   
  #2 (permalink)  
Old 02-23-2008, 09:54 AM
Bricklen
 
Posts: n/a
Default Re: Can someone briefly refresh my memory...

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.

Cheers,

Bricklen
Reply With Quote