Home » SQL & PL/SQL » Client Tools » Cost is not displaying in plsql developer tool
Cost is not displaying in plsql developer tool [message #378331] Tue, 30 December 2008 01:05 Go to next message
sathyam2627
Messages: 52
Registered: November 2006
Member
Hi,

I am using Plsql developer tool which is like toad. Now i would like to generate explain plan of sql statments in that. Initially when i do that its says plan_table does not exist.

So for that i have executed utlxplan.sql to create a sample output table called PLAN_TABLE as SYSDBA. And i have created a public synonym for PLAN_TABLE and i have given the privileges for all other users.

Now i am getting the execution plan without cost of the sql statement.

Where i went wrong? kindly correct me.

Thanks for your interest.
Re: Cost is not displaying in plsql developer tool [message #378339 is a reply to message #378331] Tue, 30 December 2008 01:34 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe there is no statistics on your objects.

Regards
Michel
Previous Topic: procedure
Next Topic: Output containing more than 80 chars per line
Goto Forum:
  


Current Time: Thu Dec 08 14:11:39 CST 2016

Total time taken to generate the page: 0.12419 seconds