Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

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 ...

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.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page