Database
The following views provide information about the physical database:
- *$CONTROLFILE
Provides the names of all control files.
- *$CONTROLFILE_RECORD_SECTION
Provides information about the amount of information stored in each section of the control file. Available after database is mounted.
- *$DATABASE
Provides information about the database that is stored in the control file. Available after database is mounted.
- *$DATAFILE
Contains information about each datafile, based upon information from the control file. Available after database is mounted.
- *$DATAFILE_HEADER
Contains information about each datafile, based upon information in the datafile header. Available after database is mounted.
- *$DBFILE
Contains the name for each datafile. Maintained for upward compatibility. Oracle recommends that you now use *$DATAFILE instead. Available after database is mounted.
- *$OFFLINE_RANGE
Provides information about the offline status of datafiles. The information is provided from the control file. Available after database is mounted.
- *$TABLESPACE
Provides information about tablespaces, based upon information in the control file. Available after database is mounted.
- *$TYPE_SIZE
Specifies the size in bytes for the various components of an Oracle data or index block.
- *$UNDOSTAT
Lists a variety of information about the use of undo space by the database. This information can be used to estimate the amount of undo space needed by the database and is used by the database to tune the use of undo space. New ...