Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Set Timing in SQL*Plus
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.comReceived on Thu Jul 31 1997 - 00:00:00 CDT