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

Configuration

The following views provide information about the current configuration of the Oracle environment:

*$COMPATIBILITY

Lists features in use by the current instance that would preclude reverting to a previous release of the Oracle software. Because these are instance based, some of the features may disappear if the database is shut down normally.

*$COMPATSEG

Lists permanent features in the database that would preclude reverting to a previous release of the Oracle software.

*$EVENT_NAME

Contains descriptive information about all possible wait events.

*$LICENSE

Contains a single row specifying the maximum numbers of concurrent and named users allowed, as well as the highwater marks.

*$MLS_PARAMETERS

Lists the initialization parameters and their current values for Trusted Oracle. The format is the same as *$PARAMETER. Available after database is opened.

*$NLS_PARAMETERS

Contains the current values for each of the National Language Support (NLS) parameters.

*$NLS_VALID_VALUES

Lists the valid values that each of the NLS parameters can take.

*$OPTION

Lists the Oracle options that have been installed with the Oracle software.

*$PARAMETER

Lists all initialization parameters and their current settings. Also indicates whether the current value is specified in the initialization file or is the default value, as well as whether the parameter is modifiable with an ALTER SYSTEM or ALTER SESSION command.

*$RMAN_CONFIGURATION

Lists the persistent configuration parameters for RMAN, the standard ...

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