ORA-00942: 表或视图不存在

SQL> conn hr/***
SQL> select username,sid,serial#,module,action from v$session;

select username,sid,serial#,module,action from v$session

ORA-00942: 表或视图不存在

解决：

sqlplus "sys/*** as sysdba"
SQL> grant select on gv$session to hr;
grant select on gv$session to hr
*
第 1 行出现错误:
ORA-02030: 只能从固定的表/视图查询

SQL> grant select on sys.v_$session to hr;

授权成功。

sqlplus "hr/***"
SQL> select username,sid,serial#,module,action from v$session;

USERNAME SID SERIAL# MODULE ACTION
------------------------------ ---------- ---------- ------------------------------------------------ --------------------------------
1 1
2 1