Right size your Exadata system, database, and host with OCI Ops Insights' latest features

February 18, 2025 | 4 minute read
Kathryn Jennings
Senior Principal Product Manager
Murtaza Husain
Director, Product Management - Management Cloud
Text Size 100%:

Oracle Cloud Infrastructure (OCI) Ops Insights, or OPSI, is a powerful monitoring and observability platform designed to enhance the management and performance of various Oracle technologies, including Exadata systems, databases, and hosts. The recent suite of updates introduced by Oracle is a testament to their commitment to innovation in the cloud computing space. These enhancements cater to the unique requirements of DevOps professionals, IT operations teams, Database Administrators (DBAs), and developers, enabling them to excel in the Oracle Cloud Infrastructure (OCI) environment. This blog provides a visual and informative overview of the key features introduced in the upcoming Observability Insights session promoted below. 

Observability and Insights session entitled Right size your Exadata system, Database, and Host with OCI Ops Insights' Latest FeaturesReplay now available here 

Key OCI OPSI features at a glance

GPU Dashboard:

  • A critical component for advanced workload management.
  • Provides a centralized hub for monitoring GPU performance.
  • DevOps engineers can visualize GPU utilization, memory usage, and other essential metrics, enabling prompt issue identification and resource optimization.

Data Explorer and Dashboard Enhancements:

  • Supports bind parameters, a powerful feature for DBAs and developers.
  • Allows for in-depth analysis of SQL execution plans with varying parameters.
  • Facilitates SQL query optimization, resulting in improved database performance.
Data Object Explorer
Figure 1: Data Object Explorer Top 5 SQL trend

 

Dashboard JSON Editor:

  • Customization is simplified with the Dashboard JSON Editor.
  • Users can customize dashboards using JSON, enabling rapid prototyping.
  • Role-specific views can be created, ensuring each team member has access to relevant data.
JSON editor
Figure 2: Dashboard JSON Editor

AutoML for Host IO:

  • Host IO optimization made easy with machine learning.
  • Predicts host IO capacity needs, aiding IT Ops in making informed configuration decisions.
  • Especially advantageous in hybrid cloud setups.
IOPS
Figure 3: Trend and forecasting

Customer-Controlled Collections:

  • Enhances data security and compliance.
  • Users control the data collection process, ensuring alignment with internal standards while leveraging OCI Ops Insights analytics.

Ops Insights in Database Management (OPSI in DBM):

  • Integrates Ops Insights within DBM for a seamless monitoring experience.
  • DBAs gain a unified interface to manage and monitor the database and infrastructure.
  • Streamlines database administration tasks.

 

OPSI to DBM

 

MySQL HeatWave and MySQL External Support:

- OCI Ops Insights now supports MySQL, including HeatWave, an in-memory database engine.
- Enables monitoring and optimization of MySQL performance for high-performance applications.

Observability and Insights session: Right size your Exadata system, Database, and Host with OCI Ops Insights' Latest Features 

The webinar not only showcases these immediate enhancements but also shares developments, promising to revolutionize Exadata and database management in OCI. These upcoming features aim to provide unparalleled operational efficiency, especially in hybrid environments. By attending the webinar, professionals can:

  • Gain first-hand knowledge of these powerful features.
  • Learn how to optimize their Exadata, database, and host management strategies.
  • Stay ahead of the curve in cloud technology, ensuring they maximize the potential of Oracle's cloud infrastructure offerings.

In conclusion, the latest OCI Ops Insights updates offer a comprehensive toolkit to enhance the productivity of various technical roles. Through these visual representations, it is evident that Oracle is dedicated to providing an intuitive and powerful cloud management experience, empowering users to excel in the competitive cloud computing landscape.

Try our Live Labs now.  Learn how to gain applied observability insight using the Oracle Cloud Infrastructure Ops Insights service. Understand how to use its long term capacity planning, SQL performance analysis, database and host resource utilization and capacity capabilities. See how Ops Insights helps you uncover performance issues, forecast consumption, and plan capacity using machine-learning based analytics on historical and SQL data. Then use it to make data-driven decisions to optimize resource use, proactively avoid outages, and improve performance.

 

Resources

 

 

Kathryn Jennings

Senior Principal Product Manager

Murtaza Husain

Director, Product Management - Management Cloud


Previous Post

Observability Insights: Proactively secure Oracle databases with OCI Vulnerability Detection & Patching

Rajendra Patil | 3 min read

Next Post


Observability Insights session: Oracle Fusion applications analyze and optimize performance to improve user experience

Kathryn Jennings | 2 min read
Oracle Chatbot
Disconnected