When PL \ SQL is enabled, the following error occurs: "The dynamic execution table is inaccessible and automatic statistics of this session are disabled ".

When PL/SQL is used, but the first time a table is opened, the system prompts "the dynamic execution table is inaccessible and the automatic statistics of this session is disabled". The following message is displayed: V $ session, V $ sesstat and V $ statname are not authorized to access these tables. Therefore, this method is not available for statistics. of course, authorization is required. the authorization SQL statement is as follows:

Grant select on V _ $ statname to user;
Grant select on V _ $ sesstat to user;
Grant select on V _ $ session to user;
Grant select on V _ $ mystat to user;

User is the user name to be authorized. Remember it for later use.