Explain Plan with Toad - no cost displayed for statements
Date: Fri, 15 May 2009 07:32:30 -0700 (PDT)
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 database?
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 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.
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?
Perhaps Toad needs to enable cost logging some way?
Hope someone could help me with this!
PerMa Received on Fri May 15 2009 - 09:32:30 CDT