IS_RESOLVED_ADAPTIVE_PLAN in V$SQL or V$SQLAREA optimizer_adaptive_plans. oradebug event sql_trace plan_stat=all_executions explain plan and dbms_xplan.display to show an SQL statement's execution plan shows the default plan that was chosen for an SQL statement by the optimizer. After executing an SQL statement, dbms_xplan.display_cursor can be used to show the actually executed plan. dbms_xplan.display_cursor(format=>'adaptive') shows all plan operations, not only those that were executed, but also the alternative ones.