Re: Beginner: Query performance testing tool ?

You should look up "explain plan" and autotrace. I am learning more about these features currently. The plan shows what the optimizer determined is the lowest cost way to perform the query. The plan does not actually execute the query, so number of row counts is an estimate.

The autotrace feature is supposed to show every thing the plan does and additional information such as cpu utilization and disc activity. I haven't tried this yet (at least I haven't gotten results out yet).

Keep in touch, and I'll try to pass more info on as I find out.

Steffen Krause wrote:
>
> I need to test the reasons of slow query performance. I want to know what
> the DB does (used indexes, query execution order, number of reads etc.). How
> can I find this out in Oracle (7.3.3, WinNT)
>
> Regards,
> Steffen
> -----------------------------------------------------
> Steffen Krause stepfel_at_gmx.de
> Dipl.-Inf, MCSE
> But wherever we go we will always know
> that the land we stand on is never our own
Received on Wed Mar 18 1998 - 00:00:00 CST