2 Replies Latest reply: Jan 13, 2012 5:51 PM by 643298 RSS

    How to suppress query result display (for timing) ?

      I am doing some simple profiling, by using the TIMING optin in SqlPlus.
      The problem is, that some queries display the result (large), that is taken into the time. I am interested in the execution time only,
      not the time used by Windows for drawing in the (inefficient) console window.

      I do this:
      set timing on 
      select * from tab1 where this = that;
      I tried SET TERMOUT OFF , but:
      - it does not work in interactive mode
      - in script mode, it also suppresses the timing output

      Is there a solution (besides using another tool) ?


      PS: I use SQL*Plus: Release
      and the DB is Oracle Database 11g Enterprise Edition Release