DBAs and SysAdmins are called upon to managed and increasing number of DBs and meeting 24/7 SLAs. This talk provides them with best practices and makes use of the Autonomous Health Framework functionality in Oracle 19c+ to proactively preserve performance and availability.
This session focuses on how Oracle is applying Machine Learning technologies in Oracle 19c/20c to prevent performance issues and maintain availability. Autonomous Health architectures and algorithms are covered for both Autonomous Database and on-premise deployments. Deep dive use cases detail their use to proactively detect performance degradation through the phases of detection, root-cause analysis and targeted corrective actions. Actual use cases protecting session, database instances, nodes and storage are presented. Next, diagnostic use cases for rapid recovery monitoring configurations, log and trace files where analysis is based upon anomalous events and record signatures. The final section will cover integration into DevOps processes.This session focuses on how Oracle is applying Machine Learning technologies in Oracle 19c/20c to prevent performance issues and maintain availability. Autonomous Health architectures and algorithms are covered for both Autonomous Database and on-premise deployments. Deep dive use cases detail their use to proactively detect performance degradation through the phases of detection, root-cause analysis and targeted corrective actions. Actual use cases protecting session, database instances, nodes and storage are presented. Next, diagnostic use cases for rapid recovery monitoring configurations, log and trace files where analysis is based upon anomalous events and record signatures. The final section will cover integration into DevOps processes.
This session is aimed at Oracle DBAs, Sysadmins, and their management. It has the following goals: Explain how applied machine learning techniques predict DB operational performance issues for preventive actions and how they can be used to pinpoint event issues for rapid recovery.
How the admin can use the included Oracle AHF functionality to proactively maintain session, instance and node performance against hangs, cpu contention, memory stress, etc.
How the admin can use the included Oracle AHF functionality to rapidly recover from availability issues such as ORA-600’s, instant and node evictions, control file corruptions, etc.
For managers , the business benefit is more efficient database operations management with fewer SLA violations. Customers referenced will be Postbank and British Telecom.