Forum OpenACS Q&A: Re: get sqlplus to send rows to /dev/null ?

Collapse
2: Re: get sqlplus to send rows to /dev/null ? (response to 1)
Posted by Brian Fenton on 02/27/04 10:07 AM
Hi Andrew
there is such a switch:
get rid of your
set autotrace on explain
set autotrace on

and just use
SET AUTOTRACE TRACEONLY EXPLAIN

Brian

Collapse
3: Re: get sqlplus to send rows to /dev/null ? (response to 2)
Posted by Andrew Piskorski on 02/27/04 10:24 AM
No Brian, traceonly does not execute the query, it only shows you its execution plan, which is exactly what I said I didn't want. I want execution times, but uncorrupted by the (large!) time it takes for sqlplus to spit the rows into an Emacs buffer

A shell script that reads a query from a file, executes it, and reports timing results seems like the way to go. I have a simple version of that now.