Qodex.ai

Database Management API

Number of APIs: 223

Use the Database Management API to monitor and manage resources such as Oracle Databases, MySQL Databases, and External Database Systems. For more information, see Database Management.

  1. managedDatabases-{managedDatabaseId}-sqlPlanBaselines-actions-changePlanRetention - Changes the retention period of unused plans. POST {{baseUrl}}/managedDatabases/:managedDatabaseId/sqlPlanBaselines/actions/changePlanRetention

  2. managedDatabases-{managedDatabaseId}-sqlTuningAdvisorTasks-{sqlTuningAdvisorTaskId}-executionPlanStatsComparision - Retrieve a comparison of the existing SQL execution plan and new plan. GET {{baseUrl}}/managedDatabases/:managedDatabaseId/sqlTuningAdvisorTasks/:sqlTuningAdvisorTaskId/executionPlanStatsComparision?sqlObjectId=<long>&executionId=<long>

  3. managedDatabases-{managedDatabaseId}-actions-cloneSqlTuningTask - Clone and run a SQL tuning task in the database POST {{baseUrl}}/managedDatabases/:managedDatabaseId/actions/cloneSqlTuningTask

  4. externalDbSystems-{externalDbSystemId} - Gets the external DB system details. GET {{baseUrl}}/externalDbSystems/:externalDbSystemId

  5. databaseHomeMetrics - Gets a summary of the activity and resource usage metrics for a Managed Database. GET {{baseUrl}}/databaseHomeMetrics?managedDatabaseId=<string>&startTime=<string>&endTime=<string>

  6. dbManagementPrivateEndpoints - Gets a list of Database Management private endpoints. GET {{baseUrl}}/dbManagementPrivateEndpoints?compartmentId=<string>&name=<string>&vcnId=<string>&isCluster=false&lifecycleState=FAILED&limit=10&page=<string>&sortOrder=ASC&sortBy=TIMECREATED

  7. externalAsmInstances - Lists the external ASM instances. GET {{baseUrl}}/externalAsmInstances?compartmentId=<string>&externalAsmId=<string>&displayName=<string>&page=<string>&limit=10&sortBy=TIMECREATED&sortOrder=ASC

  8. externalAsms-{externalAsmId}-metrics - Gets the external ASM metrics. GET {{baseUrl}}/externalAsms/:externalAsmId/metrics?page=<string>&limit=10&startTime=<string>&endTime=<string>&filterByMetricNames=<string>

  9. externalAsms-{externalAsmId}-diskGroups - Lists the external ASM disk groups. GET {{baseUrl}}/externalAsms/:externalAsmId/diskGroups?page=<string>&limit=10&sortBy=NAME&sortOrder=ASC

  10. externalDbSystemDiscoveries - Lists the external DB system discovery resources. GET {{baseUrl}}/externalDbSystemDiscoveries?compartmentId=<string>&displayName=<string>&page=<string>&limit=10&sortBy=TIMECREATED&sortOrder=ASC