This discussion is archived
2 Replies Latest reply: Nov 12, 2012 7:16 AM by user10274093 RSS

ExplainPlan in SqlDevloper

user10274093 Explorer
Currently Being Moderated
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 Pro
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    thanks.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points