Re: SQL with no output

From: Martin Burbridge <pobox002_at_bebub.com>
Date: Sat, 22 Nov 2003 03:04:08 GMT
Message-ID: <Xns943ADFA219F93pobox002bebubcom@204.127.204.17>

Rick Denoire <100.17706_at_germanynet.de> wrote in news:v1dtrv0vorel62d9dfeo9kui0om0lmaf99_at_4ax.com:

> ed.prochak_at_magicinterface.com (Ed prochak) wrote:
>
>

>>Exactly what are you trying to benchmark?

>
> Executing exact the same SQLs after having made changes to the schema
> or init parameters.
>

>>One way to deal with the overhead when benchmarking is to make it
>>consistent.

>
> That's why I am asking how to suppress output!
>

>>But in the end you seem to be interested in a DOS solution. Try asking
>>in a Microsoft group how to execute a command in a DOS window,
>>minimized (that way the "screen update" issue is bypassed).

>
> sqlplus on DOS can also spool into a file...
> Since the amount of data returned by the queries could be surprisingly
> large, spooling would produce unnecesary junk files and could impact
> elapsed time.
>
> Bye
> Rick Denoire

Try a script like this

--
set termout off
timing start 'Query Execution'

-- query goes here
select * from all_objects
where owner in (select owner
from all_objects
where to_char(last_ddl_time) like '%2%'
group by owner)
/
set termout on
timing stop
--

you can execute it from the command line like 
  sqlplus user/pass_at_db @timing_script

-- 
Martin Burbridge

pobox 002 email is full of spam and never read

Received on Fri Nov 21 2003 - 21:04:08 CST