6 Replies Latest reply on Jun 3, 2013 2:13 PM by Jim Smith

    Explain plan in SQL_developer

    user10274093
      Hi all,
      on 11g , user can not have Explain plan in SQL_developer (1.5.5).Only a green button when he does F6.
      I did the following :

      AS sysdba :

      SQL> grant alter session to MYUSER;



      SQL> grant SELECT ANY DICTIONARY to MYUSER;

      SQL>grant create any table to MYUSER


      Connected as user :

      create global temporary table PLAN_TABLE


      But still he can not and only a green button when he does F6 or click on icon.

      Thank you.