V$FIXED_TABLE  

Lists the fixed objects present in the release.  

V$INSTANCE  

Shows the state of the current instance.  

V$LATCH  

Lists statistics for nonparent latches and summary statistics for parent latches.  

V$LIBRARYCACHE  

Contains statistics about library cache performance and activity.  

V$ROLLSTAT  

Lists the names of all online rollback segments.  

V$ROWCACHE  

Shows statistics for data dictionary activity.  

V$SGA  

Contains summary information on the system global area.  

V$SGASTAT  

Dynamic view. Contains detailed information on the system global area.  

V$SORT_USAGE  

shows the size of the temporary segments and the session creating them. This information can help you identify which processes are doing disk sorts.  

V$SQLAREA  

Lists statistics on shared SQL area; contains one row per SQL string. Provides statistics on SQL statements that are in memory, parsed, and ready for execution. Text limited to 1000 characters; full text is available in 64 byte chunks from V$SQLTEXT.  

V$SQLTEXT  

Contains the text of SQL statements belonging to shared SQL cursors in the SGA.  

V$SYSSTAT  

Contains basic instance statistics.  

V$SYSTEM_EVENT  

Contains information on total waits for an event.  

V$WAITSTAT  

Lists block contention statistics. Updated only when timed statistics are enabled.  

V$LOCK  

Lists the locks currently held by the Oracle8 Server and outstanding requests for a lock or latch.  

V$MYSTAT  

Shows statistics from your current session.  

V$PROCESS  

Contains information about the currently active processes.  

V$SESSION  

Lists session information for each current session. Links SID to other session attributes.
Contains row lock information.  

V$SESSION_EVENT  

Lists information on waits for an event by a session.  

V$SESSION_WAIT  

Lists the resources or events for which active sessions are waiting, where WAIT_TIME = 0 for current events.  

V$SESSTAT  

Lists user session statistics. Requires join to V$STATNAME, V$SESSION.