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 -> Set Timing in SQL*Plus

Set Timing in SQL*Plus

From: Ed Jennings <jenningse_at_mindspring.com>
Date: 1997/07/31
Message-ID: <33E135F4.4979@mindspring.com>#1/1

I'm having trouble getting usable information out of the "SET TIMINING ON" command in sqlplus.

When using sqlplus from a unix shell, it looks like this:

	SQL> set timing on
	SQL> select count(*) from user_tables;

	COUNT(*)

----------
909 Elapsed: 00:00:05.53

But when using sqlplus for Windows/Windows95, it looks like this:

	SQL> set timing on
	SQL> select count(*) from user_tables;

	  COUNT(*)

----------
909 real: 3350

In unix, the result is a very readable elapsed time. From Windows, the elapsed timeis almost useless to a developer. Is there anyway to format the output in a sqlplus for Windows session so as to make it more readable?

Thanks,

Ed Jennings
Oracle DBA
EPS, Inc.

-- 
-----------------
jenningse_at_mindspring.com
Received on Thu Jul 31 1997 - 00:00:00 CDT

Original text of this message

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