General MySQL Oracle SQL Server

Setup Autotrace for a User Account in Oracle

Q

How To Set Up Autotrace for a User Account in Oracle?

✍: FYIcenter.com

A

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/retneciyf

SQL> @\oraclexe\app\oracle\product\10.2.0\server
  \RDBMS\ADMIN\UTLXPLAN.SQL
Table (HR.PLAN_TABLE) created.

SQL> CONNECT / AS SYSDBA

SQL> @C:\oraclexe\app\oracle\product\10.2.0\server
   \SQLPLUS\ADMIN\PLUSTRCE.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.

 

⇒ Show Execution Path Reports in Oracle

⇐ What Is Oracle Server Autotrace in Oracle

⇑ Introduction to Command-Line SQL*Plus Client Tool

⇑⇑ Oracle Database Tutorials

2020-06-08, 1322👍, 0💬

General MySQL Oracle SQL Server