Basic Oracle Concepts and Programming Question:
Download Job Interview Questions and Answers PDF
How To Set Up Autotrace for a User Account?
Answer:
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.
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.
Download Oracle Database Interview Questions And Answers
PDF
Previous Question | Next Question |
What Is Oracle Server Autotrace in Oracle? | How To Get Execution Path Reports on Query Statements? |