In PLAN TABLE some of the important columns descriptions are as follows :
Subscribe to:
Posts (Atom)
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...
-
What is the difference between Collection and Records? Collection Record The internal components always have the same data type, ...
-
DBMS_XPLAN.DISPLAY_CURSOR show actual execution plan from dynamic performance views. DBMS_XPLAN: The DBMS_XPLAN package provides an eas...
-
PL/SQL Interview Question for Collections. What is Collection? How many type of collection? Why or when we will use collection? What i...