AWS / Azure / GCP Cloud | Database | Data Analytics | LakeHouse | Machine Learning | Shrenik Parekh

Option 1: Display sql statement execution plan and sql execution statistics also set pagesize 0 set linesize 5000 spool plan_q1.log set auto trace on @sql_statement.sql spool off Explain plan could lie explore at Kerry Osborne's Blog - http://kerryosborne.oracle-guy.com/2008/10/explain-plan-lies/ Option 2: Use DBMS_XPLAN, get explain plan from awr, using SQL_ID. set pagesize 0 set linesize 5000 spool plan_q1.log select * from table(dbms_xplan.display_awr('sql_id')); spool off Options for SQL statement: SELECT plan_table_output FROM TABLE(DBMS_XPLAN.DISPLAY('plan_table',null,'basic +predicate +cost')); SELECT plan_table_output FROM TABLE(DBMS_XPLAN.DISPLAY('plan_table',null,'typical -cost -bytes')); SELECT plan_table_output FROM TABLE(DBMS_XPLAN.DISPLAY('plan_table',null,'basic +note')); Select plan_table_output From table(dbms_xplan.display_cursor(null,null,'TYPICAL'); SELECT plan_table_output FROM tabl...