Autotrace window is empty

[Mindaugas]

Hi,

using sql plus console and command "autotrace on", I get trace information after select.
Why in PL/SQL developer for the same user Statistics window is empty? What I've missed?

 

[Marco Kalter]

To use the Automatic Statistics feature you need select privileges for the he v$session, v$sesstat and v$statname views. For example:

connect sys/password@db
create role plstrace;
grant select on v_$sesstat to plstrace;
grant select on v_$statname to plstrace;
grant select on v_$session to plstrace;
grant plstrace to dba with admin option;

Now that you have created the plstrace role, make sure that it is granted to the PL/SQL Developer user, and you're done.