How to setup the AUTOTRACE utility?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
How to setup the AUTOTRACE utility?
Rating:
In order to start using the AUTOTRACE utility, some initial setup operations must be performed. These operations are stated below:
- Every user willing to use this utility must be granted the PLUSTRACE role.
- A PLAN_TABLE must be created in the user schema.
@/SQLPLUS/ADMIN/PLUSTRCE.SQL
In order to grant the PLUSTRACE role to a user, the following commands must be issued from the SQL*Plus session:
GRANT PLUSTRACE TO user_name
However, in both the above cases, the Database Administrator privileges are required for creating and granting of the PLUSTRACE role.
Rating:
Was this information helpful?
Other articles
- What is pinning?
- What is ANALYZE TABLE statement?
- What is B-tree index ?
- What is Oracle Intelligent Agent?
- What is a free list?