Welcome to Oracle Communities
Register and Participate in Oracle's online communities. Learn from thousands of experts, get answers to your questions and share knowledge with peers.
I use Oracle 11gR2 on win2008R2.
I do not have plustrace role or select dictionary privilege yet.
But I can see the execution plan from SQLDevelopper.
Why is that ?
To see what privileges you do have, see output of:
select * from session_privs;
select * from session_roles;
For what privileges you need to do EXPLAIN PLAN (either implicitly or explicitly), see: