Re: Oracle/SQL Question

From: BobH <b-horton_at_worldnet.att.net>
Date: 1998/04/13
Message-ID: <6gufgn$2op_at_bgtnsc02.worldnet.att.net>#1/1


Lorrie wrote:
>
> 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

At our shop we have both SQL*Navigator and SQL*LAB. You can check into these. Received on Mon Apr 13 1998 - 00:00:00 CEST

Original text of this message