NUM

NUMBER

Parameter number

NAME

VARCHAR2(64)

Name of the parameter

TYPE

NUMBER

Parameter type:

• 1 - Boolean
• 2 - String
• 3 - Integer
• 4 - Parameter file
• 5 - Reserved
• 6 - Big integer

VALUE

VARCHAR2(512)

Parameter value for the session (if modified within the session); otherwise, the instance-wide parameter value

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

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 - Parameter has not been modified after instance startup

ISADJUSTED

VARCHAR2(5)

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)

DESCRIPTION

VARCHAR2(64)

Description of the parameter

UPDATE_COMMENT

VARCHAR2(255)

Comments associated with the most recent update