-
elapsed time sqlplus interpretation
Hi
When i run a query in sqlplus with set timing on
i get
Table created.
Elapsed: 00:28:1696.52
how do i interpret this ? is it approx 30 minutes or 28 minutes ?
what does the value 1696 represet in the seconds column
regards
Hrishy
-
1696/60 = 28.2666 = 28min 16sec.
Your SQL*Plus version probably doesn't match the server version.
-
Originally Posted by hrishy
Hi
Elapsed: 00:28:1696.52
how do i interpret this ? is it approx 30 minutes or 28 minutes ?
what does the value 1696 represet in the seconds column
HH:MM:SS.SS is the format
then what's 1692.52?
1696/60 = 28.2666 = 28min 16sec
Already the result has 28 as mins then 1696/60 once again gives 28.2666, are you sure they are minute
"What is past is PROLOGUE"
-
Looks like your nls setting may be using the ss.ff format.
FF [1..9]
Fractional seconds; no radix character is printed (use the X format element to add the radix character). Use the numbers 1 to 9 after FF to specify the number of digits in the fractional second portion of the datetime value returned. If you do not specify a digit, then Oracle uses the precision specified for the datetime datatype or the datatype's default precision.
Examples: 'HH:MI:SS.FF'
http://download-west.oracle.com/docs...ts4a.htm#48515
-
Originally Posted by dbtoo
Looks like your nls setting may be using the ss.ff format.
FF [1..9]
Fractional seconds; no radix character is printed (use the X format element to add the radix character). Use the numbers 1 to 9 after FF to specify the number of digits in the fractional second portion of the datetime value returned. If you do not specify a digit, then Oracle uses the precision specified for the datetime datatype or the datatype's default precision.
Examples: 'HH:MI:SS.FF'
http://download-west.oracle.com/docs...ts4a.htm#48515
Gotcha!
the format set as 'hh:mi.ff4:ss' could get you the above "00:28:1696.52" where 28.1696 is the mins. is that right!!!!!!
Good work dbtoo!
"What is past is PROLOGUE"
-
Hi Guys
Thanks a bunch for that explanation
regards
Hrishy
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|