Re: Explain Plan with Toad - no cost displayed for statements
Date: Sat, 16 May 2009 13:56:08 -0700 (PDT)
On May 15, 9:32 am, PerMa <pmlov..._at_gmail.com> wrote:
> 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:
> Could there be some net8 / protocol problems between Toad and the
> We have the following system:
> Oracle9i Release 220.127.116.11.0 - Production
> Toad Xpert v 18.104.22.168 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
> ..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.
> 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
> Perhaps Toad needs to enable cost logging some way?
> Hope someone could help me with this!
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