Cursor Cache

Get the Actual Execution Plan with DBMS_XPLAN.DISPLAY_CURSOR Purpose EXPLAIN PLAN never runs the statement it describes. It asks the optimizer what it would do, based on statistics and cardinality estimates, and prints that guess — which is exactly why a query that looks fine in EXPLAIN PLAN can still run slow in …