You can use the tkprof utility to do that.
--
Matt Brennan
SQL*Tools Specialist
GERS Retail Systems
9725-C Scranton Road
San Diego, California 92121
1-800-854-2263
mbrennan_at_gers.com
Lorrie <lorrie_at_macconnect.com> wrote in article
<lorrie-ya02408000R1304981946460001_at_enews.newsguy.com>...
> I am an Oracle developer. When I am developing SQL statements and tuning
> them, I need to run them over and over again, to see the performance
effect
> of changes to the statement, and optimization mode. I also need to see
how
> long it takes each statement to run. Also, sometimes when I drastically
> change
> the statement, and it uses the wrong index, the statement goes on for
ever.
> Then I have to kill the application, and then ask my DBA to kill the
orphan
> client session. Are there any tools out there that could help me with any
> of these problems/requirements?
>
> TIA,
> Lorrie
>
Received on Tue Apr 14 1998 - 17:01:26 CDT
