This discussion is archived
2 Replies Latest reply: Jan 13, 2012 3:51 PM by 643298 RSS

How to suppress query result display (for timing) ?

xerces8 Newbie
Currently Being Moderated
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) ?

Regards,
David

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points