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