This time I will show you how to get the explain plan and SQL_ID from a query statement. If we have the SQL statement we just need to run it and then execute the following query: select plan_table_output from table(dbms_xplan.display_cursor(null,null,'all')); The display_cursor function return the execution plan that is allocated on the SQL area. … Continue reading How to find and execution plan and SQL ID for a SQL statement?