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 [EMAIL PROTECTED]| -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Begun INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: timing value in these stats
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? Thanks And Regards Chark -Original Message- Sent: Saturday, 16 June 2001 1:31 To: Multiple recipients of list ORACLE-L can some one tell me what the these timemeasured in. Gennick gives an example in his SQL*Plus book On Windows you'll see it in milliseconds, so 90.5 seconds shows as real: 90500 Whereas on UNIX it's shown down to hundredths of a second, in the format Hours, Minutes, Seconds, Hundredths of a Second, so the same time appears as: Elapsed: 00:01:30.5 - Greg -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sairlao, Chark INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: timing value in these stats
I believe the SQL+ and the v$sysstat values are in Milliseconds. -Original Message- Sent: Friday, June 15, 2001 8:46 AM To: Multiple recipients of list ORACLE-L can some one tell me what the these timemeasured in. in sqlplus when set timing on is this in second? if select value from v$sysStat where name like 'CPU use in these sessions'; is this value in milli seconds? much appreciated Thanks And Regards Chark Sairlao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sairlao, Chark INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: timing value in these stats
can some one tell me what the these timemeasured in. Gennick gives an example in his SQL*Plus book On Windows you'll see it in milliseconds, so 90.5 seconds shows as real: 90500 Whereas on UNIX it's shown down to hundredths of a second, in the format Hours, Minutes, Seconds, Hundredths of a Second, so the same time appears as: Elapsed: 00:01:30.5 - Greg -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).