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