Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> SQL*Plus Timing command output

SQL*Plus Timing command output

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 30 Aug 1998 17:15:15 GMT
Message-ID: <35ea67bd.3770655@netnews.worldnet.att.net>


I'm trying to get a sense for how much the output from the SQL*Plus TIMING command varies between platforms. On Windows, the timing is reported in milleseconds, for example:

SQL> timing start
SQL> 
SQL> timing show

 real: 5330

On HP-Unix, the timing is resolved to the hundredth of a second, and is also formatted much better:

SQL> timing start
SQL> timing show
Elapsed: 00:00:01.81

Is the hh:mi:ss.hh format prevelant on most other Unix systems?

Jonathan Received on Sun Aug 30 1998 - 12:15:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US