Qodex.ai

Gets SQL plan baseline configuration details.

GET {{baseUrl}}/managedDatabases/:managedDatabaseId/sqlPlanBaselineConfiguration

Gets the configuration details of SQL plan baselines for the specified Managed Database. The details include the settings for the capture and use of SQL plan baselines, SPM Evolve Advisor task, and SQL Management Base.

HEADERS

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

RESPONSES

status: OK

{"isAutomaticInitialPlanCaptureEnabled":"\u003cboolean\u003e","isSqlPlanBaselinesUsageEnabled":"\u003cboolean\u003e","isAutoSpmEvolveTaskEnabled":"\u003cboolean\u003e","isHighFrequencyAutoSpmEvolveTaskEnabled":"\u003cboolean\u003e","planRetentionWeeks":"\u003cinteger\u003e","spaceBudgetPercent":"\u003cfloat\u003e","autoCaptureFilters":[{"modifiedBy":"\u003cstring\u003e","name":"AUTO_CAPTURE_MODULE","timeLastModified":"\u003cdateTime\u003e","valuesToExclude":["\u003cstring\u003e","\u003cstring\u003e"],"valuesToInclude":["\u003cstring\u003e","\u003cstring\u003e"]},{"modifiedBy":"\u003cstring\u003e","name":"AUTO_CAPTURE_ACTION","timeLastModified":"\u003cdateTime\u003e","valuesToExclude":["\u003cstring\u003e","\u003cstring\u003e"],"valuesToInclude":["\u003cstring\u003e","\u003cstring\u003e"]}],"autoSpmEvolveTaskParameters":{"allowedTimeLimit":"\u003cinteger\u003e","alternatePlanBaselines":["AUTO","AUTO"],"alternatePlanLimit":"\u003cinteger\u003e","alternatePlanSources":["CURSOR_CACHE","SQL_TUNING_SET"],"arePlansAutoAccepted":"\u003cboolean\u003e"},"spaceBudgetMB":"\u003cfloat\u003e","spaceUsedMB":"\u003cfloat\u003e"}