2 Replies Latest reply: Nov 12, 2012 9:16 AM by user10274093 RSS

    ExplainPlan in SqlDevloper

    user10274093
      Hi,
      in SqlDevloper 3.1.7 ( DB is 11g R2) can any user have an Explain Plan ?

      Any special privilege to grant ?



      Thnak you.
        • 1. Re: ExplainPlan in SqlDevloper
          Venkadesh Raja
          No Privilage
          explain plan for select * from emp;
          
          select * from table(dbms_xplan.display());
          
          
          PLAN_TABLE_OUTPUT
          ----------------------------------------------------------------------------
          Plan hash value: 3956160932
          
          --------------------------------------------------------------------------
          | Id  | Operation         | Name | Rows  | Bytes | Cost (%CPU)| Time     |
          --------------------------------------------------------------------------
          |   0 | SELECT STATEMENT  |      |    14 |   518 |     3   (0)| 00:00:01 |
          |   1 |  TABLE ACCESS FULL| EMP  |    14 |   518 |     3   (0)| 00:00:01 |
          --------------------------------------------------------------------------
          • 2. Re: ExplainPlan in SqlDevloper
            user10274093
            thanks.