DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: elapsed time sqlplus interpretation

  1. #1
    Join Date
    Jan 2001
    Posts
    2,828

    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

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    1696/60 = 28.2666 = 28min 16sec.

    Your SQL*Plus version probably doesn't match the server version.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650

    Question

    Quote 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"

  4. #4
    Join Date
    May 2005
    Location
    AZ, USA
    Posts
    131
    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

  5. #5
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Quote 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"

  6. #6
    Join Date
    Jan 2001
    Posts
    2,828
    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
  •  


Click Here to Expand Forum to Full Width