Summarize AWR datbase parameter history information.

GET {{baseUrl}}/managedDatabases/:managedDatabaseId/awrDbs/:awrDbId/awrDbParameters?instNum=<string>&beginSnIdGreaterThanOrEqualTo=<integer>&endSnIdLessThanOrEqualTo=<integer>&timeGreaterThanOrEqualTo=<dateTime>&timeLessThanOrEqualTo=<dateTime>&containerId=<integer>&name=<string>&name=<string>&nameContains=<string>&valueChanged=Y&valueDefault=TRUE&valueModified=FALSE&page=<string>&limit=1000&sortBy=IS_CHANGED&sortOrder=DESC

Summarizes the database parameter history for the specified database in AWR. This includes the list of database parameters, with information on whether the parameter values were modified within the query time range. Note that each database parameter is only listed once. Depending on the optional query parameters, the returned summary gets all the database parameters, which include:

• Each parameter whose value was changed during the time range: (valueChanged =Y)
• Each parameter whose value was unchanged during the time range: (valueChanged =N)
• Each parameter whose value was changed at the system level during the time range: (valueChanged =Y and valueModified = SYSTEM_MOD)
• Each parameter whose value was unchanged during the time range, however, the value is not the default value: (valueChanged =N and valueDefault = FALSE)

Note that this API does not return information on the number of times each database parameter has been changed within the time range. To get the database parameter value change history for a specific parameter, use the following API endpoint: /managedDatabases/{managedDatabaseId}/awrDbs/{awrDbId}/awrDbParameterChanges

Request Params

HEADERS

RESPONSES

status: OK

{"name":"\u003cstring\u003e","awrResultType":"AWRDB_DB_PARAMETER_CHANGE","dbQueryTimeInSecs":"\u003cdouble\u003e","queryKey":"\u003cstring\u003e","version":"\u003cstring\u003e","items":[{"name":"\u003cstring\u003e","beginValue":"\u003cstring\u003e","endValue":"\u003cstring\u003e","instanceNumber":"\u003cinteger\u003e","isChanged":"\u003cboolean\u003e","isDefault":"\u003cboolean\u003e","valueModified":"\u003cstring\u003e"},{"name":"\u003cstring\u003e","beginValue":"\u003cstring\u003e","endValue":"\u003cstring\u003e","instanceNumber":"\u003cinteger\u003e","isChanged":"\u003cboolean\u003e","isDefault":"\u003cboolean\u003e","valueModified":"\u003cstring\u003e"}]}