Using Oracle DBMS_XPLAN DISPLAY_CURSOR
How can we get the actual execution plan of a query that is in the SQL area?
We have several options to get the execution plan of a query, but it doesn’t give us the real execution plan from the shared pool, but recalculate the execution plan for us.
So, how can we see the real execution plan?