Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: timing value in these stats
On Jun 17, 2001 at 07:40:25PM, Sairlao, Chark wrote:
> yeah,
>
> that is what I thought but can you tell me what is this? on sqlplus session
> with timing on
>
>
> 3981 rows selected.
>
> Elapsed: 00:04:245.23
> SQL>
>
> would it be hour:minute:milliSecond?
It's a bug. Your time is 00:04:05.23, or something like that =;) The problem is 245.23 includes 4 * 60 (= 240 seconds) that's obviously incorrect.
-- Vladimir Begun | "I may not be totally perfect, but parts of http://vbegun.net/ | me are excellent." http://vbegun.net/wap/ | -- Ashleigh Brilliant me_at_vbegun.net | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Begun INET: jester_at_whale.sunbay.crimea.ua Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Mon Jun 18 2001 - 01:14:39 CDT