Shulou(Shulou.com)05/31 Report--

Today, I will talk to you about how to view the command of the implementation plan in Oracle. Many people may not know much about it. In order to make you understand better, the editor has summarized the following contents for you. I hope you can get something from this article.

Perform the following steps under SQL*PLUS (both the PL/SQL command window and the SQL window)

EXPLAIN PLAN FOR

SELECT XXX FROM DUAL

Set linesize 4000

Set pagesize 4000

SELECT * FROM TABLE (DBMS_XPLAN.DISPLAY)

SET TIMING ON-controls the display of execution time statistics

SET AUTOTRACE ON EXPLAIN-this setting includes execution plan, script data output, no statistics

Execute SQL statements that need to view the execution plan

SET AUTOTRACE OFF-No AUTOTRACE reports are generated, which is the default mode

SET AUTOTRACE ON-this setting includes execution plans, statistics, and script data output

Execute SQL statements that need to view the execution plan

SET AUTOTRACE OFF

SET AUTOTRACE TRACEONLY-this setting will have execution plans, statistics, and no script data output

Execute SQL statements that need to view the execution plan

SET AUTOTRACE TRACEONLY STAT-this setting contains only statistics

Execute SQL statements that need to view the execution plan

After reading the above, do you have any further understanding of the commands on how to view the execution plan in Oracle? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.