PL/SQL developer-automatic statistics

In PL/SQLAutomatic statisticsThis function is used to generate statistical reports for executed SQL statements and test scripts. Generally, a new user does not have the corresponding permissions, so the user cannot actually use it. (even if you activate this option, seeHere), As shown in.

 

The permission here indicates whether access is allowed.Dynamic Performance Table).

If you want the general user to have this automatic statistics function, you can grant the following permissions through the Administrator.

Grant Select_catalog_role To Username;

After having the corresponding permissions, the automatic statistics function is actually activated.

Click the select button to select the information you want to collect.

After the command is executed, You can query the required statistics in the Statistics tab of the form.