Step 2: Get the Execution Plan

Once you have the SQL_ID, pull the most recent execution plan. This tells you how Oracle is trying to run the query.

SELECT * 
FROM table(DBMS_XPLAN.DISPLAY_CURSOR('<your-sql-id>', NULL, 'ALLSTATS LAST'));

This gives you the final plan from the most recent run, including row estimates vs. actual rows, I/O, and temp usage.