469,149 Members | 1,857 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,149 developers. It's quick & easy.

Statistics error

Hi,

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 933
debasisdas
8,127 Expert 4TB
Hi
vijay39
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
debasisdas
8,127 Expert 4TB
connect to the system as a SYSDBA

then try these
[code]

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;



[code]

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
1 post views Thread by CARIGAR | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.