Plsql developer "Dynamic execution table is inaccessible, automatic statistics of this session is forbidden" solution

Plsql developer "Dynamic execution table is inaccessible, automatic statistics for this session are forbidden" solution 2014-10-08 12:31:46

Category: Oracle

Plsql developer "Dynamic execution table is inaccessible, automatic statistics of this session is forbidden" solution

Phenomenon:

The first time with Plsql Developer Connection database, if the SYS user login and operation is normal, if you use ordinary users such as Haishu login and create a table error "Dynamic execution table is not accessible, this session of automatic statistics is forbidden." You can disable statistics in the Execution menu, or get the option in the V$session,v$sesstat and V$statname tables. ”

Cause Analysis:

From the error prompt can be seen, because the dynamic performance table related permissions are not authorized to the current user

Workaround One (recommended):

According to the instructions, disable statistics in the Execution menu, how to Do: in the menu at the top, choose "Tools"-"preferences"--"Options"-"Auto Statistics". Remove the "automatic statistics" before the default √.

Workaround Two:

According to the prompt, the Haishu user is authorized by the SYS identity

Grant SELECT on V_session to Haishu;

Grant SELECT on V_$sesstat to Haishu;

Grant SELECT on V_$statname to Haishu;

or authorized for all users

Grant SELECT on V_$session to public;

Grant SELECT on V_$sesstat to public;

Grant SELECT on V_$statname to public;

Plsql developer "Dynamic execution table is inaccessible, automatic statistics of this session is forbidden" solution