Oracle Operations Insights API
The operationsInsights API from Oracle — 156 operation(s) for operationsinsights.
Oracle Operations Insights API is one of 378 APIs that Oracle publishes on the APIs.io network, described by a machine-readable OpenAPI specification.
The published artifact set on APIs.io includes an OpenAPI specification and an API reference.
This API exposes 201 operations across 156 paths, and defines 321 schemas. It is described by OpenAPI 3.2.0, at version 20200630.
Requests are made against 2 base URLs: http://127.0.0.1/20200630, https://127.0.0.1/20200630.
201 operations
156 paths
321 schemas
15 DELETE111 GET1 HEAD59 POST15 PUT
Metadata
The identity and technical contract details declared by the specification.
Paths & Operations 201
Across 156 paths, the API surfaces 201 operations — 15 DELETE, 111 GET, 1 HEAD, 59 POST, 15 PUT. Each is listed below with its method, path, parameters, and response codes.
operationsInsights 201
GET
/awrHubObjects/awrHubSources/{awrHubSourceId}/o
Gets a list of Awr Hub objects.
DELETE
/awrHubObjects/awrHubSources/{awrHubSourceId}/o/{objectName}
Deletes an Awr Hub object.
GET
/awrHubObjects/awrHubSources/{awrHubSourceId}/o/{objectName}
Gets the Awr Hub object metadata and body.
HEAD
/awrHubObjects/awrHubSources/{awrHubSourceId}/o/{objectName}
HEAD Object
PUT
/awrHubObjects/awrHubSources/{awrHubSourceId}/o/{objectName}
Upload an Awr hub Object
GET
/awrHubSources
Gets a list of Awr Hub source objects.
POST
/awrHubSources
Register Awr Hub source
DELETE
/awrHubSources/{awrHubSourceId}
Deletes an Awr Hub source object.
GET
/awrHubSources/{awrHubSourceId}
Gets the Awr Hub source object.
PUT
/awrHubSources/{awrHubSourceId}
Update Awr Hub Source object.
POST
/awrHubSources/{awrHubSourceId}/actions/changeCompartment
Moves a resource into a different compartment.
POST
/awrHubSources/{awrHubSourceId}/actions/disable
Disables a Awr Hub source database in Operations Insights.
POST
/awrHubSources/{awrHubSourceId}/actions/enable
Enables a Awr Hub source database in Operations Insights.
GET
/awrHubs
Gets a list of AWR hubs.
POST
/awrHubs
Create an Awr hub resource
DELETE
/awrHubs/{awrHubId}
Deletes an AWR hub.
GET
/awrHubs/{awrHubId}
Gets details of an AWR hub.
PUT
/awrHubs/{awrHubId}
Updates the configuration of a hub .
GET
/awrHubs/{awrHubId}/awrDatabaseCpuUsages
Summarizes AWR CPU usage data.
GET
/awrHubs/{awrHubId}/awrDatabaseMetrics
Summarizes metric samples for the specified database.
GET
/awrHubs/{awrHubId}/awrDatabaseParameterChanges
Summarize the AWR database parameter change history.
GET
/awrHubs/{awrHubId}/awrDatabaseParameters
Summarize AWR datbase parameter history information.
GET
/awrHubs/{awrHubId}/awrDatabaseReport
Gets the AWR database report.
GET
/awrHubs/{awrHubId}/awrDatabaseSnapshotRanges
Summarizes AWR snapshot ranges.
GET
/awrHubs/{awrHubId}/awrDatabaseSnapshots
List the AWR snapshots for specified database.
GET
/awrHubs/{awrHubId}/awrDatabaseSqlReport
Gets the SQL health check report for the SQL statement specified by the SQL ID. The parameter to filter SQL by ID. Note that the SQL ID is generated internally by Oracle for each SQL statement and ca…
GET
/awrHubs/{awrHubId}/awrDatabaseSysstats
Summarizes AWR Sysstat sample data for specified database.
GET
/awrHubs/{awrHubId}/awrDatabaseTopWaitEvents
Summarizes AWR top N wait events.
GET
/awrHubs/{awrHubId}/awrDatabaseWaitEventBuckets
Summarize AWR event data into value buckets and frequencies for specified database.
GET
/awrHubs/{awrHubId}/awrDatabaseWaitEvents
Summarizes AWR wait event sample data.
GET
/awrHubs/{awrHubId}/awrDatabases
Gets a list of AWR database information.
GET
/awrHubs/{awrHubId}/awrReport
Gets the AWR report for the specified source database in the AWR hub.
GET
/awrHubs/{awrHubId}/awrSnapshots
Lists AWR snapshots for the specified source database in the AWR hub.
GET
/awrHubs/{awrHubId}/awrSourcesSummary
Gets a list of summary of AWR Sources.
GET
/chargebackPlanReport
Gets a list of Ops Insights chargeback plan reports for a resource.
POST
/chargebackPlanReport
Creates a chargeback plan report for a resource in Ops Insights.
DELETE
/chargebackPlanReport/{chargebackPlanReportId}
Deletes a chargeback plan report
GET
/chargebackPlanReport/{chargebackPlanReportId}
Gets the details of the specified chargeback plan report for a resource
PUT
/chargebackPlanReport/{chargebackPlanReportId}
Updates one or more attributes of the specified chargeback plan report.
GET
/chargebackPlanReport/{chargebackPlanReportId}/content
Generates the chargeback report in csv format for a given resource
GET
/chargebackPlans
Gets a list of Ops Insights chargeback plans.
POST
/chargebackPlans
Create an Ops Insights chargeback plan resource
DELETE
/chargebackPlans/{chargebackplanId}
Deletes a chargeback plan.
GET
/chargebackPlans/{chargebackplanId}
Gets the details of the specified chargeback plan
PUT
/chargebackPlans/{chargebackplanId}
Updates one or more attributes of the specified chargeback plan.
POST
/chargebackPlans/{chargebackplanId}/actions/changeCompartment
Moves a resource into a different compartment.
GET
/databaseInsights
Gets a list of database insights.
POST
/databaseInsights
Create a Database Insight resource for a database in Operations Insights.
POST
/databaseInsights/actions/ingestAddmReports
Accepts the addm reports payload and persists it in Operation Insights ingest pipeline.
POST
/databaseInsights/actions/ingestDatabaseConfiguration
Accepts the database configuration metrics payload and persists it in the Ops Insights Service.
POST
/databaseInsights/actions/ingestMySqlSqlStatsMetric
Accepts the MySql SQL Stats metrics payload and persists it in Ops Insights ingest pipeline.
POST
/databaseInsights/actions/ingestMySqlSqlText
Accepts the sql text metrics payload and persists it in Operation Insights ingest pipeline.
POST
/databaseInsights/actions/ingestSqlBucket
Accepts the bucket metrics payload and persists it in Ops Insights ingest pipeline.
POST
/databaseInsights/actions/ingestSqlPlanLines
Accepts the sql plan lines payload and persists it in Operation Insights ingest pipeline.
POST
/databaseInsights/actions/ingestSqlStatsMetric
Accepts the SQL Stats metrics payload and persists it in Ops Insights ingest pipeline.
POST
/databaseInsights/actions/ingestSqlText
Accepts the sql text metrics payload and persists it in Operation Insights ingest pipeline.
POST
/databaseInsights/actions/testMacsManagedCloudDatabaseInsightConnectionDetails
Test the connection details of a Cloud MACS-managed database.
GET
/databaseInsights/addmDbFindingCategories
Gets list of ADDM finding categories
GET
/databaseInsights/addmDbFindings
Summarizes ADDM findings for the specified databases
GET
/databaseInsights/addmDbFindingsTimeSeries
Get the ADDM findings time series for the specified databases.
GET
/databaseInsights/addmDbParameterCategories
Gets list of ADDM database parameter categories
GET
/databaseInsights/addmDbParameterChanges
Summarizes the AWR database parameter change history
GET
/databaseInsights/addmDbParameters
Summarizes database parameter history information
GET
/databaseInsights/addmDbRecommendationCategories
Gets list of ADDM recommendation categories
GET
/databaseInsights/addmDbRecommendations
Summarizes ADDM recommendations for the specified databases
GET
/databaseInsights/addmDbRecommendationsTimeSeries
Gets time series data for ADDM recommendations for the specified databases
GET
/databaseInsights/addmDbSchemaObjects
Summarizes Schema objects for the specified databases for the specified objectIdentifiers
GET
/databaseInsights/addmDbSqlStatements
Summarizes SQL Statements for the specified databases for the specified sqlIdentifiers
GET
/databaseInsights/addmDbs
Gets a list of ADDM database information
GET
/databaseInsights/databaseConfigurations
Gets a list of database insights configuration.
GET
/databaseInsights/resourceCapacityTrend
Get base and maximum capacity for a resource type.
GET
/databaseInsights/resourceForecastTrend
Get Forecast predictions for host resources.
GET
/databaseInsights/resourceStatistics
Lists the Resource statistics for each database
GET
/databaseInsights/resourceUsageSummary
Get aggregated usage, capacity and usage change percentage summed across databases for the current time period.
GET
/databaseInsights/resourceUsageTrend
Gets aggregate usage and capacity for a resource type.
GET
/databaseInsights/resourceUtilizationInsight
Gets current and projected utilization insights.
GET
/databaseInsights/sqlInsights
Get performance Insights for SQLs across databases.
GET
/databaseInsights/sqlPlanInsights
Get performance insights on execution plans for a SQL.
GET
/databaseInsights/sqlPlans
List the plan xml for a SQL execution plan
GET
/databaseInsights/sqlResponseTimeDistributions
Summarize response time distribution of query executions for a SQL
GET
/databaseInsights/sqlSearches
Search SQL by SQL Identifier across databases.
GET
/databaseInsights/sqlStatistics
Get performance statistics for SQLs across databases.
GET
/databaseInsights/sqlStatisticsTimeSeries
Get performance statistics time series for a SQL across one or more databases
GET
/databaseInsights/sqlStatisticsTimeSeriesByPlan
Get performance statistics time series for a SQL by execution plans
GET
/databaseInsights/sqlTexts
Get SQL Text for a SQL
GET
/databaseInsights/tablespaceUsageTrend
Gets tablespace usage metrics for a database.
DELETE
/databaseInsights/{databaseInsightId}
Deletes a database insight.
GET
/databaseInsights/{databaseInsightId}
Gets details of a database insight.
PUT
/databaseInsights/{databaseInsightId}
Updates configuration of a database insight.
POST
/databaseInsights/{databaseInsightId}/actions/changeAutonomousDatabaseInsightAdvancedFeatures
Update advanced features for Autonomous Database in Operations Insights.
POST
/databaseInsights/{databaseInsightId}/actions/changeCompartment
Moves a resource into a different compartment.
POST
/databaseInsights/{databaseInsightId}/actions/changeExternalMysqlDatabaseInsightConnectionDetailsdeprecated
Change the connection details of a External Mysql database insight.
POST
/databaseInsights/{databaseInsightId}/actions/changeMacsManagedCloudDatabaseInsightConnectionDetails
Change the connection details of a Cloud MACS-managed database insight.
POST
/databaseInsights/{databaseInsightId}/actions/changePeComanagedDatabaseInsightDetails
Change the connection details or private endpoint of co managed database insight.
POST
/databaseInsights/{databaseInsightId}/actions/disable
Disables a database in Operations Insights.
POST
/databaseInsights/{databaseInsightId}/actions/disableAutonomousDatabaseInsightAdvancedFeatures
Disable advanced features for an Autonomous Database in Operations Insights.
POST
/databaseInsights/{databaseInsightId}/actions/enable
Enables a database in Operations Insights.
POST
/databaseInsights/{databaseInsightId}/actions/enableAutonomousDatabaseInsightAdvancedFeatures
Enables advanced features for an Autonomous Database in Operations Insights.
GET
/enterpriseManagerBridges
Gets a list of Ops Insights Enterprise Manager bridges.
POST
/enterpriseManagerBridges
Create a Enterprise Manager bridge in Operations Insights.
DELETE
/enterpriseManagerBridges/{enterpriseManagerBridgeId}
Deletes an Operations Insights Enterprise Manager bridge.
GET
/enterpriseManagerBridges/{enterpriseManagerBridgeId}
Gets details of an Operations Insights Enterprise Manager bridge.
PUT
/enterpriseManagerBridges/{enterpriseManagerBridgeId}
Updates configuration of an Operations Insights Enterprise Manager bridge.
POST
/enterpriseManagerBridges/{enterpriseManagerBridgeId}/actions/changeCompartment
Moves a resource into a different compartment.
GET
/enterpriseManagerBridges/{enterpriseManagerBridgeId}/importableEnterpriseManagerEntities
Gets a list of importable entities for an Operations Insights Enterprise Manager bridge that have not been imported before.
GET
/exadataInsights
Gets a list of Exadata insights.
POST
/exadataInsights
Create an Exadata insight resource for an Exadata system in Operations Insights.
GET
/exadataInsights/exadataConfigurations
Gets a list of exadata insights configuration.
GET
/exadataInsights/exadataMembers
Gets software and hardware inventory for an exadata insight resource.
GET
/exadataInsights/resourceCapacityTrend
Gets capacity for an exadata system. Either compartmentId or exadataInsightsId query parameter must be specified.
GET
/exadataInsights/resourceCapacityTrendAggregated
Gets capacity for an exadata system. Either compartmentId or exadataInsightsId query parameter must be specified.
GET
/exadataInsights/resourceForecastTrend
Get historical usage and forecast predictions for an exadata system with breakdown by databases, hosts,storage servers or diskgroup.
GET
/exadataInsights/resourceForecastTrendAggregated
Get aggregated historical usage and forecast predictions for exadata systems.
GET
/exadataInsights/resourceStatistics
Lists the Resource statistics for each resource/member of the Exadata System (database, hosts, storage server or diskgroup).
GET
/exadataInsights/resourceUsageSummary
Get usage, capacity and usage change percentage for exadata systems for the current time period.
GET
/exadataInsights/resourceUsageSummaryAggregated
Get aggregated usage, capacity and usage change percentage summed across exadata systems for the current time period.
GET
/exadataInsights/resourceUtilizationInsight
Gets current utilization and projected insights for an exadata system.
DELETE
/exadataInsights/{exadataInsightId}
Deletes an Exadata insight.
GET
/exadataInsights/{exadataInsightId}
Gets details of an Exadata insight.
PUT
/exadataInsights/{exadataInsightId}
Updates configuration of an Exadata insight.
POST
/exadataInsights/{exadataInsightId}/actions/addMembers
Add new members (e.g. databases and hosts) to an Exadata system in Operations Insights.
POST
/exadataInsights/{exadataInsightId}/actions/changeCompartment
Moves a resource into a different compartment.
POST
/exadataInsights/{exadataInsightId}/actions/disable
Disables an Exadata system in Operations Insights.
POST
/exadataInsights/{exadataInsightId}/actions/disablePlan
Disables a chargeback plan on an Exadata system in Operations Insights.
POST
/exadataInsights/{exadataInsightId}/actions/enable
Enables an Exadata system in Operations Insights.
POST
/exadataInsights/{exadataInsightId}/actions/enablePlan
Enables a chargeback plan on an Exadata system in Operations Insights.
GET
/hostInsights
Gets a list of host insights.
POST
/hostInsights
Create a Host Insight resource for a host in Ops Insights.
POST
/hostInsights/actions/ingestHostConfiguration
Accepts the host configuration metrics payload and persists it in the Ops Insights ingest pipeline.
POST
/hostInsights/actions/ingestHostMetrics
Accepts the host performance metrics payload and persists it in the Ops Insights ingest pipeline.
GET
/hostInsights/diskStatistics
Gets disk(s) statistics for a host.
GET
/hostInsights/hostConfigurations
Gets a list of host insights configuration.
GET
/hostInsights/hostRecommendation
Gets recommendations for a host.
GET
/hostInsights/hostedEntities
Gets a list of hosted entities details based on the query parameters specified.
GET
/hostInsights/ioUsageTrend
Gets IO usage metrics for a host.
GET
/hostInsights/resourceCapacityTrend
Gets capacity for a resource type.
GET
/hostInsights/resourceForecastTrend
Get Forecast predictions for host resources.
GET
/hostInsights/resourceStatistics
Lists the resource statistics for each host.
GET
/hostInsights/resourceUsageSummary
Get aggregated CPU, or memory usage, capacity and usage change percentage summed across hosts for the current time period.
GET
/hostInsights/resourceUsageTrend
Gets aggregate usage and capacity for a resource type.
GET
/hostInsights/resourceUtilizationInsight
Gets current and projected utilization insights.
GET
/hostInsights/topProcessesUsage
Gets top processes usage metrics for a host on a specific date.
GET
/hostInsights/topProcessesUsageTrend
Gets top processes usage metrics for a host.
DELETE
/hostInsights/{hostInsightId}
Deletes a host insight.
GET
/hostInsights/{hostInsightId}
Gets details of a host insight.
PUT
/hostInsights/{hostInsightId}
Updates configuration of a host insight.
POST
/hostInsights/{hostInsightId}/actions/changeCompartment
Moves a resource into a different compartment.
POST
/hostInsights/{hostInsightId}/actions/disable
Disables a host in Ops Insights.
POST
/hostInsights/{hostInsightId}/actions/enable
Enables a host in Ops Insights.
GET
/importableAgentEntities
Gets a list of agent entities available to add a new hostInsight
GET
/importableComputeEntities
Gets a list of compute instances running OCA available to add a new hostInsight
GET
/kubeClusterInsights
Gets a list of Kubernetes cluster insights.
POST
/kubeClusterInsights
Create an Kubernetes cluster insight resource for a Kubernetes Cluster in Ops Insights.
DELETE
/kubeClusterInsights/{kubeClusterInsightId}
Deletes a Kubernetes cluster insight.
GET
/kubeClusterInsights/{kubeClusterInsightId}
Gets details of a Kubernetes cluster insight.
PUT
/kubeClusterInsights/{kubeClusterInsightId}
Updates configuration of a Kubernetes cluster insight.
POST
/kubeClusterInsights/{kubeClusterInsightId}/actions/changeCompartment
Moves a resource into a different compartment.
POST
/kubeClusterInsights/{kubeClusterInsightId}/actions/disable
Disables a Kubernetes cluster in Ops Insights.
POST
/kubeClusterInsights/{kubeClusterInsightId}/actions/enable
Enables a Kubernetes cluster in Ops Insights.
GET
/newsReports
Gets a list of news reports.
POST
/newsReports
Create a news report in Ops Insights.
DELETE
/newsReports/{newsReportId}
Deletes a news report.
GET
/newsReports/{newsReportId}
Gets details of a news report.
PUT
/newsReports/{newsReportId}
Updates the configuration of a news report.
POST
/newsReports/{newsReportId}/actions/changeCompartment
Moves a resource into a different compartment.
GET
/operationsInsightsPrivateEndpoints
Gets a list of Operation Insights private endpoints.
POST
/operationsInsightsPrivateEndpoints
Create an Operation Insights private endpoint resource
DELETE
/operationsInsightsPrivateEndpoints/{operationsInsightsPrivateEndpointId}
Deletes a private endpoint.
GET
/operationsInsightsPrivateEndpoints/{operationsInsightsPrivateEndpointId}
Gets the details of the specified private endpoint.
PUT
/operationsInsightsPrivateEndpoints/{operationsInsightsPrivateEndpointId}
Updates one or more attributes of the specified private endpoint.
POST
/operationsInsightsPrivateEndpoints/{operationsInsightsPrivateEndpointId}/actions/changeCompartment
Moves a private endpoint into a different compartment.
GET
/operationsInsightsWarehouseUsers
Gets a list of Operations Insights Warehouse Users.
POST
/operationsInsightsWarehouseUsers
This is the endpoint for creating an Operations Insights Warehouse user
DELETE
/operationsInsightsWarehouseUsers/{operationsInsightsWarehouseUserId}
Deletes an Operations Insights Warehouse User.
GET
/operationsInsightsWarehouseUsers/{operationsInsightsWarehouseUserId}
Gets details of an Operations Insights Warehouse User.
PUT
/operationsInsightsWarehouseUsers/{operationsInsightsWarehouseUserId}
Updates the configuration of an Operations Insights Warehouse User.
GET
/operationsInsightsWarehouses
Gets a list of Ops Insights warehouses.
POST
/operationsInsightsWarehouses
Create an Ops Insights Warehouse
DELETE
/operationsInsightsWarehouses/{operationsInsightsWarehouseId}
Deletes an Operations Insights Warehouse.
GET
/operationsInsightsWarehouses/{operationsInsightsWarehouseId}
Gets details of an Ops Insights Warehouse.
PUT
/operationsInsightsWarehouses/{operationsInsightsWarehouseId}
Updates the configuration of an Ops Insights Warehouse.
POST
/operationsInsightsWarehouses/{operationsInsightsWarehouseId}/actions/changeCompartment
Moves a resource into a different compartment.
POST
/operationsInsightsWarehouses/{operationsInsightsWarehouseId}/actions/downloadWarehouseWallet
Download the ADW wallet for Operations Insights Warehouse using which the Hub data is exposed.
POST
/operationsInsightsWarehouses/{operationsInsightsWarehouseId}/actions/rotateWarehouseWallet
Rotate the ADW wallet for Operations Insights Warehouse using which the Hub data is exposed.
GET
/operationsInsightsWarehouses/{operationsInsightsWarehouseId}/resourceUsageSummary
Gets the details of resources used by an Operations Insights Warehouse.
GET
/opsiConfigurations
Gets a list of OPSI configuration resources.
POST
/opsiConfigurations
Create an OPSI configuration resource.
GET
/opsiConfigurations/configurationItems
Gets the applicable configuration items.
DELETE
/opsiConfigurations/{opsiConfigurationId}
Deletes an OPSI configuration resource.
GET
/opsiConfigurations/{opsiConfigurationId}
Gets details of an OPSI configuration resource.
PUT
/opsiConfigurations/{opsiConfigurationId}
Updates an OPSI configuration resource with the given ID.
POST
/opsiConfigurations/{opsiConfigurationId}/actions/changeCompartment
Moves a resource into a different compartment.
GET
/opsiDataObjects
Gets a list of OPSI data objects.
POST
/opsiDataObjects/actions/queryData
Queries data from an OPSI data object.
GET
/opsiDataObjects/{opsiDataObjectIdentifier}
Gets details of an OPSI data object.
GET
/workRequests
List work requests
GET
/workRequests/{workRequestId}
Gets work request status
GET
/workRequests/{workRequestId}/errors
Lists work request errors
GET
/workRequests/{workRequestId}/logs
Lists work request logs
POST
/{warehouseType}/{warehouseId}/actions/queryData
Queries data from Warehouse data objects (e.g: views, tables).
GET
/{warehouseType}/{warehouseId}/dataObjects
Gets a list of Warehouse data objects (e.g: views, tables).
Schemas 321
The contract defines 321 schemas that model the data the API accepts and returns. The most detailed are SqlStats (66 properties), SqlPlanLine (39 properties), MySqlSqlStats (33 properties), AwrHubSourceSummary (23 properties). Each schema is shown below with its type and property counts.
SqlPlanCollection
object
SQL Plans for the particular SQL.
4 properties
4 required
AddmDbRecommendationCategorySummary
object
Recommendation category summary
3 properties
3 required
DataObjectBindParameter
object
Details for a bind parameter used in data object query.
3 properties
3 required
NewsContentTypes
object
Content types that the news report can handle.
7 properties
SummarizeHostInsightsTopProcessesUsageCollection
object
Top level response object.
2 properties
2 required
DataObjectColumnMetadata
object
Metadata of a column in a data object resultset.
8 properties
1 required
SummarizeHostInsightIoUsageTrendAggregationCollection
object
Top level response object.
4 properties
4 required
UpdateConfigurationItemDetails
object
Configuration item details for OPSI configuration update.
1 property
1 required
IngestMySqlSqlStatsResponseDetails
object
The response object returned from IngestMySqlSqlStats operation.
1 property
1 required
CredentialDetails
object
User credential details to connect to the database.
2 properties
1 required
AddmDbSchemaObjectCollection
object
Summarizes Schema Objects over specified time period
4 properties
4 required
AwrDatabaseWaitEventBucketSummary
object
A summary of the AWR wait event bucket and waits percentage.
2 properties
2 required
ChargebackPlanSummary
object
Summary of a Ops Insights chargeback plan.
16 properties
11 required
SqlResponseTimeDistributionAggregationCollection
object
SQL response time distribution over the selected time window.
6 properties
6 required
ChangeAwrHubSourceCompartmentDetails
object
The information to be updated.
1 property
1 required
HostConfigurationMetricGroup
object
Base Metric Group for Host configuration metrics
2 properties
2 required
OpsiDataObject
object
OPSI data object.
9 properties
4 required
IngestSqlTextResponseDetails
object
The response object returned from IngestSqlTextDetails operation.
1 property
1 required
UpdateNewsReportDetails
object
The information about the news report to be updated.
11 properties
AwrDatabaseParameterChangeCollection
object
The AWR database parameter change history.
SqlSearchSummary
object
Database summary object resulting from a sql search operation.
7 properties
7 required
ExadataInsightResourceCapacityTrendAggregation
object
Resource Capacity samples
3 properties
2 required
SqlText
object
SQL Text type object.
7 properties
4 required
ChangeExternalMysqlDatabaseInsightConnectionDetails
object
MySQL support within the OCI Ops Insights service has been deprecated as of January 29, 2026. Connection details of an External MySQL database insight.
1 property
1 required
ChargebackPlanReportCollection
object
A collection of chargeback plan reports objects.
1 property
1 required
WorkRequestErrorCollection
object
Results of a workRequestError search. Contains both WorkRequestError items and other information, such as metadata.
1 property
1 required
AddmDbRecommendationCategoryCollection
object
List of recommendation categories
2 properties
2 required
SqlPlanLine
object
SQL Plan Line type object.
39 properties
5 required
AddmDbParameterAggregation
object
Summarizes change history for specific database parameter
10 properties
3 required
ProjectedDataItem
object
The timestamp of the projected event and their corresponding resource value. highValue and lowValue are the uncertainty bounds of the corresponding value.
4 properties
4 required
ChangeChargebackPlanCompartmentDetails
object
The information to be updated.
1 property
1 required
ChangeOperationsInsightsWarehouseCompartmentDetails
object
The information to be updated.
1 property
1 required
IngestSqlPlanLinesResponseDetails
object
The response object returned from IngestSqlPlanLines operation.
1 property
1 required
TopProcessesUsage
object
Aggregated data for top processes on a specific date.
15 properties
13 required
EnableAutonomousDatabaseInsightAdvancedFeaturesDetails
object
The advanced feature details for autonomous database to be enabled.
3 properties
2 required
ResourceUsageTrendAggregation
object
Aggregate usage samples
4 properties
3 required
WorkRequestLogEntry
object
A log message from the execution of a work request.
2 properties
2 required
DatabaseInsightsCollection
object
Collection of database insight summary objects.
1 property
1 required
SummarizeDatabaseInsightResourceUsageTrendAggregationCollection
object
Top level response object.
6 properties
6 required
IngestSqlStatsResponseDetails
object
The response object returned from IngestSqlStats operation.
1 property
1 required
ReportGroupingDetails
object
Report groupings
2 properties
2 required
ChangeEnterpriseManagerBridgeCompartmentDetails
object
The information to be updated.
1 property
1 required
HostPerformanceMetricGroup
object
Base Metric Group for Host performance metrics
2 properties
2 required
WarehouseDataObjectDetails
object
Warehouse data object details.
1 property
1 required
IngestSqlStatsDetails
object
Collection of SQL Stats Metric Entries
1 property
ChangeHostInsightCompartmentDetails
object
The information to be updated.
1 property
1 required
AwrDatabaseMetricCollection
object
The AWR metrics time series summary data.
WorkRequest
object
A description of workrequest status
9 properties
7 required
DatabaseConfigurationMetricGroup
object
Supported configuration metric groups for database capacity planning service.
2 properties
1 required
SqlInsightAggregation
object
Represents a SQL Insight.
3 properties
3 required
SqlPlanInsightAggregation
object
SQL execution plan Performance statistics.
5 properties
5 required
OpsiConfigurationsCollection
object
Collection of OPSI configuration summary objects.
1 property
1 required
ResourceStatistics
object
Contains resource statistics with usage unit
10 properties
4 required
OperationsInsightsPrivateEndpointCollection
object
A collection of Operation Insights private endpoint objects.
1 property
1 required
AwrDatabaseSnapshotCollection
object
The list of AWR snapshots for one database.
HostResourceCapacityTrendAggregation
object
Host Resource Capacity samples
2 properties
2 required
WorkRequestResource
object
A resource created or operated on by a work request.
5 properties
3 required
SummarizeHostInsightResourceUtilizationInsightAggregation
object
Insights response containing current/projected groups for CPU or memory.
7 properties
7 required
OperationsInsightsWarehouseSummaryCollection
object
Collection of Operations Insights Warehouse summary objects.
1 property
1 required
ExadataInsightResourceStatisticsAggregation
object
Contains resource details and current statistics
1 property
1 required
AwrDatabaseSysstatSummary
object
The summary of the AWR SYSSTAT data.
6 properties
1 required
HostInsight
object
Host insight resource.
15 properties
9 required
OperationsInsightsWarehouseUserSummary
object
Summary of a Operations Insights Warehouse User.
15 properties
7 required
ListObjects
object
List of the objects.
3 properties
1 required
OpsiDataObjectQueryParam
object
Details for a query parameter to be applied on an OPSI data object, when a data object query is executed.
2 properties
2 required
SummarizeDatabaseInsightResourceCapacityTrendAggregationCollection
object
Collection of resource capacity trend.
8 properties
8 required
SqlTextSummary
object
SQL Text details
5 properties
4 required
ConnectionDetails
object
Connection details to connect to the database. HostName, protocol, and port should be specified.
4 properties
4 required
AddmDbFindingAggregationCollection
object
Summarizes ADDM findings over specified time period
4 properties
4 required
AwrDatabaseCpuUsageCollection
object
The AWR CPU usage data.
ChangeOperationsInsightsPrivateEndpointCompartmentDetails
object
The details used to change the compartment of a Operation Insights private endpoint.
1 property
SqlStats
object
Sql Stats type object.
66 properties
4 required
SummarizeDatabaseInsightResourceForecastTrendAggregation
object
Forecast results from the selected time period.
11 properties
10 required
ConfigurationItemSummary
object
Configuration item summary.
1 property
1 required
SqlPlanInsights
object
Represents collection of SQL Plan Insights.
3 properties
3 required
SqlResponseTimeDistributionAggregation
object
SQL Response time distribution entry.
2 properties
2 required
OperationsInsightsPrivateEndpointSummary
object
Summary of a Operation Insights private endpoint.
15 properties
7 required
AwrDatabaseParameterSummary
object
The summary of the AWR change history data for a single database parameter.
7 properties
1 required
OpsiConfiguration
object
OPSI configuration.
13 properties
1 required
ResourceInsightCurrentUtilization
object
Current utilization(High/low) for cpu or storage
2 properties
AwrDatabaseSnapshotSummary
object
The AWR snapshot summary of one snapshot.
7 properties
2 required
CreateNewsReportDetails
object
The information about the news report to be created.
12 properties
7 required
AddmDbFindingAggregation
object
Summarizes a specific ADDM finding
11 properties
10 required
ResourceCapacityTrendAggregation
object
Resource Capacity samples
4 properties
3 required
ImportableComputeEntitySummaryCollection
object
Collection of importable compute entity objects.
1 property
1 required
SummarizeExadataInsightResourceStatisticsAggregationCollection
object
Returns list of the resources with resource statistics like usage,capacity,utilization and usage change percent.
7 properties
6 required
SqlInventory
object
Inventory details.
3 properties
3 required
SqlStatistics
object
Performance statistics for the SQL.
19 properties
19 required
AwrDatabaseMetricSummary
object
The summary of the AWR metric data for a particular metric at a specific time.
5 properties
1 required
IngestSqlBucketDetails
object
Collection of SQL Bucket Metric Entries
1 property
ChargebackPlanReport
object
A chargeback plan report that allows Ops Insights services to showcase chargeback costs.
7 properties
7 required
AddmDbRecommendationsTimeSeriesCollection
object
ADDM recommendations time series
4 properties
4 required
CreateExadataInsightDetails
object
The information about the Exadata system to be analyzed.
4 properties
2 required
ChangeMacsManagedCloudDatabaseInsightConnectionDetails
object
Connection details of a MACS-managed cloud database insight.
3 properties
3 required
OpsiDataObjectSummary
object
Summary of an OPSI data object.
6 properties
3 required
SqlBucket
object
Sql bucket type object.
11 properties
4 required
CreatePlanCustomItemDetails
object
Custom configuration item details for a chargeback plan. Example items for Exadata Insights Chargeback are statistic(default value AVG), percentile, infrastruc…
3 properties
IngestHostConfigurationResponseDetails
object
The response object returned from IngestHostConfiguration operation.
1 property
1 required
CreateOperationsInsightsPrivateEndpointDetails
object
The details used to create a new Operation Insights private endpoint.
10 properties
5 required
SummarizeDatabaseInsightTablespaceUsageTrendAggregationCollection
object
Top level response object.
5 properties
5 required
AwrDatabaseWaitEventCollection
object
The AWR wait event data.
WorkRequestError
object
An error encountered while executing a work request.
3 properties
3 required
AwrHubSource
object
Awr hub source object
23 properties
10 required
DownloadOperationsInsightsWarehouseWalletDetails
object
Download Wallet details.
1 property
1 required
SummarizeDatabaseInsightResourceUtilizationInsightAggregation
object
Insights response containing current/projected groups for storage or CPU.
7 properties
7 required
ImportableAgentEntitySummaryCollection
object
Collection of importable agent entity objects.
1 property
1 required
UpdateEnterpriseManagerBridgeDetails
object
The information to be updated.
4 properties
SummarizeExadataInsightResourceCapacityTrendAggregation
object
Collection of resource capacity trend.
7 properties
7 required
SqlStatisticsTimeSeriesAggregationCollection
object
SQL performance statistics over the selected time window.
6 properties
5 required
AwrReport
object
The result of the AWR report.
2 properties
1 required
MySqlSqlStats
object
MySql Sql Stats type object.
33 properties
2 required
ExadataInsightResourceCapacityTrendSummary
object
List of resource id, name , capacity time series data
3 properties
3 required
UpdateOperationsInsightsWarehouseUserDetails
object
The information to be updated.
6 properties
ChargebackPlanDetails
object
Object containing chargeback plan details
3 properties
EnterpriseManagerBridge
object
Enterprise Manager bridge resource.
13 properties
9 required
DatabaseDetails
object
Partial information about the database which includes id, name, type.
9 properties
5 required
AwrDatabaseCpuUsageSummary
object
A summary of the AWR CPU resource limits and metrics.
2 properties
MySqlSqlText
object
MySql SQL Text type object.
5 properties
3 required
IngestSqlTextDetails
object
Collection of SQL Text Entries
1 property
OpsiDataObjectDetailsInQuery
object
Details for OPSI data object used in a data object query.
2 properties
1 required
CreateKubeClusterInsightDetails
object
The information about the Kubernetes cluster system to be analyzed.
9 properties
7 required
AddmReport
object
ADDM Tasks.
7 properties
7 required
AddmDbParameterCategoryCollection
object
List of database parameter categories
2 properties
2 required
NewsReport
object
News report resource.
18 properties
5 required
IngestDatabaseConfigurationResponseDetails
object
The response object returned from IngestDatabaseConfiguration operation.
1 property
1 required
HostDetails
object
Partial information about a host which includes id, name, type.
6 properties
5 required
IngestHostConfigurationDetails
object
Contains the data to ingest for one or more host configuration metrics
1 property
1 required
AddmDbSummary
object
ADDM summary for a database
10 properties
1 required
CreateChargebackPlanReportDetails
object
The details used to create a new Ops Insights chargeback plan report.
2 properties
2 required
KubeClusterInsightSummaryCollection
object
Collection of Kubernetes cluster insight summary objects.
1 property
1 required
ImportableEnterpriseManagerEntityCollection
object
Collection of importable Enterprise Manager entity objects.
1 property
1 required
ResourceStatisticsAggregation
object
Contains database details and resource statistics
2 properties
TopProcessesUsageTrend
object
Aggregated data for top processes
13 properties
12 required
UpdateAwrHubSourceDetails
object
Awr hub source update object information
3 properties
AddmDbCollection
object
The result of ADDM databases
3 properties
3 required
NewsReportCollection
object
Collection of news reports summary objects.
1 property
1 required
AwrHubSourceSummaryCollection
object
Collection of Awr Hub sources.
1 property
1 required
UpdateChargebackPlanReportDetails
object
The details used to update a Ops Insights chargeback plan report.
2 properties
2 required
AddmDbFindingsTimeSeriesCollection
object
ADDM findings time series response.
4 properties
4 required
EnablePlanExadataInsightDetails
object
The information about the chargeback plan to be enabled.
1 property
1 required
OperationsInsightsWarehouseSummary
object
Summary of a Operations Insights Warehouse resource.
17 properties
7 required
HostConfigurationCollection
object
Collection of host insight configuration summary objects.
1 property
1 required
CreateConfigurationItemDetails
object
Configuration item details for OPSI configuration creation.
1 property
1 required
ChangeOpsiConfigurationCompartmentDetails
object
The information used to change the compartment of an OPSI configuration resource.
1 property
1 required
EnableExadataInsightDetails
object
The information about the Exadata system to be analyzed.
1 property
1 required
DataObjectColumnUnit
object
Unit details of a data object column.
2 properties
1 required
UpdateDatabaseInsightDetails
object
The information to be updated.
3 properties
1 required
ChangePeComanagedDatabaseInsightDetails
object
Details of a Private Endpoint co-managed database insight.
4 properties
3 required
ChangeAutonomousDatabaseInsightAdvancedFeaturesDetails
object
Advanced feature details of autonomous database insight.
3 properties
2 required
DatabaseConfigurationSummary
object
Summary of a database configuration for a resource.
12 properties
11 required
IoUsageTrend
object
Usage data for IO interface per usage unit.
6 properties
6 required
QueryWarehouseDataObjectDataDetails
object
Information required to form and execute Operations Insights Warehouse data objects query.
1 property
1 required
SqlPlanInsightAggregationCollection
object
SQL plan insights response.
7 properties
7 required
AddmDbSqlStatementSummary
object
Details for a given SQL ID
5 properties
5 required
OperationsInsightsWarehouse
object
OPSI warehouse resource.
17 properties
6 required
AwrDatabaseSysstatCollection
object
The AWR SYSSTAT time series summary data.
SummarizeHostInsightsTopProcessesUsageTrendCollection
object
Top level response object.
3 properties
3 required
HostInsightSummary
object
Summary of a host insight resource.
16 properties
4 required
IngestMySqlSqlStatsDetails
object
Collection of MySql SQL Stats Metric Entries
1 property
TopProcessesUsageTrendAggregation
object
Usage data per host top process
3 properties
2 required
SummarizeDatabaseInsightResourceUsageAggregation
object
Resource usage summation for the current time period
8 properties
7 required
IngestDatabaseConfigurationDetails
object
Database Configuration Metrics details.
1 property
1 required
KubeClusterInsight
object
Kubernetes cluster insight resource.
18 properties
9 required
AwrDatabaseWaitEventSummary
object
The summary of the AWR wait event time series data for one event.
6 properties
1 required
IngestHostMetricsDetails
object
Contains the data to ingest for one or more host performance metrics
1 property
1 required
SummarizeHostInsightResourceForecastTrendAggregation
object
Forecast results from the selected time period.
10 properties
9 required
QueryDataObjectResultSetRowsCollection
object
Collection of result set rows from the data object query.
1 property
1 required
SqlStatisticAggregation
object
SQL Statistics
4 properties
3 required
AwrSourceSummary
object
Summary of an AwrSource.
9 properties
9 required
SummarizeHostInsightResourceUsageAggregation
object
Resource usage summation for the current time period.
7 properties
7 required
CreateEnterpriseManagerBridgeDetails
object
The information about a Enterprise Manager bridge resource to be created
6 properties
3 required
EnterpriseManagerBridgeCollection
object
Collection of Enterprose Manager bridge summary objects.
1 property
1 required
HostInstanceMap
object
Object containing hostname and instance name mapping.
2 properties
2 required
WorkRequestCollection
object
Results of a workRequest search. Contains both WorkRequest items and other information, such as metadata.
1 property
1 required
ResourceFilters
object
Information to filter the actual target resources in an operation. e.g: While querying a DATABASEINSIGHTSDATAOBJECT using /opsiDataObjects/actions/queryData AP…
5 properties
SummarizeHostInsightHostRecommendationAggregation
object
Returns list of hosts with resource statistics like usage, capacity, utilization, usage change percent and load.
6 properties
5 required
CreateChargebackPlanDetails
object
The details used to create a new Ops Insights chargeback plan.
8 properties
4 required
ExadataMemberSummary
object
Lists name, display name and type of exadata member.
3 properties
3 required
CreateHostInsightDetails
object
The information about the host to be analyzed.
4 properties
2 required
WarehouseDataObjectCollection
object
Collection of Warehouse data object summary objects.
1 property
1 required
AddExadataInsightMembersDetails
object
The information about the members of Exadata system to be added.
1 property
1 required
AddmDbParameterCategorySummary
object
Database parameter category summary
3 properties
3 required
ResourceUsageSummary
object
Contains resource usage summary
7 properties
5 required
IngestSqlPlanLinesDetails
object
Collection of SQL Plan Line Entries
1 property
AwrDatabaseCollection
object
The result of AWR query.
SummarizeExadataInsightResourceUtilizationInsightAggregation
object
Insights response containing utilization values for exadata systems.
7 properties
7 required
AddmDbParameterChangeAggregationCollection
object
Summarizes AWR parameter change history over specified time period for specified parameter
4 properties
4 required
IngestAddmReportsResponseDetails
object
The response object returned from IngestAddmReports operation.
1 property
1 required
OpsiDataObjectSupportedQueryParam
object
Details of query parameter supported by an OPSI data object.
3 properties
1 required
EnableHostInsightDetails
object
The information about the host to be analyzed.
1 property
1 required
CreateOperationsInsightsWarehouseDetails
object
The information about a Operations Insights Warehouse resource to be created. Input compartmentId MUST be the root compartment.
6 properties
3 required
AwrDatabaseParameterChangeSummary
object
A summary of the changes made to a single AWR database parameter.
8 properties
1 required
AddmDbParameterAggregationCollection
object
Summarizes AWR parameter change history over specified time period
4 properties
4 required
OperationsInsightsPrivateEndpoint
object
A private endpoint that allows Operation Insights services to connect to databases in a customer's virtual cloud network (VCN).
17 properties
6 required
IngestSqlBucketResponseDetails
object
The response object returned from IngestSqlBucketDetails operation.
1 property
1 required
SummarizeExadataInsightResourceForecastTrendCollection
object
Usage and Forecast results with breakdown by databases, hosts or storage servers.
7 properties
7 required
SummarizeHostInsightResourceCapacityTrendAggregationCollection
object
Top level response object.
8 properties
8 required
UpdateExadataInsightDetails
object
The information to be updated.
3 properties
1 required
ChangeNewsReportCompartmentDetails
object
The information to be updated.
1 property
1 required
SummarizeHostInsightsDiskStatisticsCollection
object
Top level response object.
5 properties
5 required
AwrDatabaseReport
object
The result of the AWR report.
AddmDbRecommendationAggregationCollection
object
Summarizes ADDM recommendations over specified time period
4 properties
4 required
AwrHubSourceSummary
object
Awr hub source object
23 properties
10 required
AwrQueryResult
object
The AWR query result.
4 properties
2 required
CreateOpsiConfigurationDetails
object
Information about OPSI configuration to be created.
8 properties
1 required
CreateAwrHubSourceDetails
object
payload to register Awr Hub source
8 properties
4 required
UpdateAwrHubDetails
object
The information to be updated.
3 properties
AddmDbFindingCategorySummary
object
Finding category summary
3 properties
3 required
OperationsInsightsWarehouseUser
object
OPSI warehouse User.
15 properties
7 required
AwrSnapshotCollection
object
The list of AWR snapshots for one database.
1 property
1 required
ImportableEnterpriseManagerEntity
object
An Enterprise Manager entity that can be imported into Operations Insights.
5 properties
4 required
UpdateHostInsightDetails
object
The information to be updated.
3 properties
1 required
ChargebackPlanCollection
object
A collection of Ops Insights chargeback plan objects.
1 property
1 required
EnableKubeClusterInsightDetails
object
The information about the Kubernetes cluster to be analyzed.
1 property
1 required
ChangeDatabaseInsightCompartmentDetails
object
The information to be updated.
1 property
1 required
TestMacsManagedCloudDatabaseInsightConnectionDetails
object
Connection details of a MACS-managed cloud database .
3 properties
3 required
AwrDatabaseWaitEventBucketCollection
object
The percentage distribution of waits in the AWR wait event buckets.
ExadataMemberCollection
object
Partial definition of the exadata insight resource.
6 properties
6 required
SqlStatisticsTimeSeriesAggregation
object
Database details and SQL performance statistics for a given database
2 properties
2 required
AwrHubSummaryCollection
object
Collection of Hub resources.
1 property
1 required
SqlTextCollection
object
SQL Text for the particular SQL.
1 property
1 required
KubeClusterNodePool
object
A group of compute instances in the K8s cluster that serves as worker nodes for running K8s applications.
3 properties
EnableDatabaseInsightDetails
object
The information about database to be analyzed.
1 property
1 required
OpsiDataObjectsCollection
object
Collection of OPSI data object summary objects.
1 property
1 required
AwrHubSummary
object
Summary Hub resource.
13 properties
7 required
ImportableAgentEntitySummary
object
An agent entity that can be imported into Operations Insights.
3 properties
3 required
IngestHostMetricsResponseDetails
object
The response object returned from IngestHostMetrics operation.
1 property
1 required
ExadataInsightResourceForecastTrendSummary
object
List of resource id, name , capacity insight value, pattern, historical usage and projected data.
7 properties
6 required
AwrDatabaseSummary
object
The AWR summary for a database.
12 properties
2 required
OpsiConfigurationConfigurationItemSummary
object
Configuration item summary.
1 property
1 required
ChargebackPlanReportSummary
object
Summary of a Ops Insights chargeback plan report
7 properties
7 required
SummarizeHostInsightResourceStatisticsAggregationCollection
object
Returns list of hosts with resource statistics like usage, capacity, utilization, usage change percent and load.
7 properties
7 required
DatabaseInsightSummary
object
Summary of a database insight resource.
19 properties
3 required
OperationsInsightsWarehouseUserSummaryCollection
object
Collection of Operations Insights Warehouse User summary objects.
1 property
1 required
TablespaceUsageTrend
object
Usage data samples
3 properties
3 required
NewsContentTypesResource
string
Supported resources for the news report content types.
ExadataInsight
object
Exadata insight resource.
18 properties
9 required
WorkRequestLogEntryCollection
object
Results of a workRequestLog search. Contains both workRequestLog items and other information, such as metadata.
1 property
1 required
IngestMySqlSqlTextResponseDetails
object
The response object returned from IngestMySqlSqlTextDetails operation.
1 property
1 required
ReportPropertyDetails
object
Chargeback plan report properties.
4 properties
4 required
NewsReportSummary
object
Summary of a news report resource.
18 properties
4 required
WarehouseDataObjectSummary
object
Summary of a Warehouse data object.
4 properties
1 required
ObjectSummary
object
Summary resource object.
8 properties
DiskStatistics
object
Aggregated data per disk.
4 properties
4 required
AwrDatabaseSqlReport
object
The result of the AWR SQL report.
ImportableComputeEntitySummary
object
A compute entity that can be imported into Operations Insights.
4 properties
4 required
PeComanagedDatabaseHostDetails
object
Input Host Details used for connection requests for private endpoint accessed db resource.
2 properties
ExadataInsightResourceInsightUtilizationItem
object
Object containing current utilization, projected utilization, id and daysToReach high and low utilization value.
6 properties
5 required
Error
object
An error has occurred.
2 properties
2 required
TablespaceUsageTrendAggregation
object
Usage data per tablespace for a Pluggable database
3 properties
3 required
AwrHub
object
Awr Hub resource.
14 properties
7 required
SummarizeAwrSourcesSummariesCollection
object
Collection of AwrSource summary objects.
1 property
1 required
PeComanagedDatabaseConnectionDetails
object
Connection details of the private endpoints.
3 properties
1 required
RelatedObjectTypeDetails
object
Related object details
1 property
1 required
HostInsightHostRecommendations
object
Contains recommendations depending of resource metric received.
1 property
1 required
SqlPlanSummary
object
SQL Plan details
2 properties
2 required
EnterpriseManagerBridgeSummary
object
Summary of a Enterprise Manager bridge resource.
12 properties
9 required
AddmDbFindingsTimeSeriesSummary
object
ADDM findings time series data
16 properties
11 required
HostedEntitySummary
object
Information about a hosted entity which includes identifier, name, and type.
3 properties
3 required
IngestAddmReportsDetails
object
Collection of Addm reports
1 property
1 required
AddmDbRecommendationsTimeSeriesSummary
object
ADDM recommendation
13 properties
4 required
SummarizeExadataInsightResourceUsageCollection
object
Resource usage , allocation, utilization and usage ChangePercent for the current time period
6 properties
6 required
QueryOpsiDataObjectDataDetails
object
Information required to form and execute query on an OPSI data object.
4 properties
1 required
AwrSnapshotSummary
object
The AWR snapshot summary of one snapshot.
7 properties
2 required
VmClusterSummary
object
Partial information about the VM Cluster which includes name, memory allocated etc.
4 properties
1 required
CreateAwrHubDetails
object
The information about Hub to be analyzed. Input compartmentId MUST be the root compartment.
6 properties
3 required
SqlStatisticsTimeSeriesByPlanAggregationCollection
object
SQL performance statistics by plan over the selected time window.
8 properties
8 required
SummarizeHostInsightResourceUsageTrendAggregationCollection
object
Top level response object.
6 properties
6 required
CreateDatabaseInsightDetails
object
The information about database to be analyzed.
4 properties
2 required
ExadataInsightSummaryCollection
object
Collection of Exadata insight summary objects.
1 property
1 required
AddmDbSqlStatementCollection
object
Summarizes SQL statements over specified time period
4 properties
4 required
ResourceInsightProjectedUtilizationItem
object
Projected utilization object containing dbid and daysToReach value
2 properties
2 required
ChangeKubeClusterInsightCompartmentDetails
object
The information to be updated.
1 property
1 required
IngestMySqlSqlTextDetails
object
Collection of SQL Text Entries
1 property
SqlStatisticAggregationCollection
object
SQL statistics response.
3 properties
3 required
AwrDatabaseTopWaitEventSummary
object
A summary of the AWR top wait event data for one event.
3 properties
1 required
ExadataConfigurationSummary
object
Summary of a exadata configuration for a resource.
12 properties
11 required
SummarizeOperationsInsightsWarehouseResourceUsageAggregation
object
Details of resource usage by an Operations Insights Warehouse resource.
4 properties
2 required
HostInsightResourceStatisticsAggregation
object
Contains host details and resource statistics.
2 properties
2 required
CreateOperationsInsightsWarehouseUserDetails
object
The information about a Operations Insights Warehouse User to be created. Input compartmentId MUST be the root compartment.
9 properties
5 required
AwrDatabaseParameterCollection
object
The AWR database parameter data.
ConfigurationItemsCollection
object
Collection of configuration item summary objects.
2 properties
1 required
SummarizeDatabaseInsightResourceStatisticsAggregationCollection
object
Returns list of the Databases with resource statistics like usage, capacity, utilization and usage change percent.
7 properties
7 required
SummarizeExadataInsightResourceCapacityTrendCollection
object
capacity results with breakdown by databases, hosts, storage servers or diskgroup.
7 properties
7 required
IoUsageTrendAggregation
object
Usage data per io interface.
2 properties
2 required
ExadataInsightSummary
object
Summary of an Exadata insight resource.
17 properties
9 required
SummarizeExadataInsightResourceUsageAggregation
object
Resource usage summation for the current time period
9 properties
8 required
DataObjectQuery
object
Information required to form and execute query on a data object.
3 properties
1 required
UpdateOperationsInsightsPrivateEndpointDetails
object
The details used to update a Operation Insights private endpoint.
6 properties
UpdateOpsiConfigurationDetails
object
Information to be updated in OPSI configuration resource.
7 properties
1 required
HostConfigurationSummary
object
Summary of a host configuration for a resource.
23 properties
20 required
HistoricalDataItem
object
The historical timestamp and the corresponding resource value.
2 properties
2 required
AwrDatabaseTopWaitEventCollection
object
The AWR top wait event data.
ExadataConfigurationCollection
object
Collection of exadata insight configuration summary objects.
1 property
1 required
AddmDbFindingCategoryCollection
object
List of finding categories
2 properties
2 required
HostResourceStatistics
object
Contains host resource base statistics.
5 properties
5 required
UpdateOperationsInsightsWarehouseDetails
object
The information to be updated.
5 properties
SqlStatisticsTimeSeries
object
SQL performance statistics per database
2 properties
2 required
AwrDatabaseSnapshotRangeCollection
object
The AWR snapshot range list.
DatabaseInsight
object
Database insight resource.
15 properties
8 required
ChangeExadataInsightCompartmentDetails
object
The information to be updated.
1 property
1 required
KubeClusterInsightSummary
object
Summary of a Kubernetes cluster insight resource.
18 properties
11 required
OpsiConfigurationSummary
object
OPSI configuration summary.
12 properties
1 required
HostedEntityCollection
object
Returns a list of hosted entities for the specific host.
3 properties
3 required
SqlSearchCollection
object
Search SQL response.
5 properties
3 required
HostInsightSummaryCollection
object
Collection of host insight summary objects.
1 property
1 required
SqlInsightAggregationCollection
object
SQL Insights response.
5 properties
5 required
ResourceInsightProjectedUtilization
object
Projected utilization(High/low) for cpu or storage
2 properties
2 required
SqlStatisticsTimeSeriesByPlanAggregation
object
SQL performance statistics for a given plan
2 properties
2 required
NewsSqlInsightsContentTypesResource
string
Supported resources for the news report content types.
ChargebackPlan
object
A chargeback plan that allows Ops Insights services to compute chargeback costs.
16 properties
6 required
SqlInsightThresholds
object
Inventory details.
7 properties
7 required
AddmDbParameterChangeAggregation
object
Change record for AWR database parameter
7 properties
5 required
DatabaseConfigurationCollection
object
Collection of database insight configuration summary objects.
1 property
1 required
AwrDatabaseSnapshotRangeSummary
object
The summary data for a range of AWR snapshots.
InstanceMetrics
object
Object containing instance metrics.
7 properties
AddmDbSchemaObjectSummary
object
Details for a given object id
6 properties
5 required
SummarizeExadataInsightResourceForecastTrendAggregation
object
Usage and Forecast results from the selected time period.
10 properties
9 required
AddmDbRecommendationAggregation
object
Summarizes a specific ADDM recommendation
11 properties
2 required
UpdateKubeClusterInsightDetails
object
The information to be updated.
8 properties
1 required
UpdateChargebackPlanDetails
object
The details used to update a Ops Insights chargeback plan.
5 properties
Specification
The full machine-readable OpenAPI contract behind this narrative.
Source
More from Oracle 12
Other APIs Oracle publishes across the network.
Oracle Database REST APIs
Oracle Integration Cloud API
Oracle Fusion Cloud Applications API
Oracle Fusion Cloud Financials REST API
Oracle Fusion Cloud HCM REST API
Oracle Fusion Cloud CX Sales and Service REST API
Oracle Fusion Cloud SCM REST API
Oracle Fusion Cloud Procurement REST API
Oracle Content Management API
OCI Generative AI API
OCI AI Vision API
OCI AI Language API
Where this information came from
This is an independent, third-party profile of Oracle Operations Insights API, published by API Evangelist. We do not operate, host, resell, or support these APIs, and we are not affiliated with or endorsed by the company unless stated above. Everything here is built from publicly available information — the company's own site, developer portal, documentation, public repositories, and the specifications it publishes for public use. Nothing is obtained by breaching a system, defeating an access control, or using credentials.
The Kin Score and Agent Readiness rating are independently calculated assessments of a company's public API artifacts, scored against a published rubric. They are not certifications, endorsements, security assessments, or audits.
Corrections, re-scores, and removal are free — no partnership or purchase required, and you do not need to justify the request. A removed company is recorded as unrated, never scored zero for having asked. Acknowledgement within one business day; removal within two.
info@apievangelist.com
·
Read the full data-sourcing policy →
On a security or compliance team? Put security in the subject line and
you will get a person, not a form — we will tell you exactly which public URLs this profile was built from.