EXPLAIN PLAN, V$SQL_PLAN and DBMS_XPLAN

In some of our previous posts, we have talked about DBMS_XPLAN package in Oracle and have demonstrated it’s usage. One of the recent questions from our readers was: “What is the difference between using “EXPLAIN PLAN command” vs using the dictionary view: V$SQL_PLAN? And can you elaborate a bit on t

Read More - Register for Free Membership