Machine learning can be used for a variety of roles such as troubleshooting, capacity planning, and performance analysis.
Businesses can use machine learning to understand seasonality for trending and forecasting capabilities or view dashboards on data already collected.
Recently, during a DBTA webinar, Courtney Llamas, architect, strategic customer program systems management & security, Oracle; and Timothy Mooney, director, Oracle Product Marketing, discussed taking a proactive, prioritized approach to SQL tuning by leveraging Oracle's advanced analytics to see which databases, and specifically, which SQL IDs, are degrading in performance over time.
Common tasks in Oracle Enterprise Manager for a DBA include alerting, tracking historical metrics, performance tuning a particular database or SQL, database management, and more, Llamas and Mooney said.
The types of data collected consist of metadata, metrics, events/availability, and configuration.
However, DBAs face a multitude of challenges, in a range of areas:
Optimizing Resource Usage
- Which resource will become the bottle in the system based on current load growth from onboarded databases?
- Which systems have available capacity headroom to support consolidation of additional databases?
Maximizing SQL Performance
- Which SQLs are performing better or worse than expected?
- Which of the poor SQLs regressed due to bad plans vs. excessive waits?
- Is the application performance suffering as result of sub-optimal SQL?
Troubleshooting Problems
- Which databases are reporting the most problems and what type?
- How do I correlate from application tier to the database to perform RCA?
Oracle Management Cloud gives users the ability to solve some of these problems and answer these questions, Llamas and Mooney said.
Features of OMC include:
- Global threat feeds
- Cloud access Identity
- Real users
- Synthetic users
- App metrics
- Transactions Server metrics
- Diagnostics logs
- Host metrics
- VM metrics
- Container metrics
- Configuration Compliance
- Tickets & Alerts
- Security & Network events
An archived on-demand replay of this webinar is available here.