I have in the past struggled with the myriad of formatting options available with dbms_xplan.display_cursor so I was pleased to learn about a quick and easy to remember way of formatting the results at this years UKOUG conference. First execute the SQL statement of interest including the gather_plan_statistics hint: Then run dbms_xplan.display_cursor: The key point is […]