Enable SQL Plus autotrace

As user from SQL Plus:


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

As system from SQL Plus:


SQL> @?/rdbms/admin/utlxplan

Table created.

SQL> grant all on plan_table to public;

Grant succeeded.

As sys from SQL Plus:

SQL> @?/sqlplus/admin/plustrce.sql

SQL> grant plustrace to public;

Grant succeeded.

As user (a reconnect is required):

SQL> set autotrace on;