Dynamic Performance
• V$CONTROLFILE
• V$DATABASE
• V$DATAFILE
• V$INSTANCE
• V$PARAMETER
• V$SESSION
• V$SGA
• $SPPARAMETER
• V$TABLESPACE
• V$THREAD
• V$VERSION
Examples
• V$CONTROLFILE: Lists the names
of the control files
• V$DATABASE: Contains
database information from the control file.
• V$DATAFILE: Contains data
file information from the control file
• V$INSTANCE: Displays the
state of the current instance
• V$PARAMETER:
Lists parameters and values currently in effect for the session
• V$SESSION: Lists session
information for each current session
• V$SGA: Contains
summary information on the system global area (SGA)
• V$SPPARAMETER:
Lists the contents of the SPFILE
• V$TABLESPACE: Displays
tablespace information from the control file
• V$THREAD: Contains thread
information from the control file.
• V$VERSION: Version numbers
of core library components in the Oracle server
More detail of examples:
1.The V$FIXED_TABLE
view
can also be queried to get a listing of the dynamic
SQL> SELECT *
FROM V$FIXED_TABLE;
2.To get an overview of the data
dictionary views, the DICTIONARY view or its synonym
DICT
can be queried.
SQL> SELECT
* FROM dictionary;
Include the WHERE
clause
to narrow your responses:
SQL> SELECT
* FROM dictionary
2 WHERE table_name LIKE ‘DBA_SEG%’
3.To view the contents of the view,
use the SELECT command.
SQL> SELECT * from V$INSTANCE;
4.To get a list of columns within a
view, use the DESCRIBE keyword:
SQL> DESCRIBE
V$INSTANCE;
