Opsi¶
Use the Ops Insights API to perform data extraction operations to obtain database resource utilization, performance statistics, and reference information. |
|
This class provides a wrapper around |
Models¶
|
The information about the members of Exadata system to be added. |
The information about the members of Exadata system to be added. |
|
|
The information about the members of Exadata system to be added. |
The information about the members of Exadata system to be added. |
|
The result of ADDM databases |
|
Summarizes a specific ADDM finding |
|
Summarizes ADDM findings over specified time period |
|
List of finding categories |
|
Finding category summary |
|
ADDM findings time series response. |
|
ADDM findings time series data |
|
Summarizes change history for specific database parameter |
|
Summarizes AWR parameter change history over specified time period |
|
List of database parameter categories |
|
Database parameter category summary |
|
Change record for AWR database parameter |
|
Summarizes AWR parameter change history over specified time period for specified parameter |
|
Summarizes a specific ADDM recommendation |
|
Summarizes ADDM recommendations over specified time period |
|
List of recommendation categories |
|
Recommendation category summary |
|
ADDM recommendations time series |
|
ADDM recommendation |
|
Summarizes Schema Objects over specified time period |
|
Details for a given object id |
|
Summarizes SQL statements over specified time period |
|
Details for a given SQL ID |
|
ADDM summary for a database |
|
ADDM Tasks. |
|
Configuration Summary of autonomous database. |
|
Database insight resource. |
|
Summary of a database insight resource. |
|
The result of AWR query. |
|
The AWR CPU usage data. |
|
A summary of the AWR CPU resource limits and metrics. |
|
The AWR metrics time series summary data. |
|
The summary of the AWR metric data for a particular metric at a specific time. |
|
The AWR database parameter change history. |
|
A summary of the changes made to a single AWR database parameter. |
|
The AWR database parameter data. |
|
The summary of the AWR change history data for a single database parameter. |
|
The result of the AWR report. |
|
The list of AWR snapshots for one database. |
|
The AWR snapshot range list. |
|
The summary data for a range of AWR snapshots. |
|
The AWR snapshot summary of one snapshot. |
|
The result of the AWR SQL report. |
|
The AWR summary for a database. |
|
The AWR SYSSTAT time series summary data. |
|
The summary of the AWR SYSSTAT data. |
|
The AWR top wait event data. |
|
A summary of the AWR top wait event data for one event. |
|
The percentage distribution of waits in the AWR wait event buckets. |
|
A summary of the AWR wait event bucket and waits percentage. |
|
The AWR wait event data. |
|
The summary of the AWR wait event time series data for one event. |
|
Awr Hub resource. |
|
Logical grouping used for Awr Hub Object operations. |
|
Awr hub source object |
|
Awr hub source object |
|
Collection of Awr Hub sources. |
|
Logical grouping used for Awr Hub Source operations. |
|
Summary Hub resource. |
|
Collection of Hub resources. |
|
Logical grouping used for Awr Hub operations. |
|
The AWR query result. |
|
The result of the AWR report. |
|
The list of AWR snapshots for one database. |
|
The AWR snapshot summary of one snapshot. |
|
Summary of an AwrSource. |
|
Basic configuration item metadata. |
|
Basic configuration item summary. |
|
|
Advanced feature details of autonomous database insight. |
The information to be updated. |
|
The information to be updated. |
|
The information to be updated. |
|
|
The information to be updated. |
The information to be updated. |
|
|
MySQL support within the OCI Ops Insights service has been deprecated as of January 29, 2026. |
The information to be updated. |
|
|
Connection details of a MACS-managed autonomous database insight. |
|
Connection details of a MACS-managed cloud database insight. |
The information to be updated. |
|
|
The details used to change the compartment of a Operation Insights private endpoint. |
|
The information to be updated. |
The information used to change the compartment of an OPSI configuration resource. |
|
Details of a Private Endpoint co-managed database insight. |
|
A chargeback plan that allows Ops Insights services to compute chargeback costs. |
|
A collection of Ops Insights chargeback plan objects. |
|
Object containing chargeback plan details |
|
A chargeback plan report that allows Ops Insights services to showcase chargeback costs. |
|
A collection of chargeback plan reports objects. |
|
Summary of a Ops Insights chargeback plan report |
|
Summary of a Ops Insights chargeback plan. |
|
A compute host entity that can be imported into Operations Insights. |
|
Allowed value details of configuration item, to validate what value can be assigned to a configuration item. |
|
|
Allowed value details of configuration item for FREE_TEXT type. |
Allowed value details of configuration item for LIMIT type. |
|
Configuration item metadata. |
|
Allowed value details of configuration item for PICK type. |
|
Configuration item summary. |
|
Unit details of configuration item. |
|
Collection of configuration item summary objects. |
|
Connection details to connect to the database. |
|
The information about database to be analyzed. |
|
The information about Hub to be analyzed. |
|
payload to register Awr Hub source |
|
Basic configuration item details for OPSI configuration creation. |
|
The details used to create a new Ops Insights chargeback plan. |
|
The information about the exadata and chargeback plan. |
|
The details used to create a new Ops Insights chargeback plan report. |
|
Configuration item details for OPSI configuration creation. |
|
The information about database to be analyzed. |
|
|
The information about database to be analyzed. |
|
The information about the Exadata system to be analyzed. |
|
Compartment `OCID`__ of the Enterprise Manager member entity (e.g. |
The information about the EM-managed external host to be analyzed. |
|
The information about a Enterprise Manager bridge resource to be created |
|
The information about the Exadata system to be analyzed. |
|
MySQL support within the OCI Ops Insights service has been deprecated as of January 29, 2026. |
|
The information about the host to be analyzed. |
|
|
The information about database to be analyzed. |
|
The information about database to be analyzed. |
The information of the VM Cluster which contains databases. |
|
The information about the Exadata system to be analyzed. |
|
|
The information of the VM Cluster which contains databases. |
The information about the Compute Instance host to be analyzed. |
|
The information about the MACS-managed external host to be analyzed. |
|
MySQL support within the OCI Ops Insights service has been deprecated as of January 29, 2026. |
|
The information about the news report to be created. |
|
|
The details used to create a new Operation Insights private endpoint. |
The information about a Operations Insights Warehouse resource to be created. |
|
|
The information about a Operations Insights Warehouse User to be created. |
Information about OPSI configuration to be created. |
|
Information about OPSI UX configuration to be created. |
|
The information about database to be analyzed. |
|
The information about the Exadata system to be analyzed. |
|
The information of the VM Cluster which contains databases. |
|
Custom configuration item details for a chargeback plan. |
|
IAM Credential Details to connect to the database. |
|
Credentials by named credentials stored in management agent to connect database |
|
Vault Credential Details to connect to the database. |
|
User credential details to connect to the database. |
|
Credential Source to connect to the database. |
|
Database connection status. |
|
Configuration parameters defined for external databases instance level. |
|
Configuration parameters defined for external databases. |
|
Configuration parameters defined for external databases instance level. |
|
Initialization parameters for a database. |
|
Details for a bind parameter used in data object query. |
|
Metadata of a column in a data object resultset. |
|
Unit details of a data object column. |
|
Unit details of a data object column of CORE unit category. |
|
Unit details of a data object column of CUSTOM unit category. |
|
Unit details of a data object column of DATA_SIZE unit category. |
|
Unit details of a data object column of FREQEUENCY unit category. |
|
Unit details of a data object column of OTHER_STANDARD unit category. |
|
Unit details of a data object column of POWER unit category. |
|
Information required to form and execute query on a data object. |
|
Time filters to be applied in the data object query. |
|
Unit details of a data object column of RATE unit category. |
|
Information required to execute query on data objects. |
|
Unit details of a data object column of TEMPERATURE unit category. |
|
Information required in a structured template to form and execute query on a data object. |
|
Unit details of a data object column of TIME unit category. |
|
Collection of database insight configuration summary objects. |
|
Supported configuration metric groups for database capacity planning service. |
|
Summary of a database configuration for a resource. |
|
Partial information about the database which includes id, name, type. |
|
Database insight resource. |
|
Summary of a database insight resource. |
|
Logical grouping used for Operations Insights database-targeted operations. |
|
Collection of database insight summary objects. |
|
Database insights data object. |
|
Summary of a database insights data object. |
|
Database parameter details |
|
Information about a diskgroup which includes diskgroup name and ASM name. |
|
Aggregated data per disk. |
|
|
Download Wallet details. |
|
Configuration summary of a EM Managed External database. |
Database insight resource. |
|
Summary of a database insight resource. |
|
EM-managed Exadata insight resource. |
|
Summary of an Exadata insight resource. |
|
Configuration summary of a EM Managed External host. |
|
EM-managed external host insight resource. |
|
Summary of an EM-managed external host insight resource. |
|
|
The advanced feature details for autonomous database to be enabled. |
The information about database to be analyzed. |
|
The information about database to be analyzed. |
|
|
The information about database to be analyzed. |
|
The information about the Exadata system to be analyzed. |
The information about the EM-managed external host to be analyzed. |
|
The information about the Exadata system to be analyzed. |
|
MySQL support within the OCI Ops Insights service has been deprecated as of January 29, 2026. |
|
The information about the host to be analyzed. |
|
|
The information about database to be analyzed. |
|
The information about database to be analyzed. |
The information about the Exadata system to be analyzed. |
|
The information about the MACS-managed external host to be analyzed. |
|
The information about the MACS-managed external host to be analyzed. |
|
MySQL support within the OCI Ops Insights service has been deprecated as of January 29, 2026. |
|
The information about database to be analyzed. |
|
The information about the Exadata system to be analyzed. |
|
The information about the chargeback plan to be enabled. |
|
Enterprise Manager bridge resource. |
|
Collection of Enterprose Manager bridge summary objects. |
|
Summary of a Enterprise Manager bridge resource. |
|
Logical grouping used for Ops Insights Enterprise Manager Bridge operations. |
|
ASM entitie for an exadata |
|
Storage server configuration |
|
Collection of exadata insight configuration summary objects. |
|
Summary of a exadata configuration for a resource. |
|
Configuration summary of a database machine. |
|
Database details and statistics. |
|
Partial information about the exadata which includes id, name and vmclusterNames. |
|
Diskgroup details and statistics. |
|
Configuration summary of a macs managed Exacc exadata machine. |
|
Configuration summary of a Exacs exadata machine. |
|
Host details and statistics. |
|
Exadata insight resource. |
|
|
Resource Capacity samples |
List of resource id, name , capacity time series data |
|
List of resource id, name , capacity insight value, pattern, historical usage and projected data. |
|
|
Object containing current utilization, projected utilization, id and daysToReach high and low utilization value. |
Contains resource statistics with usage unit |
|
Contains resource details and current statistics |
|
Summary of an Exadata insight resource. |
|
Collection of Exadata insight summary objects. |
|
Logical grouping used for Operations Insights Exadata related operations. |
|
Exadata insights data object. |
|
Summary of an exadata insights data object. |
|
Partial definition of the exadata insight resource. |
|
Lists name, display name and type of exadata member. |
|
Storage server details and statistics. |
|
Configuration Summary of a External MySQL database. |
|
MySQL support within the OCI Ops Insights service has been deprecated as of January 29, 2026. |
|
MySQL support within the OCI Ops Insights service has been deprecated as of January 29, 2026. |
|
The historical timestamp and the corresponding resource value. |
|
Resource Allocation metric for the host |
|
Collection of host insight configuration summary objects. |
|
Base Metric Group for Host configuration metrics |
|
Summary of a host configuration for a resource. |
|
Host Containers details |
|
CPU Hardware Configuration metric for the host |
|
Contains CPU recommendation. |
|
Contains CPU statistics. |
|
CPU Usage metric for the host |
|
Partial information about a host which includes id, name, type. |
|
Database entities running on the host |
|
Filesystem Configuration metric for the host. |
|
Filesystem Usage metric for the host. |
|
GPU configuration metrics |
|
GPU processes metrics, processes using GPUs. |
|
GPU performance metrics |
|
Hardware Configuration metric for the host |
|
An agent host entity that can be imported into Operations Insights. |
|
Host insight resource. |
|
Contains recommendations depending of resource metric received. |
|
Contains host details and resource statistics. |
|
Summary of a host insight resource. |
|
Collection of host insight summary objects. |
|
Logical grouping used for Operations Insights host related operations. |
|
Host insights data object. |
|
Summary of a host insights data object. |
|
Object containing hostname and instance name mapping. |
|
Contains io statistics. |
|
Host IO Performance Metrics |
|
Memory Configuration metric for the host |
|
Contains memory recommendation. |
|
Contains memory statistics. |
|
Memory usage metric for the host |
|
Network Activity Summary metric for the host |
|
Network Configuration metric for the host |
|
Contains network recommendation. |
|
Contains network statistics. |
|
Base Metric Group for Host performance metrics |
|
Product metric for the host |
|
Resource Allocation metric for the host |
|
Host Resource Capacity samples |
|
Contains host resource base statistics. |
|
Contains storage recommendation. |
|
Contains storage statistics. |
|
Top Processes metric for the host |
|
Returns a list of hosted entities for the specific host. |
|
Information about a hosted entity which includes identifier, name, and type. |
|
An agent entity that can be imported into Operations Insights. |
|
Collection of importable agent entity objects. |
|
A compute entity that can be imported into Operations Insights. |
|
Collection of importable compute entity objects. |
|
An Enterprise Manager entity that can be imported into Operations Insights. |
|
Collection of importable Enterprise Manager entity objects. |
|
Details applicable for an individual OPSI data object used in a data object query. |
|
Collection of Addm reports |
|
The response object returned from IngestAddmReports operation. |
|
Database Configuration Metrics details. |
|
The response object returned from IngestDatabaseConfiguration operation. |
|
Contains the data to ingest for one or more host configuration metrics |
|
The response object returned from IngestHostConfiguration operation. |
|
Contains the data to ingest for one or more host performance metrics |
|
The response object returned from IngestHostMetrics operation. |
|
Collection of MySql SQL Stats Metric Entries |
|
The response object returned from IngestMySqlSqlStats operation. |
|
Collection of SQL Text Entries |
|
The response object returned from IngestMySqlSqlTextDetails operation. |
|
Collection of SQL Bucket Metric Entries |
|
The response object returned from IngestSqlBucketDetails operation. |
|
Collection of SQL Plan Line Entries |
|
The response object returned from IngestSqlPlanLines operation. |
|
Collection of SQL Stats Metric Entries |
|
The response object returned from IngestSqlStats operation. |
|
Collection of SQL Text Entries |
|
The response object returned from IngestSqlTextDetails operation. |
|
Object containing instance metrics. |
|
Usage data for IO interface per usage unit. |
|
Usage data per io interface. |
|
List of the objects. |
|
|
Configuration Summary of a Macs Managed Cloud Autonomous database. |
Database insight resource. |
|
Summary of a database insight resource. |
|
|
Configuration Summary of a Macs Managed Cloud database. |
Cloud MACS-managed database host insight resource. |
|
Summary of a Cloud MACS-managed database host insight resource. |
|
Database insight resource. |
|
Summary of a database insight resource. |
|
Configuration Summary of Cloud MACS-managed database host insight resource. |
|
Cloud MACS-managed Exadata insight resource (ExaCC) (ExaCS will be supported in the future). |
|
Summary of a Cloud MACS-managed Exadata insight resource (ExaCC). |
|
Configuration Summary of a Macs Managed Cloud host. |
|
MACS-managed OCI Compute host insight resource. |
|
Summary of a MACS-managed cloud host insight resource. |
|
|
Configuration Summary of a Macs Managed External database. |
Database insight resource. |
|
Summary of a database insight resource. |
|
Configuration Summary of a Macs Managed External host. |
|
MACS-managed external host insight resource. |
|
Summary of a MACS-managed external host insight resource. |
|
MySQL support within the OCI Ops Insights service has been deprecated as of January 29, 2026. |
|
MySQL support within the OCI Ops Insights service has been deprecated as of January 29, 2026. |
|
Configuration Summary of a MDS MYSQL database. |
|
MySql Sql Stats type object. |
|
MySql SQL Text type object. |
|
Usage data samples. |
|
Usage data per network interface. |
|
Content types that the news report can handle. |
|
News report resource. |
|
Collection of news reports summary objects. |
|
Summary of a news report resource. |
|
Logical grouping used for Operations Insights news reports related operations. |
|
Summary resource object. |
|
A private endpoint that allows Operation Insights services to connect to databases in a customer's virtual cloud network (VCN). |
|
A collection of Operation Insights private endpoint objects. |
|
Summary of a Operation Insights private endpoint. |
|
OPSI warehouse resource. |
|
Summary of a Operations Insights Warehouse resource. |
|
|
Collection of Operations Insights Warehouse summary objects. |
OPSI warehouse User. |
|
Summary of a Operations Insights Warehouse User. |
|
|
Collection of Operations Insights Warehouse User summary objects. |
Logical grouping used for Operations Insights Warehouse User operations. |
|
Logical grouping used for Ops Insights Warehouse operations. |
|
OPSI configuration. |
|
|
Basic configuration item summary. |
Configuration item summary. |
|
OPSI configuration summary. |
|
An OPSI configuration resource is a container for storing custom values for customizable configuration items exposed by Operations Insights. |
|
Collection of OPSI configuration summary objects. |
|
OPSI data object. |
|
Details for OPSI data object used in a data object query. |
|
Details for a query parameter to be applied on an OPSI data object, when a data object query is executed. |
|
Summary of an OPSI data object. |
|
Details of query parameter supported by an OPSI data object. |
|
|
Details applicable for all OPSI data objects of a specific OpsiDataObjectType used in a data object query. |
Logical grouping used for OPSI data object targeted operations. |
|
Collection of OPSI data object summary objects. |
|
Logical grouping used for Ops Insights Data Store operations. |
|
OPSI UX configuration. |
|
OPSI UX configuration summary. |
|
Logical grouping used for Operations Insights Warehouse data objects operations. |
|
Connection details of the private endpoints. |
|
Input Host Details used for connection requests for private endpoint accessed db resource. |
|
Database insight resource. |
|
Summary of a database insight resource. |
|
Private endpoint managed Exadata insight resource (ExaCS). |
|
Summary of a Private endpoint managed Exadata insight resource (ExaCS). |
|
Configuration Summary of a PeComanaged host. |
|
Private Endpoint host insight resource. |
|
Summary of a Private Endpoint host insight resource. |
|
|
Configuration Summary of a Private Endpoint Co-managed External database. |
The timestamp of the projected event and their corresponding resource value. |
|
Collection of result set rows from the data object query. |
|
Metadata of a column in a data object query result set. |
|
Collection of result set rows from the data object query. |
|
Information required to form and execute query on an OPSI data object. |
|
Information required to form and execute Operations Insights Warehouse data objects query. |
|
Related object details |
|
Report groupings |
|
Chargeback plan report properties. |
|
Resource Capacity samples |
|
Information to filter the actual target resources in an operation. |
|
Current utilization(High/low) for cpu or storage |
|
Projected utilization(High/low) for cpu or storage |
|
Projected utilization object containing dbid and daysToReach value |
|
Contains resource statistics with usage unit |
|
Contains database details and resource statistics |
|
Contains resource usage summary |
|
Aggregate usage samples |
|
Schema object details |
|
Sql bucket type object. |
|
Represents a SQL Insight. |
|
SQL Insights response. |
|
Inventory details. |
|
Inventory details. |
|
SQL Plans for the particular SQL. |
|
SQL execution plan Performance statistics. |
|
SQL plan insights response. |
|
Represents collection of SQL Plan Insights. |
|
SQL Plan Line type object. |
|
SQL Plan details |
|
SQL Response time distribution entry. |
|
|
SQL response time distribution over the selected time window. |
Search SQL response. |
|
Database summary object resulting from a sql search operation. |
|
SQL Statistics |
|
SQL statistics response. |
|
Performance statistics for the SQL. |
|
SQL performance statistics per database |
|
Database details and SQL performance statistics for a given database |
|
|
SQL performance statistics over the selected time window. |
SQL performance statistics for a given plan |
|
|
SQL performance statistics by plan over the selected time window. |
Sql Stats type object. |
|
SQL Text type object. |
|
SQL Text for the particular SQL. |
|
SQL Text details |
|
SQL details |
|
Partial information about a storage server which includes name and displayName. |
|
Usage data samples. |
|
Usage data per filesystem. |
|
Collection of AwrSource summary objects. |
|
|
Collection of resource capacity trend. |
|
Forecast results from the selected time period. |
|
Returns list of the Databases with resource statistics like usage, capacity, utilization and usage change percent. |
|
Resource usage summation for the current time period |
|
Top level response object. |
|
Insights response containing current/projected groups for storage or CPU. |
|
Top level response object. |
|
Collection of resource capacity trend. |
|
capacity results with breakdown by databases, hosts, storage servers or diskgroup. |
|
Usage and Forecast results from the selected time period. |
|
Usage and Forecast results with breakdown by databases, hosts or storage servers. |
|
Returns list of the resources with resource statistics like usage,capacity,utilization and usage change percent. |
|
Resource usage summation for the current time period |
|
Resource usage , allocation, utilization and usage ChangePercent for the current time period |
|
Insights response containing utilization values for exadata systems. |
|
Returns list of hosts with resource statistics like usage, capacity, utilization, usage change percent and load. |
|
Top level response object. |
|
Top level response object. |
|
Top level response object. |
|
Forecast results from the selected time period. |
|
Returns list of hosts with resource statistics like usage, capacity, utilization, usage change percent and load. |
|
Resource usage summation for the current time period. |
|
Top level response object. |
|
Insights response containing current/projected groups for CPU or memory. |
|
Top level response object. |
|
Top level response object. |
|
Top level response object. |
|
Top level response object. |
|
Details of resource usage by an Operations Insights Warehouse resource. |
Contains common summary statistics. |
|
|
The details of onboarded autonomous database need to synchroized with infracture information. |
Usage data samples |
|
Usage data per tablespace for a Pluggable database |
|
|
Connection details of a MACS-managed Autonomous database . |
|
Connection details of a MACS-managed cloud database . |
Aggregated data for top processes on a specific date. |
|
Aggregated data for top processes |
|
Usage data per host top process |
|
The information to be updated. |
|
The information to be updated. |
|
Awr hub source update object information |
|
Configuration item details for OPSI configuration update. |
|
The details used to update a Ops Insights chargeback plan. |
|
The details used to update a Ops Insights chargeback plan report. |
|
Configuration item details for OPSI configuration update. |
|
The information to be updated. |
|
|
The information to be updated. |
|
The information to be updated. |
The information to be updated. |
|
The information to be updated. |
|
The information to be updated. |
|
Database insight resource. |
|
The information to be updated. |
|
|
The freeformTags and definedTags to be updated. |
|
The information to be updated. |
|
The freeformTags and definedTags to be updated. |
The information to be updated. |
|
The information to be updated. |
|
|
The freeformTags and definedTags to be updated. |
The information to be updated. |
|
Database insight resource. |
|
The information about the news report to be updated. |
|
|
The details used to update a Operation Insights private endpoint. |
The information to be updated. |
|
|
The information to be updated. |
Information to be updated in OPSI configuration resource. |
|
Information to be updated in OPSI UX configuration. |
|
The freeformTags and definedTags to be updated. |
|
The information to be updated. |
|
The information to be updated. |
|
Collection of ux configuration item summary objects. |
|
Partial information about the VM Cluster which includes name, memory allocated etc. |
|
Collection of Warehouse data object summary objects. |
|
Warehouse data object details. |
|
Summary of a Warehouse data object. |
|
Details of a TABLE type data object in a Warehouse. |
|
Details of a VIEW type data object in a Warehouse. |
|
A description of workrequest status |
|
Results of a workRequest search. |
|
An error encountered while executing a work request. |
|
Results of a workRequestError search. |
|
A log message from the execution of a work request. |
|
Results of a workRequestLog search. |
|
A resource created or operated on by a work request. |
|
Logical grouping used for Ops Insights Work Request operations. |