解决办法
[oracle@localhost ~]$ sqlplus sys/Manager123 as sysdba
SQL> grant select on v_$statname to zheng;
SQL> grant select on v_$sesstat to zheng;
SQL> grant select on v_$session to zheng;
SQL> grant select on v_$mystat to zheng;
如果需要收回
SQL> revoke select on v_$[动态表] from zheng;
Revoke succeeded.