Open Sqlplus in execution plan

In Sqlplus we generally use the autotrace to view the execution plan, which performs the process analysis for some statements and optimizes the work. Here's a demonstration of how to grant Autotrace permissions to a normal user, taking the Scott user as an example (set autotrace on;)

Tools/raw Materials

sqlplus SSH Linux

methods/steps

1. Log in to the Scott user and verify that Scott has autotrace permissions.

Enable Autotrace feature: To SYSDBA user connection, run related scripts

3. Grant the required permissions (Plustrace) to the Scott user

4. Log in to the Scott user for verification. As you can see, the execution plan is automatically added after the statement is run.

If you need to assign permissions to all users, grant plustrace to public is executed. It is generally recommended that you only grant the required permissions to the users you need.

Open Sqlplus in execution plan