President & Founder, OraPub Inc. Oracle Ace Director
OraPub, Inc. USA
Suppose you’re doing an AWR or ASH based performance analysis and said, “I’ve NEVER seen this before! We’d better check it out.” What you just identified was an anomalous performance event that warrants your attention. With the help of machine learning and the usual AWR and ASH data, we can confidently detect an anomalous performance event and alert an Oracle performance specialist in under a second! How to do this step-by-step, is what this presentation is all about. Join me as I build a “Performance Anomaly Detector” using 100% free industry standard tools, such as Python with machine learning libraries and the “Always Free” Oracle Autonomous Database with a Jupyter notebook. All presentation slides, scripts, notebook and a recording of the demonstration is available!
Most Oracle performance alerting is based on simple rules. For sure, some statistics are used, but still it’s based on simple rules. With machine learning (ML) we easily go beyond simple rules, because ML algorithms are built to recognize patterns in data. The pattern recognition ability of ML goes far beyond what even a highly trained performance expert could ever hope to achieve. However, most monitoring and alerting systems do not truly use ML, many IT organizations are not ready to embrace ML and many DBAs are not cross-trained in ML. A novel solution to this problem is to use ML to create a list of rules that define “poor performance” based on your real system and real users. These rules may not even make sense to us, but they will take your alerting to a higher level because they are based on your data and ML algorithms. Join me for a fascinating presentation about how to use the results of ML as inputs into your existing monitoring and alerting systems.