Database
These views provide information about the physical database:
- V$CONTROLFILE
Provides the names of all control files.
- V$CONTROLFILE_RECORD_SECTION
Provides information about the amount of information stored in each section of the control file.
- V$DATABASE
Provides information about the database that is stored in the control file.
- V$DATAFILE
Contains information about each datafile, based upon information from the control file.
- V$DATAFILE_HEADER
Contains information about each datafile, based upon information in the datafile header.
- V$DBFILE
Contains the name for each datafile. Maintained for upward compatibility. Use V$DATAFILE instead.
- V$OFFLINE_RANGE
Provides information about the offline status of datafiles. The information is provided from the control file.
- V$TABLESPACE
Provides information about tablespaces, based upon information in the control file.
- V$TYPE_SIZE
Specifies the size in bytes for the various components of an Oracle data or index block.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access