From v$fixed_view_definition one can find the definitions of V$views which may one in understand them. Example: SQL> set pages 0 SQL> SELECT * FROM v$fixed_view_definition where view_name = 'V$SESSION'; V$SESSION select SADDR , SID , SERIAL# , .... SQL_TRACE_BINDS from GV$SESSION where inst_id = USERENV('Instance') If one tries to grant direct access to view you … Continue reading How to find definitions of V$, GV$ views? →