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
Messages: 52
Registered: November 2006

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: 67769
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe there is no statistics on your objects.

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

Current Time: Mon Mar 08 03:22:33 CST 2021