In this session, you’ll learn how to use historical cloud and Oracle Enterprise Manager (EM) data to gain insights using ML-based forecasting for capacity planning and avoiding impending database issues, from Exadata, to on-premises databases, and in the cloud. See how to use SQL Warehouse capabilities to identify systemic and recurring SQL issues such as degraded performance and execution plan changes, then address them holistically, rather than one SQL query at a time. You will see demonstrations of OCI Operations Insights cloud service to:
- Obtain aggregate host CPU and memory allocation, utilization, and usage trends for databases running on any system including Exadata, on-premises, or in the cloud
- View current CPU and memory utilization and forecast near-term issues
- Trend and forecast aggregate CPU and memory utilization for all or specific groups of hosts to plan a database consolidation or improve utilization
Join this session to interact with Oracle experts, see demos, and ask questions in the Q&A.
- John Beresniewicz, Architect, OCI