Oracle Error: Dynamic execution table is inaccessible, automatic statistics is disabled for this session, and problems after automatic statistics are turned off

When using PL/SQL, the first time you open the table, you will be prompted to "dynamic execution table is inaccessible, automatic statistics of this session is forbidden" error, a message is as follows: V$session,v$sesstat,v$statname is not authorized, do not have access to these tables, So there is no statistic in this law.

Granted, of course. Authorized SQL is as follows:

Sqlplus/nolog Enter the login page, and then execute Conn/as sysdba log on to the SYS user

Log in with SYS, authorize to the appropriate user, use the following statement
Grant SELECT on V_$statname to Scott;
Grant SELECT on V_$sesstat to Scott;
Grant SELECT on V_$session to Scott;
Grant SELECT on V_$mystat to Scott;

Cancel Permissions

Revoke select on V_$statname from Scott;
Revoke select on V_$sesstat from Scott;
Revoke select on V_$session from Scott;
Revoke select on V_$mystat from Scott;

Oracle with SYS login Ora-28009:connection as SYS should be as SYSDBA OR Sysoper workaround

The lower normal can be changed to SYSDBA.

Oracle Error: Dynamic execution table is inaccessible, this session auto-statistics is disabled, the problem after automatic statistics is turned off