Get a specific database parameter
get
/database/parameters/{name}
Returns the corresponding record from GV$SYSTEM_PARAMETER. A client requires SQL Administrator role to invoke this service.
Request
Supported Media Types
- application/json
Path Parameters
-
name: string
Name of the parameter.
Response
Supported Media Types
- application/json
200 Response
Information on a specific database parameter.
Root Schema : DatabaseParametersItem
Type:
object
This documentation represents an initialization parameter that is currently in effect for the instance. A new session inherits parameter values from the instance-wide values. The list of attributes may vary depending on database version.
Show Source
-
con_id(optional):
integer
The ID of the container to which the data pertains.
-
default_value(optional):
string
The default value for this parameter. This is the value of the parameter if a value is not explicitly specified for the parameter.
-
description(optional):
string
Description of the parameter.
-
display_value(optional):
string
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.
-
hash(optional):
integer
Hash value for the parameter name.
-
inst_id(optional):
integer
Instance number from which the associated GV$SYSTEM_PARAMETER view information was obtained.
-
isadjusted(optional):
string
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).
-
isbasic(optional):
string
Indicates whether the parameter is a basic parameter (TRUE) or not (FALSE).
-
isdefault(optional):
string
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).
-
isdeprecated(optional):
string
Indicates whether the parameter has been deprecated (TRUE) or not (FALSE).
-
isinstance_modifiable(optional):
string
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(optional):
string
Indicates how the parameter was modified. If an ALTER SYSTEM was performed, the value will be MODIFIED.
-
ispdb_modifiable(optional):
string
Indicates whether the parameter can be modified inside a PDB (TRUE) or not (FALSE). In a non-CDB, the value of this column is NULL.
-
isses_modifiable(optional):
string
Indicates whether the parameter can be changed with ALTER SESSION (TRUE) or not (FALSE).
-
issys_modifiable(optional):
string
Indicates whether the parameter can be changed with ALTER SYSTEM and when the change takes effect.
-
links(optional):
array links
-
name(optional):
string
Name of the parameter.
-
num(optional):
integer
Parameter number.
-
type(optional):
integer
Parameter type.
-
update_comment(optional):
string
Comments associated with the most recent update.
-
value(optional):
string
Instance-wide parameter value.