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,…

  Oracle Database 19c has hundreds of powerful features that help secure your data, and new capabilities are added with every release. In this session join Oracle product managers to discover 10 security features you may not be aware of. These features can help you streamline user administration, reduce your attack surface, deploy more-secure applications,…

  Oracle Database 19c has hundreds of powerful features that help secure your data, and new capabilities are added with every release. In this session join Oracle product managers to discover 10 security features you may not be aware of. These features can help you streamline user administration, reduce your attack surface, deploy more-secure applications,…

  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…

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…

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…

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…

  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…