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.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset