<\/p>\n
We can also display the execution plan with sqlplus. For this we can use the explain plan tool with sqlplus.<\/p>\n
To use the Explain plan tool, the PLAN_TABLE table must be present under the corresponding schema. Some tools, such as Toad, will automatically create this table when you first view the execution plan. You can also create this table as below.<\/p>\n
SQL> @$ORACLE_HOME\/rdbms\/admin\/utlxplan.sql\r\n\r\nTable created.<\/pre>\nDisplay the execution plan of the query:<\/strong><\/p>\n
SQL> set autotrace traceonly explain\r\nSQL> select sysdate from dual;\r\n\r\nExecution Plan\r\n----------------------------------------------------------\r\nPlan hash value: 1546270724\r\n\r\n-----------------------------------------------------------------\r\n| Id | Operation | Name | Rows | Cost (%CPU)| Time |\r\n-----------------------------------------------------------------\r\n| 0 | SELECT STATEMENT | | 1 | 2 (0)| 00:00:01 |\r\n| 1 | FAST DUAL | | 1 | 2 (0)| 00:00:01 |\r\n-----------------------------------------------------------------<\/pre>\nWhen we run the “set autotrace traceonly explain” command before the query runs as above, the query will no longer produce output and only the execution plan will be displayed.<\/p>\n\n
<\/div>\n