Shulou(Shulou.com)06/01 Report--

V$PARAMETER displays information about the initialization parameters that are currently in effect for the session. A new session inherits parameter values from the instance-wide values displayed by the

V$SYSTEM_PARAMETER view.

1. Whether ISDEFAULT is the default value

Indicates whether the parameter is set to the default value (TRUE) or the parameter value was specified in the parameter file (FALSE)

2. Whether ISSES_MODIFIABLE can be modified at the SESSION level

Indicates whether the parameter can be changed with ALTER SESSION (TRUE) or not (FALSE)

3. Whether ISSYS_MODIFIABLE can be modified at the SYSTEM level

Indicates whether the parameter can be changed with ALTER SYSTEM and when the change takes effect:

# effective immediately for all SESSION

IMMEDIATE-Parameter can be changed with

ALTER SYSTEM regardless of the type of parameter file used to start the instance. The change takes effect immediately.

# effective for the SESSION created after the modification is completed

DEFERRED-Parameter can be changed with

ALTER SYSTEM regardless of the type of parameter file used to start the instance. The change takes effect in subsequent sessions.

# you need to restart the instance to take effect

FALSE-Parameter cannot be changed with

ALTER SYSTEM unless a server parameter file was used to start the instance. The change takes effect in subsequent instances.

4. Whether different nodes of ISINSTANCE_MODIFIABLE cluster can set different parameter values.

For parameters that can be changed with ALTER SYSTEM, indicates whether the value of the parameter can be different for every instance (TRUE) or whether the parameter must have the same value for all Real Application Clusters instances (FALSE). If the ISSYS_MODIFIABLE column is FALSE, then this column is always FALSE.

5. Whether the ISMODIFIED parameter has been modified and the level of modification

Indicates whether the parameter has been modified after instance startup:

MODIFIED-Parameter has been modified with

ALTER SESSION

SYSTEM_MOD-Parameter has been modified with

ALTER SYSTEM (which causes all the currently logged in sessions' values to be modified)

FALSE-Parameter has not been modified after instance startup

6. ISADJUSTED

Indicates whether Oracle adjusted the input value to a more suitable value (for example, the parameter value should be prime, but the user input a non-prime number, so Oracle adjusted the value to the next prime number)

7. ISDEPRECATED

Indicates whether the parameter has been deprecated (TRUE) or not (FALSE)

8. ISBASIC

Indicates whether the parameter is a basic parameter (TRUE) or not (FALSE)

18C new parameters

9. CON_ID Container ID

The ID of the container to which the data pertains. Possible values include:

0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

1: This value is used for rows containing data that pertain to only the root

N: Where n is the applicable container ID for the rows containing data

19C New parameters

10. Whether ISPDB_MODIFIABLE can be modified at the PDB level

Indicates whether the parameter can be modified inside a PDB (TRUE) or not (FALSE)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.