PL/SQL Developer reports error Dynamic Performance Tables not access

When you use the PL/SQL Developer tool to log on to a new user for query, the following error is reported (PL/SQL Developer version: 7.1.5
1403 ):
Dynamic Performance Tables not
Accessible,

Automatic Statistics disabled
For this session


You can disable statistics in
The preference menu, or obtain select

Priviliges on
V $ session, V $ sesstat and V $ statname tables


ThisReport
Error

Information is stored in different PL/SQL
The Developer version will appear. We can determine from the detailed error message above that the error cause is notWork
With

Itself.


Here, we will record in detail the three solutions to this small problem.

1. solution 1 (not recommended)

In the Error dialog box, select the "Don't show this message again" option. this Error will not be prompted next time.

This method can be called the "Ostrich method. This is not fundamentally solved
Problem.


2. method 2 (available
)

The error message is very detailed because the dynamic performance table does not have the right to be accessed.
Therefore, we can solve this problem by assigning the required access permissions to specific users.

Here are three specific solutions that I can think. You can continue to add.

1) if a specific user has the permission to query these three dynamic performance views
Row operation

Note: The authorization view is V _ $ session, not
V $ session, because V $ session has the same name and is not a specific view. Otherwise, you will receive the following error.

Sys @ ora10g> grant select on
V $ session to user_sec;

Grant select on V $ session
User_sec

*

Error at line 1:

ORA-02030: can only select from
Fixed tables/Views


The correct authorization method is as follows:

SQL> grant select on
V _ $ session to user_sec;

SQL> grant select on
V _ $ sesstat to user_sec;

SQL> grant select on
V _ $ statname to user_sec;


2) You can use the following "simple and crude" method to handle it.

SQL> grant select any
Dictionary to user_sec;


3) the preceding two methods are for specific users.
Limited to the above user_sec user) can query these three dynamic performance views, You can authorize the query permission to the public method to achieve, the operation is as follows. This ensures that all developers
The above error message will no longer appear.

SQL>
Grant select on V _ $ session to public;
SQL> grant select on V _ $ sesstat to public;
SQL> grant select on V _ $ statname to public;




3. Method 3 (recommended)


Che
Disable PL/SQL developer.

The method is as follows:

Navigate to tools --> preferences
--> Options

Find "automatic"
"Statistics" option, remove the small check mark before it, and then click "Apply" and "OK" to save and exit.