Re: Explain Plan
Date: Fri, 04 Feb 2005 15:36:22 +0100
On 4 Feb 2005 06:06:58 -0800, amerar_at_iwc.net wrote:
>Well, this was the output of running some PL/SQL procedure. There is
>nothing wrong with this query. What I am getting at, is how would one
>interpert all that?
>I mean, I'd like to be able to figure out something like: First it did
>a full table scan using an index, then it did a sort on those records,
>next it joined with table B using columns C & D, then it did a full
>table scan without an index on table B.........
>Knowing exactly what happened and in what order helps to understand the
>path that the query took. I have no clue by looking at this what
>happened first, and to what objects and what was done.........that is
>what I am trying to accomplish.
That is why Oracle published documentation, in your case the
Performanace Tuning manual.
It looks strange you are trying to improve on recursive sql. Apparently you are also still using Dictionary Managed Tablespaces (see the reference to fet$ in your explain, fet$ is the table storing free extents)
-- Sybrand Bakker, Senior Oracle DBAReceived on Fri Feb 04 2005 - 15:36:22 CET