Execution plan

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • jeabjeab
    New Member
    • Feb 2008
    • 1
    #1

    Execution plan

    How to create execution plan of oracle10g in tree form ?
    Tags: None
    • debasisdas
      Recognized Expert Expert
      • Dec 2006
      • 8119
      #2
      What do you mean by in tree form ?

      If you want to display execution plan in sql*plus then

      1.you must have the PLAN_TABLE in your schema
      2.set the autotrace to on.
      3.PLUS Trace role must be enabled

        Comment

        Previous template Next
        Working...