Liron Amitzi Oracle ACE

Oded Raz Oracle ACE Director

Category archives for: Tips & Tricks

Using Oracle DBMS_XPLAN DISPLAY_CURSOR

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?

Log in / Advanced NewsPaper by Gabfire Themes