Lists database parameters.
GET {{baseUrl}}/managedDatabases/:managedDatabaseId/databaseParameters?source=CURRENT&name=<string>&isAllowedValuesIncluded=false&sortBy=NAME&sortOrder=ASC
Gets the list of database parameters for the specified Managed Database. The parameters are listed in alphabetical order, along with their current values.
Request Params
| Key | Datatype | Required | Description |
|---|---|---|---|
source | string | The source used to list database parameters. CURRENT is used to get the | |
| database parameters that are currently in effect for the database | |||
instance. SPFILE is used to list parameters from the server parameter | |||
file. Default is CURRENT. | |||
name | string | A filter to return all parameters that have the text given in their names. | |
isAllowedValuesIncluded | boolean | When true, results include a list of valid values for parameters (if applicable). | |
sortBy | string | The field to sort information by. Only one sortOrder can be used. The | |
default sort order for NAME is ascending and it is case-sensitive. | |||
sortOrder | string | The option to sort information in ascending (‘ASC’) or descending (‘DESC’) order. Ascending order is the default order. |
HEADERS
| Key | Datatype | Required | Description |
|---|---|---|---|
opc-request-id | string | The client request ID for tracing. | |
opc-named-credential-id | string | The OCID of the Named Credential. | |
Accept | string |
RESPONSES
status: OK
{"databaseName":"\u003cstring\u003e","databaseType":"EXTERNAL_RAC","databaseSubType":"ADB","databaseVersion":"\u003cstring\u003e","items":[{"name":"\u003cstring\u003e","type":"BIG_INTEGER","value":"\u003cstring\u003e","displayValue":"\u003cstring\u003e","allowedValues":[{"isDefault":"\u003cboolean\u003e","ordinal":"\u003cnumber\u003e","value":"\u003cstring\u003e"},{"isDefault":"\u003cboolean\u003e","ordinal":"\u003cnumber\u003e","value":"\u003cstring\u003e"}],"category":"\u003cstring\u003e","constraint":"UNIQUE","containerId":"\u003cnumber\u003e","description":"\u003cstring\u003e","isAdjusted":"\u003cboolean\u003e","isBasic":"\u003cboolean\u003e","isDefault":"\u003cboolean\u003e","isDeprecated":"\u003cboolean\u003e","isInstanceModifiable":"\u003cboolean\u003e","isModified":"FALSE","isPdbModifiable":"\u003cboolean\u003e","isSessionModifiable":"\u003cboolean\u003e","isSpecified":"\u003cboolean\u003e","isSystemModifiable":"DEFERRED","number":"\u003cnumber\u003e","ordinal":"\u003cnumber\u003e","sid":"\u003cstring\u003e","updateComment":"\u003cstring\u003e"},{"name":"\u003cstring\u003e","type":"INTEGER","value":"\u003cstring\u003e","displayValue":"\u003cstring\u003e","allowedValues":[{"isDefault":"\u003cboolean\u003e","ordinal":"\u003cnumber\u003e","value":"\u003cstring\u003e"},{"isDefault":"\u003cboolean\u003e","ordinal":"\u003cnumber\u003e","value":"\u003cstring\u003e"}],"category":"\u003cstring\u003e","constraint":"NONE","containerId":"\u003cnumber\u003e","description":"\u003cstring\u003e","isAdjusted":"\u003cboolean\u003e","isBasic":"\u003cboolean\u003e","isDefault":"\u003cboolean\u003e","isDeprecated":"\u003cboolean\u003e","isInstanceModifiable":"\u003cboolean\u003e","isModified":"FALSE","isPdbModifiable":"\u003cboolean\u003e","isSessionModifiable":"\u003cboolean\u003e","isSpecified":"\u003cboolean\u003e","isSystemModifiable":"IMMEDIATE","number":"\u003cnumber\u003e","ordinal":"\u003cnumber\u003e","sid":"\u003cstring\u003e","updateComment":"\u003cstring\u003e"}]}