set timing on in Sql*Plus. What are the units
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: set timing on in Sql*Plus. What are the units

  1. #1
    Join Date
    Apr 2001
    Posts
    19
    SQL> insert into bla bla
    sql> /

    1135608 rows created.

    Elapsed: 03:215:12958.64
    sql> commit;

    What on earth is 03:215:12958.64, some new Oracle standard for representing times?

  2. #2
    Join Date
    Aug 2001
    Posts
    75
    I guess this was bug. What sqlplus version you are using ? If you are using 8.1.6, try version 8.1.7 or 9i

    Sanjay
    OCP 8i

  3. #3
    Join Date
    Aug 2000
    Posts
    462
    hours:hours*60+minutes:hours*3600+minutes*60+seconds:hundredths

    It is a known bug
    Oracle DBA and Developer

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