PLSQL Developer message

[jabarreras]

First time I try to execute a qry with PLSQL Dev, I receive this message: "Dynamic perfomance tables not accesible Automatic Statistics disabled ...etc...."
If I try to "grant select to myuser" with the sys user I received a ORA-02030 Error. The only way to avoid this message is to uncheck the automatic statistics in the tools->preferences window.

 

[Marco Kalter]

You should probably create the (standard) PLUSTRACE role, which provides all privileges required for the Statistics feature. In the admin subdirectory of your SQL*Plus directory, you will find a plustrce.sql file that needs to be run as SYS. Here is the relevant code from the script:

create role plustrace;

grant select on v_$sesstat to plustrace;
grant select on v_$statname to plustrace;
grant select on v_$session to plustrace;
grant plustrace to dba with admin option;

Now you can grant the plustrace role to any user that wants to use the Statistics feature in PL/SQL Developer.

------------------
Marco Kalter
Allround Automations