1.

Can You See Execution Plan Of A Statement?

Answer»

YES. In many WAYS, for example from GUI based tools like TOAD, Oracle SQL Developer.

Configuring AUTOTRACE, a SQL*Plus facility

AUTOTRACE is a facility within SQL*Plus to show us the explain plan of the queries we've executed, and the RESOURCES they USED. Once the PLAN_TABLE has been installed in the database, You can control the report by setting the AUTOTRACE system variable.

  • SET AUTOTRACE OFF - No AUTOTRACE report is generated. This is the default.
  • SET AUTOTRACE ON EXPLAIN - The AUTOTRACE report shows only the optimizer execution path.
  • SET AUTOTRACE ON STATISTICS - The AUTOTRACE report shows only the SQL statement execution statistics.
  • SET AUTOTRACE ON - The AUTOTRACE report includes both the optimizer execution path and the SQL statement execution statistics.
  • SET AUTOTRACE TRACEONLY - Like SET AUTOTRACE ON, but SUPPRESSES the printing of the user's query output, if any.

YES. In many ways, for example from GUI based tools like TOAD, Oracle SQL Developer.

Configuring AUTOTRACE, a SQL*Plus facility

AUTOTRACE is a facility within SQL*Plus to show us the explain plan of the queries we've executed, and the resources they used. Once the PLAN_TABLE has been installed in the database, You can control the report by setting the AUTOTRACE system variable.



Discussion

No Comment Found