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, 1322👍, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Introduction to Date and Time Handling in MyS...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...