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

KeyDatatypeRequiredDescription
sourcestringThe 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.
namestringA filter to return all parameters that have the text given in their names.
isAllowedValuesIncludedbooleanWhen true, results include a list of valid values for parameters (if applicable).
sortBystringThe field to sort information by. Only one sortOrder can be used. The
default sort order for NAME is ascending and it is case-sensitive.
sortOrderstringThe option to sort information in ascending (‘ASC’) or descending (‘DESC’) order. Ascending order is the default order.

HEADERS

KeyDatatypeRequiredDescription
opc-request-idstringThe client request ID for tracing.
opc-named-credential-idstringThe OCID of the Named Credential.
Acceptstring

RESPONSES

status: OK

{&quot;databaseName&quot;:&quot;\u003cstring\u003e&quot;,&quot;databaseType&quot;:&quot;EXTERNAL_RAC&quot;,&quot;databaseSubType&quot;:&quot;ADB&quot;,&quot;databaseVersion&quot;:&quot;\u003cstring\u003e&quot;,&quot;items&quot;:[{&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;type&quot;:&quot;BIG_INTEGER&quot;,&quot;value&quot;:&quot;\u003cstring\u003e&quot;,&quot;displayValue&quot;:&quot;\u003cstring\u003e&quot;,&quot;allowedValues&quot;:[{&quot;isDefault&quot;:&quot;\u003cboolean\u003e&quot;,&quot;ordinal&quot;:&quot;\u003cnumber\u003e&quot;,&quot;value&quot;:&quot;\u003cstring\u003e&quot;},{&quot;isDefault&quot;:&quot;\u003cboolean\u003e&quot;,&quot;ordinal&quot;:&quot;\u003cnumber\u003e&quot;,&quot;value&quot;:&quot;\u003cstring\u003e&quot;}],&quot;category&quot;:&quot;\u003cstring\u003e&quot;,&quot;constraint&quot;:&quot;UNIQUE&quot;,&quot;containerId&quot;:&quot;\u003cnumber\u003e&quot;,&quot;description&quot;:&quot;\u003cstring\u003e&quot;,&quot;isAdjusted&quot;:&quot;\u003cboolean\u003e&quot;,&quot;isBasic&quot;:&quot;\u003cboolean\u003e&quot;,&quot;isDefault&quot;:&quot;\u003cboolean\u003e&quot;,&quot;isDeprecated&quot;:&quot;\u003cboolean\u003e&quot;,&quot;isInstanceModifiable&quot;:&quot;\u003cboolean\u003e&quot;,&quot;isModified&quot;:&quot;FALSE&quot;,&quot;isPdbModifiable&quot;:&quot;\u003cboolean\u003e&quot;,&quot;isSessionModifiable&quot;:&quot;\u003cboolean\u003e&quot;,&quot;isSpecified&quot;:&quot;\u003cboolean\u003e&quot;,&quot;isSystemModifiable&quot;:&quot;DEFERRED&quot;,&quot;number&quot;:&quot;\u003cnumber\u003e&quot;,&quot;ordinal&quot;:&quot;\u003cnumber\u003e&quot;,&quot;sid&quot;:&quot;\u003cstring\u003e&quot;,&quot;updateComment&quot;:&quot;\u003cstring\u003e&quot;},{&quot;name&quot;:&quot;\u003cstring\u003e&quot;,&quot;type&quot;:&quot;INTEGER&quot;,&quot;value&quot;:&quot;\u003cstring\u003e&quot;,&quot;displayValue&quot;:&quot;\u003cstring\u003e&quot;,&quot;allowedValues&quot;:[{&quot;isDefault&quot;:&quot;\u003cboolean\u003e&quot;,&quot;ordinal&quot;:&quot;\u003cnumber\u003e&quot;,&quot;value&quot;:&quot;\u003cstring\u003e&quot;},{&quot;isDefault&quot;:&quot;\u003cboolean\u003e&quot;,&quot;ordinal&quot;:&quot;\u003cnumber\u003e&quot;,&quot;value&quot;:&quot;\u003cstring\u003e&quot;}],&quot;category&quot;:&quot;\u003cstring\u003e&quot;,&quot;constraint&quot;:&quot;NONE&quot;,&quot;containerId&quot;:&quot;\u003cnumber\u003e&quot;,&quot;description&quot;:&quot;\u003cstring\u003e&quot;,&quot;isAdjusted&quot;:&quot;\u003cboolean\u003e&quot;,&quot;isBasic&quot;:&quot;\u003cboolean\u003e&quot;,&quot;isDefault&quot;:&quot;\u003cboolean\u003e&quot;,&quot;isDeprecated&quot;:&quot;\u003cboolean\u003e&quot;,&quot;isInstanceModifiable&quot;:&quot;\u003cboolean\u003e&quot;,&quot;isModified&quot;:&quot;FALSE&quot;,&quot;isPdbModifiable&quot;:&quot;\u003cboolean\u003e&quot;,&quot;isSessionModifiable&quot;:&quot;\u003cboolean\u003e&quot;,&quot;isSpecified&quot;:&quot;\u003cboolean\u003e&quot;,&quot;isSystemModifiable&quot;:&quot;IMMEDIATE&quot;,&quot;number&quot;:&quot;\u003cnumber\u003e&quot;,&quot;ordinal&quot;:&quot;\u003cnumber\u003e&quot;,&quot;sid&quot;:&quot;\u003cstring\u003e&quot;,&quot;updateComment&quot;:&quot;\u003cstring\u003e&quot;}]}