Home  >  Oracle Database Administration (DBA)  >  Database Tuning  >  AUTOTRACE feature

1. What is the AUTOTRACE feature ?

This feature enable/ show a report on the execution path used by the SQL optimizer and the statement execution statistics AFTER the statement (SELECT, DELETE, UPDATE and INSERT) is executed. 

2.  How could I enable the AUTOTRACE feature ?

     a)  connected as SYS

     b)  run $ORACLE_HOME/sqlplus/admin/plustrce.sql

     c)  Grant PLUSTRACE to <the users who will use autotrace>  (a good idea is to let all the users use this feature, so this role could be granted to PUBLIC)

     d) If the PLAN_TABLE dosn't exist, we have to run $ORACLE_HOME/rdbms/admin/utlxplan.sql

     e) SQL> SET AUTOTRACE ON

3.  How could I use AUTOTRACE feature?

One time we set the AUTOTRACE to ON we can use this feature: 

More information about  this subject ( AUTOTRACE feature ) you can get from  www.in-oracle.com