Solution - Removing spooled output

Hi Everyone,

   I just wanted to share with you the solution that I recieved to not getting any spooled output from a query test within SQL*Plus. I just the times from the timing command for each query. I used Tim's solution below, and it seems to work very well. I can not run a simulated test with numerous users without filling up disks with unwanted output.

Thanks for the help Tim,
John
<---- Begin Included Message ---->

Date: Wed, 17 Jan 1996 10:10:46 -0400
To: <adm1jjm_at_is.ups.com>
From: Tim_MacEachern_at_atl.sofkin.ca (Tim MacEachern) Subject: Removing spooled output

Assuming that you're on a Unix system, you can create a named pipe file and attach a grep process to it that eliminates all output except the timing you want. Such as:

     mknod named_pipe.lst p         (would be mkfifo on some systems)
     grep "^Elapsed" named_pipe.lst >timing_results&
     sqlplus
        spool named_pipe
        @tst
        spool off

where the test material might be a SQL script like:

   tst.sql

      set timing on;
      set termout off;
      select count(*) from x;
      select count(*) from x;
      ...

If you're happy with this solution, feel free to post it to oracle-l.

    Tim MacEachern     | Tim_MacEachern_at_atl.sofkin.ca, Software Specialist.
Software Kinetics Ltd. | Single father of three-and-a-half-year-old, still I
Dartmouth, Nova Scotia | play golf, piano, bridge, read, run ...
        Canada         | Meet me at http://cfn.cs.dal.ca/~ae721/Profile.html

<---- End Included Message ---->
Received on Thu Jan 18 1996 - 08:23:29 CST