Basic Oracle Concepts and Programming Question:

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.