how to spool timing of a query into a spool file

2001-11-02 Thread another oracle dba
Hi. this is a minor problem that is driving me nuts. I have a query that runs nicely and I want to save its timing information in a spool file. When I connect to mysql and run the query it adds the time elapsed after the data (9 rows in set 1.1 sec). But when I run the same query in the line

how to spool timing of a query into a spool file

2001-11-02 Thread another oracle dba
Hi this is a 2nd attempt. My first post never made it to the list. What I'm trying to do is to spool queries results into a spool file (via tee command). For some reason the timing information doesn't get there. When I run a query from mysql, the output is followed by a line with the number of