V$ Views
The following table has the dynamic performance views. You need DBA privileges to access these views.
| View Name | Description |
|---|---|
| V$BGPROCESS | Oracle background processes |
| V$CONTROLFILE | The names of the control files |
| V$DATABASE | Information about the database from the control file |
| V$DATAFILE | Information about the data files from the control file |
| V$ENABLEDPRIVS | Enabled privileges |
| V$FILESTAT | I/O activity per data file |
| V$FIXED_TABLE | Displays all dynamic performance tables, views, and derived tables |
| V$FIXED_VIEW_DEFINITION | Displays the definitions of all the fixed views |
| V$INSTANCE | Status about the instance |
| V$LICENSE | About license limits |
| V$LOCK | about active locks |
| V$MYSTAT | Statistics for the current session |
| V$NLS_PARAMETERS | Current NLS parameter values |
| V$NLS_VALID_VALUES | All valid values for NLS parameters |
| V$OPTION | The installed Oracle options |
| V$PARAMETER | Current initialization parameter values for the session |
| V$PROCESS | Information about all active processes |
| V$RESERVED_WORDS | All keywords used by the PL/SQL compiler |
| V$SESS_IO | I/O statistics for all active sessions |
| V$SESSION | About all active sessions |
| V$SESSION_EVENT | Waits for an event by a session |
| V$SESSION_LONGOPS | Status of operations that run for longer than 6 seconds |
| V$SESSION_WAIT | Resources or events for which active sessions are waiting |
| V$SESSTAT | User session statistics |
| V$SGA | Rhe shared global area |
| V$SGASTAT | SGA components |
| V$SPPARAMETER | The contents of the server parameter file |
| V$SQL | SQL statements in memory |
| V$SQLAREA | Aggregated information about SQL statements in memory |
| V$SQL_PLAN | Execution plan information for SQL statements in memory |
| V$SQL_PLAN_STATISTICS | Execution statistics of SQL statements in memory |
| V$SQLTEXT | The text of SQL statements in memory |
| V$SQLTEXT_WITH_NEWLINES | Same as V$SQLTEXT, with improved legibility |
| V$SYSSTAT | All system statistics |
| V$SYSTEM_PARAMETER | Information about the initialization parameters in effect |
| V$TABLESPACE | All tablespaces |
| V$TIMER | Internal clock, in hundredths of a second |
| V$TIMEZONE_NAMES | List of names and abbreviations of time zones |
| V$TRANSACTION | All active transactions |
| V$VERSION | Version information about installed Oracle products |
| V$WAITSTAT | Block contention statistics |