472,122 Members | 1,449 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,122 software developers and data experts.

Statistics error


when iam giving the below query its giving me error...

set autotrace traceonly explain statistics

Its giving error like enable plustrace role.........
cannot identify identifier statistics..

But i create plustrace role..... and i grant that role to the particular user.

plz help me
Jun 5 '07 #1
2 974
8,127 Expert 4TB
Welcome to TSDN.

You have reached the right place for knowledge shairing.

Here you will find a vast resource of related topics and code.

Feel free to post more doubts/questions in the forum.

But before that give a try from your side and if possible try to post what/how you have approached to solve the problem.
It will help Experts in the forum in solving/underestanding your problem in a better way.
Jun 6 '07 #2
8,127 Expert 4TB
connect to the system as a SYSDBA

then try these

drop role plustrace;
create role plustrace;

grant select on v_$sesstat to plustrace;
grant select on v_$statname to plustrace;
grant select on v_$mystat to plustrace;
grant plustrace to USERNAME with admin option;


This will definately solve your problem.
Jun 6 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Metal Dave | last post: by
5 posts views Thread by Allan Ebdrup | last post: by
5 posts views Thread by Davo1977 | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.