Which statements describe the autotrace SQL*Plus command?

Question

In SQL*Plus you can automatically get a report on the execution path used by the SQL optimizer and the statement execution statistics. The report is generated after successful SQL DML (that is, SELECT , DELETE , UPDATE and INSERT ) statements.

What is SQL autotrace?

The autotrace utility is a very underutilized feature of SQL*Plus. It offers statement tracing and instant feedback on any successful SELECT, INSERT, UPDATE or DELETE statement. The autotrace provides instantaneous feedback including the returned rows, execution plan, and statistics.

What is Numwidth in Sqlplus?

The NUMWIDTH setting controls the default width used when displaying numeric values.

What is feedback Sqlplus?

The FEEDBACK setting controls whether SQL*Plus displays the number of records returned by a SELECT statement, deleted by a DELETE statement, updated by an UPDATE statement, or inserted by an INSERT statement. You can set a threshold, below which you don't get any feedback regardless of whether the setting is on.

Expert · Answer