title: Batch+Oracle, disable response but still get execution time
body: <p>I have a batch file running some sql for me through sqlplus.
  The command goes as follows :</p>
  
  <pre><code>sqlplus user/password@sid @file.sql param1 param2 ... &gt;&gt; LOG.txt
  </code></pre>
  
  <p>By browsing the internet I did find out that it was possible to get time by adding those lines to the sql file :</p>
  
  <pre><code>SET TIMING ON
  ...sql operation...
  SET TIMING OFF
  </code></pre>
  
  <p>This gives me a really nice result in the log file, since now it looks like this:</p>
  
  <pre><code>SQL*PLUS INFORMATION
  COPYRIGHT
  INFORMATION ABOUT THE CONNECTION
  OLD/NEW STATEMENT
  RESULTS
  ROWS SELECTED
  EXECUTION TIME
  DISCONNECT MESSAGE
  </code></pre>
  
  <p>I really do like the output of this, but the RESULTS are to much. Often I want to test the execution time of long queries, but passing through the results really is a waste of bandwith. It also makes my log file huge and impractical, I would rather have a small log with all the other information.</p>
  
  <p>I tried adding other headers such as :</p>
  
  <pre><code>TERMOUT
  SPOOL
  </code></pre>
  
  <p>But the first one remove all output, including the time and the old/new statement, and the second one just copies the results into an other file without changing anything to my log file.</p>
  
  <p>I was thinking to wrap my request in an PLSQL block, but then I would no be able to use the TIME header anymore right ?</p>
  
  <p>Anyway, if you guys know of a header/other component that would resolve my problem, feel free to share !</p>
  
  <p>Thanks for your time.</p>