V$PARAMETER
V$PARAMETER
displays information about the initialization parameters that are currently in effectfor the session.A new session inherits parameter values from the instance-wide values displayed by theV$SYSTEM_PARAMETER
view.
注释:该视图是当前会话级别的。
Column | Datatype | Description |
---|---|---|
NUM |
NUMBER |
Parameter number |
NAME |
VARCHAR2(80) |
Name of the parameter |
TYPE |
NUMBER |
Parameter type:
|
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 theVALUE column shows the value262144 for a big integer parameter, then theDISPLAY_VALUE column will show the value256K . |
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 ) |
ISSES_MODIFIABLE |
VARCHAR2(5) |
Indicates whether the parameter can be changed withALTER SESSION (TRUE ) or not (FALSE ) |
ISSYS_MODIFIABLE |
VARCHAR2(9) |
Indicates whether the parameter can be changed withALTER SYSTEM and when the change takes effect:
|