Execution plan for the specified statement_id : explain plan « SQL Plus « Oracle PL / SQL






  1. Oracle PL / SQL
  2. SQL Plus
  3. explain plan

Execution plan for the specified statement_id

    


SQL>
SQL> UNDEFINE v_statement_id;
SQL>
SQL> SELECT id ||
  2    DECODE(id, 0, '', LPAD(' ', 2*(level - 1))) || ' ' ||
  3    operation || ' ' ||
  4    options || ' ' ||
  5    object_name || ' ' ||
  6    object_type || ' ' ||
  7    DECODE(cost, NULL, '', 'Cost = ' || position)
  8  AS execution_plan
  9  FROM plan_table
 10  CONNECT BY PRIOR id = parent_id
 11  AND statement_id = '&&v_statement_id'
 12  START WITH id = 0
 13  AND statement_id = '&v_statement_id';
Enter value for v_statement_id:
old  11: AND statement_id = '&&v_statement_id'
new  11: AND statement_id = ''
old  13: AND statement_id = '&v_statement_id'
new  13: AND statement_id = ''

no rows selected

SQL>








Related examples in the same category

1.explain plan for query
2.explain plan for select statement
3.Explain sql statement