Re: Oracle/SQL Question

Lorrie,

    There is a great Graphical Oracle Database Browser called SQL*Pro. It allows you to run up to 10 SQL statements at the same time. ( It is a multithreaded application ). Each statement has it's own window. Each of these windows keep statistics, such as start time, time run so far, and end time. In the event you don't want to wait for the SQL statement to complete, you can cancel it with the touch of a button, without affecting any other running statements. When the statement is cancelled, you won't need to talk to your DBA for anything, because it is a clean cancel through Oracle's OCI API.

    So many more features to help you out as a developer. You can visit the following Web Site :

    http://www.erols.com/erikbengtson/

    Good Luck

Lorrie wrote in message ...
>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 ?
Received on Tue Apr 14 1998 - 18:29:58 CDT