Hi,

Connect as user sys or any OS user with sysdba privileges and run the following command:

Code:
grant select on sys.v_$session to scott;
Regards,
Nir