V$PARAMETER、V$SYSTEM_PARAMETER 解释及同基表 x$ 的匹配关系
V$PARAMETER(取值基表 SYS.X$KSPPI X, SYS.X$KSPPCV Y)
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.
V$PARAMETER 显示影响当前 session 的参数配置,新 session 从 V$SYSTEM_PARAMETER 视图继承参数值
V$SYSTEM_PARAMETER (取值基表 SYS.X$KSPPI X, SYS.X$KSPPSV Y)
V$SYSTEM_PARAMETER displays information about the initialization parameters that are currently in effect for the instance. A new session inherits parameter values from the instance-wide values.
V$SYSTEM_PARAMETER 显示影响当前实例的参数配置,新 session 也将继承这些值
两个视图的字段设置一致
Column | Datatype | Description |
---|---|---|
NUM |
NUMBER |
Parameter number |
NAME |
VARCHAR2(80) |
Name of the parameter |
TYPE |
NUMBER |
Parameter type:- 1 - Boolean - 2 - String - 3 - Integer - 4 - Parameter file - 5 - Reserved - 6 - Big integer |
VALUE |
VARCHAR2(4000) |
Parameter value for the session (if modified within the session); otherwise, the instance-wide parameter value |
DISPLAY_VALUE |
VARCHAR2(4000) |
Parameter value in a user-friendly format. For example, if the VALUE column shows the value 262144 for a big integer parameter, then the DISPLAY_VALUE column will show the value 256K . |
DEFAULT_VALUE |
VARCHAR2(255) |
The default value for this parameter. This is the value of the parameter if a value is not explicitly specified for the parameter. |
ISDEFAULT |
VARCHAR2(9) |
Indicates whether the parameter is set to the default value (TRUE ) or the parameter value was specified in the parameter file (FALSE ).The database sets the value of the ISDEFAULT column to TRUE for parameters that are not specified in the init.ora or server parameter file (SPFILE). |
ISSES_MODIFIABLE |
VARCHAR2(5) |
Indicates whether the parameter can be changed with ALTER SESSION (TRUE ) or not (FALSE ) |
ISSYS_MODIFIABLE |
VARCHAR2(9) |
Indicates whether the parameter can be changed with ALTER SYSTEM and when the change takes effect: - 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. - 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. - 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. |
ISPDB_MODIFIABLE |
VARCHAR2(5) |
Indicates whether the parameter can be modified inside a PDB (TRUE ) or not (FALSE ) |
ISINSTANCE_MODIFIABLE |
VARCHAR2(5) |
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 . |
ISMODIFIED |
VARCHAR2(10) |
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 - Param |