Powerful Machine Learning (ML) is upon us. As Oracle DBAs, it is now our turn to leverage ML, enabling us to do things never before possible. But it's not that simple. So, in this presentation I'm going to introduce you to the world of ML from a DBA perspective. This includes understanding what ML is,…

A number of polls taken during various PL/SQL-related presentations paint a very strange picture: one of the most-critical FREE server-side performance-tuning tools is almost totally unknown! If you ask basic questions such as, “How much time is spent on routine A?” or “How often is function B called?” most developers would start to hand-code their…

Imagine being able to prove a performance problem is not a database issue. There are few ways to infer the problem resides elsewhere, but it's difficult for people to believe you. However, by creatively using ASH data and the idle wait event "SQL*Net message from client" we can do this. In this presentation, I will…

  This session answers the question, “What’s new in Oracle Database 19c?” in a slightly different way: by providing best practices and a deep dive into the most impactful high availability (HA), scalability, and lifecycle management features in Oracle Database 12c, 18c and 19c, including a short roadmap of features yet to come in the…

  Join executives who produce Oracle Enterprise Manager and Oracle Management Cloud to learn what’s coming up in Oracle’s flagship management offerings. Product leaders will discuss how to extend your manageability best practices to Autonomous Database, Exadata Cloud and Oracle Cloud Infrastructure as well as showcase new features for analytics, automation and troubleshooting a hybrid…

  Oracle Database 19c is the long-term support release for the Oracle Database 12c and Oracle Database 18c family, and many customers are actively planning their upgrades. This session from the Oracle Database Upgrade development team gives you the inside scoop on how upgrade has evolved (especially if your last upgrade was to 11.2.0.4). Learn…

Anyone who’s familiar with tuning SQL knows that you need to get the execution plan for a query. But once you’ve got an execution plan, what do you do with it? Everyone understands that an execution plan is important for diagnosing, but almost no one knows how to answer questions like “which step in the…