Collections:
Setup Autotrace for a User Account in Oracle
How To Set Up Autotrace for a User Account in Oracle?
✍: FYIcenter.com
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
2020-06-08, 1692🔥, 0💬
Popular Posts:
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...