Executioin Plan and Tracing Report in SQL*Plus Using SET AUTOTRACE
Posted by admin under SQL*Plus
The AUTOTRACE system variable enables SQL*Plus report generation on the execution plan used by the SQL optimizer and statistics about the statement execution. When enabled, a report is generated after each successful DML statement (ie. SELECT, DELETE, INSERT or UPDATE). This option is useful when monitoring and tuning the performance of SQL statements. Read the rest of this entry »
