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, 2192🔥, 0💬
Popular Posts:
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
Where Is the Export Dump File Located in Oracle? If you are not specifying the dump directory and fi...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
How To View Data Files in the Current Database in Oracle? If you want to get a list of all tablespac...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...