PLAN_TABLE Detils

In PLAN TABLE some of the important columns descriptions are as follows :
 
 
at
Labels:

DBMS_XPLAN

One more way we can see the Explain Plan by using DBMS_XPLAN package. DBMS_XPLAN automatically queries the last plan in PLAN_TABLE. It u...

  • DBMS_XPLAN.DISPLAY_CURSOR
    DBMS_XPLAN.DISPLAY_CURSOR show actual execution plan from dynamic performance views. DBMS_XPLAN:   The DBMS_XPLAN package provides an eas...
  • Difference Between Collection and Record
    What is the difference between Collection and Records? Collection Record The internal components always have the same data type, ...
  • Bulk Bind in Oracle
    Bulk Bind or we can say FORALL in Oracle. The assigning of values to PL/SQL variables in SQL statements is called binding. The binding of ...