V$ Views

To get the list of all the V$ or GV$ Views, query the V$FIXED_TABLE view.

SQL> Select name From V$FIXED_TABLE where name like 'V%';

The difference between V$ and GV$ is GV$ includes inst_id column which is used in RAC instances.

V$ views are created from the X$ tables. To know the details of the underlying X$ tables from which the v$ views are created, query the V$_FIXED_VIEW_DEFINITION view.

SQL> Select * From V$FIXED_VIEW_DEFINITION where view_name like 'GV$SESSION';

Thanks