Re: SQL tuning tools question

In article <32A9B154.68A2_at_inforel.com>,
  Patty <pperry_at_inforel.com> wrote:
>
> Hi!
>
> Does anyone know anything about or have any experience with any or all
> of the following?
> Inspect/Analyze SQL by Precise,

i have some limited experience with the precise products and i like it. the inspect is uniqe because it does not use sqlnet and connection to oracle
instead it examine the sga directly. this way you can examine things even if
your database is hung for some reason.
it olso show you things from the unix point of view (paging, etc.) and it have
a very small overhead.
the analyze is a smart tool because it take into account the real problems
for example : a small query that runs a lot of times is more important then
a
big one that runs once in a day at night. for more information i belive their web site is http://www.precisesoft.com

> SQL Analyzer by Platinum
> SQL Lab by Quest Software?
> What do you think of them? Any comments? preferences?
>
> Thanks in advance!
> Patty

Shmuel Duek

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet