(1) 确定 当前用户为 PLUSTRACE 角色
(2) SET AUTOTRACE ON 选项已经设置
(3) SYS用户不能使用
set echo on
drop role plustrace;
create role plustrace;
grant select on v_$sesstat to plustrace;
grant select on v_$statname to plustrace;
grant select on v_$session to plustrace;
grant plustrace to dba with admin option;
grant plustrace to scott