Statistics error

[vijay39]

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

[debasisdas]

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.

[debasisdas]

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.