Re: Explain Plan with Toad - no cost displayed for statements

From: ddf <>
Date: Sat, 16 May 2009 13:56:08 -0700 (PDT)
Message-ID: <>

Comments embedded.

On May 15, 9:32 am, PerMa <> wrote:
> Hi!
> I have a lot of heavy queries I need to analyze, and I was hoping to
> be able to use Toads "Explain Plan" funtionality for doing this.
> So far I have installed the explain plan tables, and when I run
> queries for Explain plan, I get some information, but not the
> essential information such as cost, bytes, cpu_cost, io_cost etc
> Why can't I see this information?
> I have a couple of theories:
> 1)
> Could there be some net8 / protocol problems between Toad and the
> database?


> We have the following system:
> Oracle9i Release - Production
> Toad Xpert v w SQL optimizer
> Oracle Net8 client 8.1.700
> When I start Toad, it tells me that "Oracle client version is
> significantly older than server. Client should be same version or
> newer".
> ..but Toad in general works, so this is just a hunch!
> I've tried to figure out how to upgrade net8, but not found it on
> Oracles pages so far.
> 2)
> Could there be some rights problem when activating Explain Plan? I
> have installed the explain plan tables with the admin user we have
> access to. I beleive this user has maximum priveliges, but perhaps
> there could be a way to verify this?

You're getting a plan, so the answer to that is no .
> 3)
> Perhaps Toad needs to enable cost logging some way?


> Hope someone could help me with this!
> Br,
> PerMa

TOAD needs to use a current version of the PLAN_TABLE. Install the current plan_able usng $ORACLE_HOME/rdbms/admin/utlxplan.sql and you'll see the difference in output.

David Fitzjarrell Received on Sat May 16 2009 - 15:56:08 CDT

Original text of this message