SQL> grant select on v_$statname to username;
grant select on v_$sesstat to username;
grant select on v_$session to username;
grant select on v_$mystat to username;
grant select on v_$sesstat to username;
grant select on v_$session to username;
grant select on v_$mystat to username;