OraFAQ Forum: Client Tools » Cost is not displaying in plsql developer tool

Home » Other » Client Tools » Cost is not displaying in plsql developer tool

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Cost is not displaying in plsql developer tool [message #378331]

Tue, 30 December 2008 01:05

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.

Report message to a moderator