These views provide information about the physical database:
Provides the names of all control files.
Provides information about the amount of information stored in each section of the control file.
Provides information about the database that is stored in the control file.
Contains information about each datafile, based upon information from the control file.
Contains information about each datafile, based upon information in the datafile header.
Contains the name for each datafile. Maintained for upward compatibility. Use V$DATAFILE instead.
Provides information about the offline status of datafiles. The information is provided from the control file.
Provides information about tablespaces, based upon information in the control file.
Specifies the size in bytes for the various components of an Oracle data or index block.