Set Timing in SQL*Plus

From: Ed Jennings <jenningse_at_mindspring.com>
Date: 1997/07/31
Message-ID: <33E135F4.4979_at_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 CEST

Original text of this message