SET AUTOTRACE fails with error SP2-0618

by Eric Jenkinson on April 30, 2010

Categories: Troubleshooting

Tagged: ,


You attempt to set autotrace and receive the following error message.

SQL> set autotrace traceonly;
SP2-0618: Cannot find the Session Identifier.  Check PLUSTRACE role is enabled
SP2-0611: Error enabling STATISTICS report
SQL> connect / as sysdba


The user executing AUTOTRACE needs to have the PLUSTRACE role. By default the PLUSTRACE role does not exist and can be created by the SYS user with ORACLE_HOME/sqlplus/admin/plustrace.sql.

The plustrace.sql creates the PLUSTRACE role and grants SELECT on V_$SESSTAT, V_$STATNME and V_$MYSTAT. PLUSTRACE is granted to the DBA role with ADMIN OPTION.

For databases earlier than 10g you might also need to create the plan table. Execute the script ORACLE_HOME/rdbms/admin/utlxplan.sql to create the PLAN_TABLE. The PLAN_TABLE already exists on database version 10g and higher.


  • Emma (September 20, 2011 4:34 pm)

    The paragon of undresatnding these issues is right here!

  • zian (February 18, 2015 2:39 am)

    Thanks you very much

    info that could help someone
    on oracle 8.1 the script is plustrce.sql

  • sk (August 29, 2016 4:54 am)

    to Zian
    Thanks for the info, although v. 8.1 is too old….

Post A Comment