Depending on which features are installed and configured, an Oracle 10g database can contain approximately 350 dynamic performance views. Most of these views have names that begin with V$. Examples of Dynamic Performance Views:
--V$DATABASE Contains - about the database itself, such as the database name and when the database was created.
--V$VERSION Shows which software version the database is using.
--V$OPTION Displays which optional components are installed in the database. --V$SQL Displays information about the SQL statements that database users have been issuing.
