作为sys 登入执行下列语句
SQL> create role plustrace;
SQL> grant select on v_$sesstat to plustrace;
SQL> grant select on v_$statname to plustrace;
SQL> grant select on v_$mystat to plustrace;
SQL> grant plustrace to dba with admin option;
SQL> grant plustrace to public;
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/26764973/viewspace-1173641/
,如需转载,请注明出处,否则将追究法律责任。