Re: How to analyze the execution plan done ?

From: Gerard H. Pille <geert.pille_at_vandemoortele.com>
Date: 11 Oct 2001 01:19:08 -0700
Message-ID: <41b04c0d.0110110019.2210d353_at_posting.google.com>

"jean-christophe pacchiana" <pacchiana_at_amj-groupe.com> wrote in message news:<3bc46141$0$14585$4d4eb98e_at_read.news.fr.uu.net>...
> I have a strange SQL code !
> How to analyze the execution plan done ?
> I try to use explain plan but i'm becoming mad !
>
> Is there a thing easyer ?
>
> Thanks !

Let someone else do it?

alter session set sql_trace=true;

execute the strange code

analyze the trc-file with tkprof Received on Thu Oct 11 2001 - 10:19:08 CEST

This message: [ Message body ]
Next message: rubbish: "PL/SQL statement in Developer/Form have problem"
Previous message: Gerard H. Pille: "Re: f60webm on HPUX 11"
In reply to: jean-christophe pacchiana: "How to analyze the execution plan done ?"
In reply to jean-christophe pacchiana: "How to analyze the execution plan done ?"
Next in thread: Mark Styles: "Re: FORMS 4.5 - two blocks, same table"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message