Open various parameters of the Execution Plan in SQLPLUS

Source: Internet
Author: User

The following statement is enabled in SQLPLUS.
Commonly used:

SQL> set timing on -- control display execution time statistics. Note that set time on is displayed before the SQL prompt.


SQL> SET AUTOTRACE OFF -- no AUTOTRACE report is generated. This is the default mode.
SQL> SET AUTOTRACE ON -- this setting includes the execution plan, statistics, and script data output-the most comprehensive


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

SQL> SET AUTOTRACE TRACEONLY -- in this way, the execution plan, statistics, and script data are not output.

SQL> -- set this way

SQL> set autotrace on stat; -- this setting does not contain execution plans, and contains script data output and statistics.




Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.