Question: 1/65
A DBA notices that a query is performing poorly and wants to view the execution plan that was actually used during query execution. Which method provides the actual execution plan with runtime statistics?
EXPLAIN PLAN FOR followed by querying PLAN_TABLE
SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY_CURSOR()) after executing the query
Using the AUTOTRACE feature in SQL*Plus
Querying V$SQL_PLAN directly