If an Oracle user wants to use the autotrace feature, you can use the tutorial as an example to create the required table PLAN_TABLE, the required security role PLUSTRACE, and grant the role to that user:

SQL> CONNECT HR/retneclgg

SQL> @oraclexeapporacleproduct10.2.0server

RDBMSADMINUTLXPLAN.SQL

Table (HR.PLAN_TABLE) created.

SQL> CONNECT / AS SYSDBA

SQL> @C:oraclexeapporacleproduct10.2.0server

SQLPLUSADMINPLUSTRCE.SQL

SQL> drop role plustrace;

Role (PLUSTRACE) dropped.

SQL> create role plustrace;

Role (PLUSTRACE) created.

SQL> grant plustrace to dba with admin option;

Grant succeeded.

SQL> GRANT PLUSTRACE TO HR;

Grant succeeded.

Remember that PLAN_TABLE table must be created under the user schema HR.