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, 1684🔥, 0💬
Popular Posts:
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...