Re: Tunning question

That's a peculiarity of sqlplus for windows (sqlplusw.exe). The number after the second colon is the total number of elapsed seconds, not the remainder of seconds after factoring out the minutes and hours. The first query took 183.84 seconds, i.e. 3:03.84 minutes and the 2nd one took 116.47 or 1:56.47 seconds. So the difference in elapsed time isn't really 2 minutes, but 67.37 seconds or 1:07.37 minutes.

Originally posted by Tanel Poder

> > Elapsed: 00:03:183.84

> > Elapsed: 00:01:116.47

>

> Hm, since when is there over 60 seconds in a minute?

> Posting your query and execution plans would be helpful.

>

Tanel.

--
Posted via http://dbforums.com